Excel 2013 64 Bit Windows 7 64 bit DNS Less Driver Connection Error

Connectivity
Tourist

Excel 2013 64 Bit Windows 7 64 bit DNS Less Driver Connection Error

I have been using Windows 7 64 bit and Excel 2010 and using the connection string...

Provider=MSDASQL.1;Extended Properties=Driver={Teradata};DBCName=MyDBCName;maxrespsize=1048576;UID=MyUID;PWD=MyPW;

in Excel VBA to establish an ADO connection.

But one of my computers was upgraded to Excel 2013 64 bit and now I am getting a connection error "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

The driver installed on the maching is 13.10.00.07 and the file name is TDATA32.DLL.

I am assuming this is a 32 bit driver.

My user are going to using Excel 2010 and 2013 64 or 32 bit, can they have this driver to connect with using Excel 64 bit?

It would be crazy if I have to upgrade everyones driver to the Teradata 64 bit version. Thank You!

Tags (3)