Home Forums Data Warehousing Integration Services How to create a Connection Manager to access directly to a PROGRESS DB RE: How to create a Connection Manager to access directly to a PROGRESS DB

  • Hi many thanks.

    I did a lot of test..and i did that.

    I WAS ABLE to connect Progress DB in SSIS 2008 r2 using a trial version of PROGRESS DATA DIRECT odbc driver.(We have a SERVER 64 BIT with a Window Server system 2008)

    I WAS NOT ABLE with Progress OpenEdge Driver ODBC that our System Administrator installed on our server.

    But i have license only of second type of driver and not for the first...so i decide to work with LINKED SERVER Object.In this case, also with LINKED SERVER i was able to connect.

    The strange thing, it is that also LINKED SERVER needs of an Odbc driver,,,

    And i use OpenEdge Driver ODBC.

    So i really think it is a mix of problems of APPLICATION that i should want use (SSIS or LINKED SERVER) and version 32 bit.

    Any idea ???

    What kind of Driver Odbc do you use ????

    Regards in advance,

    PS. The name of dll installed of OpenEdge Driver is called pgoe1024.dll.

    I read that clicking ABOUT on DSN Confgiuration in Administrator Data Source.

    Ciao and thanks for all.

    Have a good week-end.