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

Connectivity
Highlighted
Enthusiast

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)

Accepted Solutions
Teradata Employee

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

A 64-bit process (e.g. Excel 2013 64-bit) cannot load a 32-bit DLL/ODBC Driver. 

Therefore you must install the 64-bit ODBC Driver for Teradata. The newer version of the driver has just one setup program; it automatically installs 32-bit and 64-bit versions of the driver on a 64-bit OS.

1 ACCEPTED SOLUTION
2 REPLIES
Teradata Employee

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

A 64-bit process (e.g. Excel 2013 64-bit) cannot load a 32-bit DLL/ODBC Driver. 

Therefore you must install the 64-bit ODBC Driver for Teradata. The newer version of the driver has just one setup program; it automatically installs 32-bit and 64-bit versions of the driver on a 64-bit OS.

Enthusiast

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

Thank you for your reply.

After more digging I came to your conclusion. We and we are making sure our users have both drivers.

 

Thanks Again!