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

  • Ciao.

    Many thanks for your reply.

    I did what you wrote 2 weeks ago.

    But i encountered this error.

    TEST CONNECTION FAILED BECAUSE OF AN ERROR IN INITIALIZING PROVIDER

    ERROR IM14 MICROSOFT ODBC MANAGER ...The specified DSN CONTAINS an architecture mismatch between the dirver and the application....

    I think it is a problem of 32 OR 64 BIT driver versus application,

    Someone explained me that SSIS is a 32 bit application even if the S.O windows server is 64 bit operating system Windows Server 2008.

    I REALLY do not know if who prepared server...., installed 64 or 32 bit odbc driver.

    How can i discover that ???

    With linked server the same odbc it works and i did some SSIS (with some problems i wrote in another topic..but it works)..

    But with a ODBC direct connection i encountered this error...IM14

    I installed also a DATADIRECT ODBC Driver 64 bit TRIAL version , and it worked too....

    Only with Open Edge Driver not,,so at the momenti i decided to use LINKED SERVER even if i understand it is a slower approach to pull data...

    Besides both using SSIS with DATADIRECT 64 bit driver ODBC and LINKED SERVER...READING a table of 6.000.000 of rows i redirect rows for 54.000 records.

    The error in this case , is an error very strange wtih code -1071607685This error means NO STATUS AVAILABLE...and it not easy to solve it .....

    Did you encountered any similar problems pulling data from OPEND EDGE DB Progress ???

    Many thanks if you should want to reply...

    Ciao Mauro.:-)