ADO/ Merant 3.6 problem

[bjackson]

Is anyone out there using the Merant 3.6 ODBC Driver with the Progress DataBase
engine, version 9.1C , connecting with ADO in a VB6.0 application?

I am having all kinds of trouble creating a RecordSet , and I'm almost
certain that it is Syntax related. I'm using a Connection String and successfully
connecting , but beyond that point, the Driver does not like me asking for
recordsets using a sql String w/ cmdtext, or even asking for a Table w/ cmdTable.

I was using the Merant ODBC ver. 3.5 with progress ver. 9.1A with no problems.

Ive gotten some much appreciated help from Neil, but my Syntax still seems to be a problem and I cannot create RecordSets. The major merant Error is #7519-Table/View/Synonym Not Found.

Thanks

 

[MurrayH]

Ahh yes I have seen this .. quite some time ago. I seem to remember it was something to do with needing the "pub." on the front and VB no liking it. Anyway here is some code that I seem to remember worked .. once. librasportsv9 is the ODBC datasource I set up for the DB.

Hope this helps

Murray

Private Sub Form_Load()
Dim db As Connection
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=MSDASQL;dsn=librasportsv9;uid=myuser;pwd=;database=sports;"

Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "select * from pub.customer", db, adOpenStatic, adLockOptimistic

Set grdDataGrid.DataSource = adoPrimaryRS


mbDataChanged = False
End Sub