ODBC 64 bit driver issue on Windows 7

Connectivity

ODBC 64 bit driver issue on Windows 7

I have tried various ODBC 64 bit drivers from your website for Windows. The setup executes without any issues but the 64 bit driver does not show up in ODBC administrator nor in the registry. I am trying to connect MicroStrategy Desktop v10 with Teradata and it can only work on 64 bit ODBC driver.

Accepted Solutions

Re: ODBC 64 bit driver issue on Windows 7

After a bit of troubleshooting and not giving up my patience, I read quite a few blogs and now it works.

 

The issue was with MicroStrategy and some remnant files that had to be removed. See

https://community.microstrategy.com/t5/Web/TN308912-quot-Failed-to-create-report-instance-Object-wit...

 

Thank you Teradata team for assisting in the driver install options.

1 ACCEPTED SOLUTION
7 REPLIES
Teradata Employee

Re: ODBC 64 bit driver issue on Windows 7

Can you be more specific about which download you are using?

 

For Windows, we recommend that you use the full "TTU - Windows Install" download and then use the dialog to select the client software that you need, or else use one of the newer "ODBC Suite" install packages. .

 

You can find them at http://downloads.teradata.com or through the Teradata at Your Service portal.

 

If you are manualy installing or using an older release, be sure TeraGSS and TDICU are installed first, before installing ODBC.

Re: ODBC 64 bit driver issue on Windows 7

I have tried downloads from ODBC_Suite 16.0,  15.x as well as 14 (_x8664). Somehow what seems to be happening is the 32 bit ones show up in the registry tdata32.dll and ODBC administrator can also see the Teradata driver but they don't appear to be the 64 bit dll's that perhaps Microstrategy is looking for. I will try the full TTU install and see if that works.

Re: ODBC 64 bit driver issue on Windows 7

Even after installing TTU, when I check ODBC 64 bit administrator it shows - 

Name     Version          File

Teradata  15.10.01.01  TDATA32.DLL

 

Can someone please advise if there is a TDATA64.DLL ?

Teradata Employee

Re: ODBC 64 bit driver issue on Windows 7

Please execute the "TeradataListProducts.exe" to see if the 64-bit TD ODBC Driver is installed.

If it's listed, then, you need to execute the 64-bit version of ODBC Administrator (64-bit ODBC Administrator)

to create the 64-bit ODBC DSN. The DSN you created in 32-bit ODBC Administrator won't list any

64-bit DSN as they are not compatible. From the Start ->All Programs -> ODBC, you should see two

versions of ODBC Administrator from the list.

Teradata Employee

Re: ODBC 64 bit driver issue on Windows 7

There is no "tdata64.dll", only "tdata32.dll. 64-bit version of tdata32.dll is located in different Registry location

than 32-bit dll which is located in \Software\Wow6432Node folder in the Registry.

Re: ODBC 64 bit driver issue on Windows 7

This is what shows up when I run TTUListProducts and it appears if I'm reading it right, that there is a ODBC Driver nt-x8664 installed.

15.10.00.02           Teradata SQL Assistant 15.10.0.2
15.10.01.00           Teradata GSS Client nt-i386  15.10.1
15.10.01.00           Teradata GSS Client nt-x8664  15.10.1
15.10.01.01           ODBC Driver for Teradata 15.10.1.1
15.10.01.01           ODBC Driver for Teradata nt-x8664 15.10.1.1
15.10.01.01           Shared ICU Libraries for Teradata 15.10.1.1
15.10.01.01           Shared ICU Libraries for Teradata nt-x8664 15.10.1.1
15.10.01.01           Teradata CLIv2 15.10.1.1
15.10.01.01           Teradata CLIv2 nt-x8664 15.10.1.1
15.10.01.01           Teradata Data Connector 15.10.1.1
15.10.01.01           Teradata Data Connector nt-x8664 15.10.1.1
15.10.05.00           Teradata Tools and Utilities - Base 15.10.05

 

My registry shows this.

C:\Program Files\Teradata\Client\15.10\bin\tdata32.dll under HKEY_LOCAL_MACHINE in the ODBC/ODBC.INI section where I created my DSN through the 64 bit ODBC administrator.

The ODBCINST.INI shows

Driver = C:\Program Files\Teradata\Client\15.10\bin\tdata32.dll

Setup = C:\Program Files\Teradata\Client\15.10\bin\tdatas32.dll

DriverODBCVer = 03.51 and under ODBCDrivers I can see Teradata Installed.

However, when I launch Teradata SQL Assistant, I cannot see my DSN that I created. I'm sure there is something that i'm missing.

 

Does it look from the above, that I've the correct x64 driver installed ? Not sure, why my DSN name is not showing up in my SQL assistant even though it shows up under ODBC administrator for 64 bit. -

Re: ODBC 64 bit driver issue on Windows 7

After a bit of troubleshooting and not giving up my patience, I read quite a few blogs and now it works.

 

The issue was with MicroStrategy and some remnant files that had to be removed. See

https://community.microstrategy.com/t5/Web/TN308912-quot-Failed-to-create-report-instance-Object-wit...

 

Thank you Teradata team for assisting in the driver install options.