Konek ke MsSQL Express pada asp classic

berikut cara konek ke ke MsSQL Express pada asp classic

<%
vServer = "namaPC\SQLEXPRESS"
vPwd="password1"
vUid="user"
set cn = server.CreateObject("ADODB.Connection")
cn.open "driver={SQL server};server=" & vServer &";uid=" & vUid & ";pwd=" & vPwd &";database=testDATABASE"

sSQL = "select * from database.dbo.test"
set rs = cn.Execute(sSQL)
%>

Posting Lebih Baru Posting Lama

Leave a Reply