ADO Recordset

[MJPPaba]

Hi All,

Im fairly new to Sybase but reasonably familiar with SQL and competent with Access etc.

My problem is this, I have an sybase warehouse and an access client end database.

my code is...

Dim myCnn As ADODB.Connection
Dim myRST As ADODB.Recordset

mySQL = "SELECT * "
mySQL = mySQL & "From myTable "

Set myCnn = New ADODB.Connection

myCnn.Open "driver={SYBASE SYSTEM 11};srvr=mySvr;database=myDbase;uid=myUserID;pwd=myPwd"

Set myRST = New ADODB.Recordset

myRST.Open mySQL, myCnn

MsgBox myRST.RecordCount

myCnn.Close

Set myCnn = Nothing



result are -1 in the msgbox.

where am I going wrong?

Cheers

Matt

 

[mansii]

Try adding CursorType:

myRST.Open mySQL, myCnn, adOpenStatic

Hope this helps

 

[MJPPaba]

Thanks Ill give it ago