SQL Connection

actually : www.connectionstringS.com
 

yeah, i figured i wouldn't put my password and db name etc on here.

Isn't there a way to open a recordset without also opening a connection?

btw, I'm still getting a type mismatch error from your code inviser

try this:

Dim DSN, DatabaseUsername, DatabasePassword, DatabaseName, DatabaseHost, Conn, rsTest

DatabaseUsername = "<whatever>"
DatabasePassword = "<whatever>"
DatabaseName = "<whatever>"
DatabaseHost = "<whatever>"

DSN = "Provider=SQLOLEDB;" & _
"User ID=" & DatabaseUsername & ";" & _
"Password=" & DatabasePassword & ";" & _
"Initial Catalog=" & DatabaseName & ";" & _
"Data Source=" & DatabaseHost & ";" & _
"Persist Security Info=True;" & _
"Connect Timeout=20"

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open DSN    

Set rsTest = Conn.Execute("select * from tblUsers where active = 1")

ok, that's working.  i guess it might even work better than what i wanted to do - more re-usable code anyways.

but am I crazy thinking I used to do this without an explicit connection object?

>>but am I crazy thinking I used to do this without an explicit connection object?<<
That is possible, you just have to code it right :)


Conn = "Driver={SQLServer};Server=[server];Database=[db];Uid=sa;Pwd=[pwd];"
Set rsTest = server.createObject("adodb.recordset")
sqlTest = "select * from tblUsers where active = 1"
rsTest.open sqlTest, Conn, 3, 3

what is the datatype of active?  is it a string? maybe it should be:
sqlTest = "select * from tblUsers where active = '1'"

Your original code should be fine, you just appear to have an extra comma in the line:

    rsTest.open, sqlTest, Conn, 3,3


Remove the comma immediatley after "open" and you should be set.

OK,

the data type of active is int.

**************

Conn = "Driver={SQLServer};Server=[server];Database=[db];Uid=sa;Pwd=[pwd];"
Set rsTest = server.createObject("adodb.recordset")
sqlTest = "select * from tblUsers where active = 1"
rsTest.open sqlTest, Conn, 3, 3

still gets me an error as does my original code without the additional comma.  I assume the problem is in the connection string?

**************

Conn = "Driver={SQLServer};Server=phweb\LNIPHX;Database=lni;Uid=sa;Pwd=password;"


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/db/conn.asp, line 18




BUT this works in inviser's method....

DatabaseUsername = "sa"
DatabasePassword = "password"
DatabaseName = "lni"
DatabaseHost = "phweb\LNIPHX"


******************


To be honest I'm not sure that I don't like inviser's method better.  I've just always used the other method (like acperkins example) and the fact that I can't make it work is driving me nuts.  

raised the points.  didn't think this would be open ten minutes.