ODBC-less connections with SQL server

[LucyP]

Why is it that when I try to connect to SQL server (ASP using VBScript) without using ODBC - i.e. specifying the driver and server in the connection string - I cannot make a recordset. The error message tells me that the connection object is closed. Do all of the books have typos in the sections where they tell you how to do this????

 

[krkX]

you should try something like this:
ostr = "driver={SQL Server};server=[servername];database=[databasename]"
set cn = Server.CreateObject("ADODB.Connection&quot
Set rs = Server.CreateObject("ADODB.RecordSet&quot
sql = "SELECT * FROM [tablename]"
cn.open ostr
rs.open sql, cn, 3, 3

this way you ope you recordset for read, write, update and delete.

Goodluck..



(ps: change the stuff between [])