Tuesday, December 4, 2007

How do you access the database through OLEDB

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: