TPT DSN Error

Our enterprise teradata version is 13.10.07.12. I have installed TTU 15 on our 64bit windows server. While trying to use TPT wizard to connect to SQL Server using odbc DSN I am getting Driver Error: There was an error initializing the driver for usage.

I am using Microsoft sql server native client 10.0 odbc driver. I know that this driver is not recommended but that is all I can afford to use as it is free.

I can connect to sql server using tpt wizard with out any issues on my local 32 bit xp machine. I have generated a tpt script on my local machine and ran it on our windows server. Script ran sucessfully but exported zero rows...

Re: TPT DSN Error

We always recommend that you keep current with the latest efixes/patches of our client software. By that, I mean if you have version 14.10, then keep up-to-date with the patches. If there is an issue, we cannot assist unless you are at the latest version.

If you have, say, a 14.10 version of the DBS, it does not necessarily mean you should upgrade your client to 15.0 or 15.10. Most people try to keep the client and database versions at the same level.

However, our client software supports 3-4 releases of Teradata, so you will not run into issues if you have an older database release than client.