Progress with odbc and tricky table names

HCL Domino Domino Forum
1

Hi,

I am using a piece of Lotusscript to do an ODBC connection form a notes db to a Progress db. I have added the necessary drivers in my System DSN.

I tested the odbc conntection by linking one of the tables using microsoft access.

When I run the script I get a connection okay, but I run a query on the progress db amd appear to get nothing back.

I use “SELECT * FROM PRO1.AREA”

“con.ListTables(dsn,uid,pw)”

The script can’t seem to see any of the tables when I try to return a list of them.

I thought it might be a problem with all of the tables containing the period character.

has anyone done this before?

TIA,

JaMeS

2

Subject: Progress with odbc and tricky table names

Generally speaking you can wrap table names in double quotes and it should work. For example, SELECT * FROM “PRO1.AREA”. I would suggest using an alias for simplicity later in the query.

I have no worked specifically with Progress so your mileage may vary. You may also want to post in the Enterprise Integration forum.

HTH,

Charles

3

Subject: RE: Progress with odbc and tricky table names

Many thanks charles,

However this did not solve my problem.

I used |SELECT * FROM “PRO1.AREA”|

but this did not work, I have heard of table aliases but notes should still return the tables regardless of their names?

I have also posted in the EI forum.

TIA for any more advice,

JaMeS