MS SQL Unable to retrieve recordset 1

[44nato44]

Hi
I am able to connect to the db, but unable to retrieve a recordset.

Does anybody has one that for sure works ?

Cheers

<!-- #Include File="adovbs.inc" -->
<%


set adoconn = server.createobject("adodb.connection")
set adoRec = server.createobject("adodb.connection")
adoconn.open = "Provider = sqloledb; Data Source = MYSRV; Initial Catalog = TestDB; User Id = Test.User1; Password = Entity48;"


adoRec.Open "SELECT Name FROM tblName", adoconn, adOpenKeySet,adLockOptimistic,adCmdText


adoconn.Close
Set adoconn = Nothing

%>

 

[gmmastros]

Maybe....

set adoconn = server.createobject("adodb.connection")
set adoRec = server.createobject("adodb.[!]RecordSet[/!]")

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[44nato44]

Thanks gmmastros,

I had a feeling I had stired blind on it all. )