We have SQL 2016 running on Windows 2012 R2. Requirement is to connect to Teradata database running on another server and pull data. We tried to setup linked server using 64 bit Teradata ODBC driver(V 16.10.20) . But getting error when we do test connection. Below is the error message:

The provider did not give any information about the error. Cannot initialize the datasource object for the OLEDB provider for MSDASQL for linked server ....(Microsoft SQL Server error 7399).

We are able to set up a linked server definition from SQL 2005 from windows 2003 server to the same Teradata server using 32 bit OLE DB driver for teradata.

Any help on this would be much appreciated.

New contributor
Mangaiyarkarasi Shivaa is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Your Answer

Mangaiyarkarasi Shivaa is a new contributor. Be nice, and check out our Code of Conduct.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.