ADO connection to 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

 

[fredericofonseca]

the record count on the record set object is not reliable, and it depends on the driver used, the type of cursor used (Client side is a must for it to work), and eventually on other things related to both the connection and the recordset object.

If you only need the count then you should change the SQL to do just that. Otherwise you will need to revise your object properties, and try it out until if find the correct settings, but bear in mind it may not be possible depending on your driver. (unless you loop through the whole recordset!!)

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[SkipVought]

Hi,

You could also LINK the Sybase table into your Access database. Then it will act like any other table when you query.

Skip,

_[red][/red]

 

[MJPPaba]

Hi Skip,

Unfortunately, I had to resort to doing this course of action.

Thanks old friend,

Matt