![]() ![]() ![]() Any ideas what's wrong? It's almost like the SQL Server can't see the 32-bit drivers. (Microsoft SQL Server, Error: 7303) This is our linked server setup: Provider: Microsoft OLE DB Provider for ODBC Drivers Product name: DATADIRECT 4.10 32-BIT Progress SQL v9.1e Data source: DATAWH Provider string: DSN=DATAWH DB=warehouse UID=sysprogress PWD=sysprogress HOST=hlsprog1 PORT=2907 This same setup worked fine on our 2005 SQL Server w/32-bit OS. OLE DB provider "MSDASQL" for linked server, "DATAWH" returned message " Data source name not found and no default driver specified". 'ODBC: ERROR 08001 FATAL: password authentication failed for user. Updated: Unable connect Oracle DB via ODBC. But when we try to create a linked server, we get the following error: Cannon initialize the data source object of OLE DB provider "MSDASQL for linked server "DATAWH". Add another string value with Name ODBC call to connect database failed with error: ODBC call for data source The odbcinst. When we do a test connect back to our Progress database, it says it was successful. Windows 2003 R2 64-bit, SQL Server 2008 64-bit, Progress DataDirect 32-bit 9.1e ODBC drivers We have successfully created a DSN using the 32-bit ODBC driver with the 32-bit DSN manager.
0 Comments
Leave a Reply. |