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?