I think it is a problem of 32 OR 64 BIT driver versus application, The specified DSN CONTAINS an architecture mismatch between the dirver and the application. TEST CONNECTION FAILED BECAUSE OF AN ERROR IN INITIALIZING PROVIDERĮRROR IM14 MICROSOFT ODBC MANAGER. I DO NOT KNOW what kind of connection i ha ve to choose and how to configure. If anyone can help me with also examples, i will be very happy. Why cannot i to create a right connection in SSIS ? (But linked server is little slow and have some limitations to query some features of PROGRESS DB.(extent, name fields with minus and so on). I WAS able also to connect with linked server using my DSN, I tried to connect with my DSN in EXCEL POWERPIVOT or Reporting Services, and I WAS ABLE TO. Is it possibile that PROGRESS DB Vendor not compatible with SSIS ? Has anyone ever used a direct connection to PROGRESS DB ? I have to create an ADO.NET or OLEDB CONNECTION type ? I created also a DSN and this DNS connectioon, was tested okay.īut i cannot understand where to create and how in SSIS. In our SQL SERVER server machine, i installed a driver ODBC PROGRESS. I am not able to add a connection manager in a SSIS.Ĭlearly i am not able to add a connection manager that connects directly a PROGRESS DB. My question is about to SSIS in SQL SERVER 2008 R2 and especially is that: I ha ve a quite good experience in SSIS and SSAS 2008 R2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |