How to connect ODBC through Progress OpenEdge DB to MS Excel

Posted by Admin on 03-Apr-2007 04:56

How to connect Progress OpenEdge Database to MS Excel VBA through ODBC. Please, provide simple example for this.

All Replies

Posted by amzad on 25-May-2007 14:26

WindowsXP:

Start>Run: odbcad32.exe, you will see the ODBC Data Source Administrator.

Click Add button, choice MERANT 3.60 32 BIT Porgress SQL92.v91D (it may diffrent with your version), that is choice MERANT.

click finish button. Now fillup the driver set up window: Data Source Name: as you like (say sportsodbc), Host Name:localhost,

Database Name: sports2000, User ID: amzad (as you loged in). Click Test Connect, it may ask your password. Enter Password that is associate with your user name.

If everyting nice - DataDirect Technologies Progress SQL92 ODBC Driver window will apear with message "Connection established!

Here you go. Now you have ODBC bridge, no matter what language (PHP, JAVA,..) and where you will display (Excell, Browser, Text file,..) data.

To display Excel VBA follow the below link:

http://support.microsoft.com/kb/257819

Thanks!

~ Amzad

Posted by Admin on 02-Jul-2007 00:43

please can anyone tell me how to conncet progress database using odbc ? i tried for that like as

Start>Run: odbcad32.exe, the ODBC Data Source Administrator.

Click Add button, choice MERANT 3.60 32 BIT Porgress SQL92.v91D

click finish button.

fillup the driver set up window: Data Source Name: say sportsodbc,

Host Name:localhost,

Database Name: sports2000, User ID: chowdhury (as loged in).

Click Test Connect, it ask your password. Enter Password that is associate with user name.

But after that error messge appeared lilke "No Data "

So, Please tell how to resolv this problem or where i am in wrong.

Regards,

This thread is closed