connecting to sql Server

[99mel]

All i'm trying to do is bring back some data from a table in SQL Server

I am running a .asp file through IIS which contains the following code:

Set objConnection=server.CreateObject("ADODB.Connection&quot
objConnection.open "Driver={SQL Server};Server=servername;Database=dbname;uid=uid;pwd=password"


It seems to connect fine using the above code.. i then get the error :

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

when trying to run this syntax:

set rsEmployee = server.CreateObject ("ADODB.Recordset&quot
mySQL = "Select firstName, lastName FROM table"
rsEmployee.Open mySQL,cntBPstr,adOpenForwardOnly,adLockReadOnly



Gotta be somert really simple?

Cheers for any help!

 

[99mel]

Oops!

just ignore that last post, apart from none of the attributes matching up n everything! i got it working!

i took out the adOpenForwardOnly,adLockReadOnly on the open of the recordset tingy bit and it works fine! are these attributes not supported or somert?