How to connect ODBC through Progress OpenEdge DB to MS Excel VBA - Forum - OpenEdge RDBMS - Progress Community

How to connect ODBC through Progress OpenEdge DB to MS Excel VBA

 Forum

How to connect ODBC through Progress OpenEdge DB to MS Excel VBA

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

  • 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

  • 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,