ODBC for PROGRESS 1

[nataliacrespo]

Hello!
I am new in Progress and I don't know how I could connect to Progress by ODBC.
I need the driver, but I don't know where I cant get it.
My application is developed in VB.

Thanks a lot.


Natalia.

 

[kikigirl]

The below link is a guide to the Progress ODBC driver

http://www.progress.com/v9/documentation/sql92/odr/odr.pdf

The below link is a pdf that lists the various
software/licenses that will include the driver.

http://psdn.progress.com/library/whitepapers/sql92/crystal_get_started.pdf

The below is a link of quite a few resource links on the driver.

http://psdn.progress.com/library/sql.htm

Hope these help.

 

[EpicXtreme]

I've used Openlink to connect to Progress, you can try that.

Carmelo Brual (IT Specialist)
Citrix Administrator
Progress DBA
Cognos Administrator

 

[GandalfNJ]

If Progress is installed on the PC that you are using there should be a "MERANT 3.60 32-BIT Progress SQL92 v9.1B" Driver that you can use in the Windows ODBC Data Source Administrator, under the System DSN tab. I have successfuly connected to our progress DBs from MS-Access using this. All the database tables will be preceded with the "PUB_" prefix (PUB_custname).

 

[lucky10]

Hi,

I am using Merant 3.60 32 BIT Progress SQL92 v9.1A, when I send a query using Data Source to Progress:

SELECT * FROM TABLE;

The ODBC reports the following error:

[MERANT][ODBC PROGRESS driver][PROGRESS]Table not found

The prefix PUB_ doesnt work.

The table exists and the name is correct in the Progress DataBase.

Please help me!!!
Thanks in advance

 

[simonql]

Try select * from pub.Table
It may reject this if Table is a reserved word. In that case, use
select * from pub."table"