VB6 connection to Progress Database

[rdmaday]

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?

[Hack]

Welcome to DevX

Do you have a support contract with them? Have you tried their support line?

[rdmaday]

We do not have support with them...I am checking out their forums as well.

[Hack]

Well, you are a customer. That should account for something.

I just don't know how many folks on this site have any experience with Progress databases (I sure don't)

[Toan Nguyen]

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.

[rdmaday]

I have tried everything that you have said and have the following results.

Using new ODBC driver - yes
Connection to database - successful
Tried application in debug mode - yes

The application bombs when running a SQL statement that is requesting data from a table name that has a "-" (hyphen) in it. If I comment out the code and rerun the program it works just fine.

My dilemna is this: Run the same query from Microsoft Access and it returns results...run from Visual Basic and the code bombs. They are both referencing the same ODBC driver.

Any thoughts on why this would be?

[Toan Nguyen]

show the sql