VB6 connection to Progress Database
For the last 5 years we have been using a Progress 9.1C database and have been able to successfully connect to the database to pull information via a VB6 application. Recently, our database was upgraded to Progress 10.1A and our application no longer works. We have installed the Progress OpenEdge 10.1A ODBC drivers on the machines, but now receive an error message when executing the application.
The error message is
"Run-time Error '-2147467259 (80004005)':
[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax Error at or about %s(statement excerpt). (10713)"
I have tried everything that is listed on Progress' website, but to no avail.
I have traced the error message to a SQL statement in VB that has a Progress table name containing a hypen in it. Other queries to the database run just fine. I can run the same query using Microsoft Access 2003/2007 without issue.
Does anyone have any idea what I can do to fix this issue?
Basic Troubleshooting 101
Basic db troubleshooting 101.
You have a db.
You have a connector
You have an application.
One point in the chain is failing.
Have you tried connecting to the db with windows odbc (control panel->administritive tools->data sources(ODBC)) ? Is your application using the newer datasource driver?
Setting up a link via another application like access to connect to the db?
If the link works, then check the application.