DB Connection Problems

[enak]

I have an ASP that I connect to a db when I submit the page. I have the following code:

set rs = server.CreateObject("ADODB.Recordset&quot

sSQL = "select * from evaluations where evaluatorid = " & Request.Form("TimeKeeper&quot
strConn = "Driver={SQL Server}; Server=Enaksystems; Database=AKData; Uid=evaluser; Pwd=pwdeval;"

set akdataConn = Server.CreateObject("ADODB.Connection&quot
akdataConn.Open(strConn)

rs = akdataConn.Execute(sSQL)

The Execute command has the following parameters:

Execute(CommandText, RecordsAffected, [Options])

This is the ADO 2.7 version but I want to use ADO 2.6 which does not require "RecordsAffected".

How can I change this? I do have .net installed on the same machine.

TIA
Nate

 

[mwolf00]

Doe this line throw an error?
rs = akdataConn.Execute(sSQL)

seems that even if you have 2.7, you would still be able to use this code (or everyone would have to rewrite a lot of code when then "upgrade" to 2.7) Get the Best Answers! faq333-2924
"A witty saying proves nothing." - Voltaire
mikewolf@tst-us.com

 

[enak]

OK, for some reason everything seems to be working. Thanks!