Welcome to the Teradata Developer Exchange discussion forums.
For a general introduction and guidelines on posting, please see
this forum topic.
RSS feeds are available for each forum, as well as a combined
all forums feed.
We have to migrate an Application using 32Bit SQL 2005 SP2 which connects to Teradata via linked server to 64Bit SQL 2005 SP2. The problem is there is no (reffering to our Teradata-contacts maybe will never be) 64Bit OLEDB for Teradata. So I tried Teradata ODBC x8664 13.0.0.0 with MSDASQL 2.82.4250.0 64Bit (OLEDB-Provider for ODBC), but I don't get it to work (I get an error 7399 saying (translated from german) "databaseobject of MSDASQL can't be initialised for the linked server") - but I'm not sure which parameters should be set using "exec sp_addlinkedserver" and what values these parameters should get.
We have to migrate an Application using 32Bit SQL 2005 SP2 which connects to Teradata via linked server to 64Bit SQL 2005 SP2. The problem is there is no (reffering to our Teradata-contacts maybe will never be) 64Bit OLEDB for Teradata. So I tried Teradata ODBC x8664 13.0.0.0 with MSDASQL 2.82.4250.0 64Bit (OLEDB-Provider for ODBC), but I don't get it to work (I get an error 7399 saying (translated from german) "databaseobject of MSDASQL can't be initialised for the linked server") - but I'm not sure which parameters should be set using "exec sp_addlinkedserver" and what values these parameters should get.
Best regards, B.G.