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.