How do you access the database through OLEDB
Access the database through OLEDB
<%
set conn=Server.CreateObject("ADODB.Connection")
conn = "Provider=SQLOLEDB.1; Data Source=C:\inetpub\wwwroot\crm\testData.MDF; Driver={SQL Server};Server=Jaguar "
set rs=Server.CreateObject("ADODB.Recordset")
rs.open "select * from allrecord", conn, 1,3
do while rs.eof <> true
response.write(rs("email"))
response.write("
")
rs.movenext
loop
%>
No comments:
Post a Comment