Hey Vhari, I know it's been a few years since you posted this but I'm still trying to get my redhat installation completed. I had to install the unixODBC driver to get the installation completed. I don't have root but was able to install the packages into a customer directory. I have the LD_LIBRARY_PATH set for both the path to the unixODBC lib and the Teradata libs. I have ODBCINI set to the ~/teradata/client/ODBC_64/odbc.ini path. I have the TERADSN entries in the odbc.ini file. I have edited the odbcinst.ini file in the same path with the following:
When I run the isql command to connect I"m getting:
[ISQL]ERROR: Could not SQLConnect
I think I'm close but I could be totally wrong.
You wrote : "I had to install the unixODBC driver to get the installation completed."
I do not quite follow this, why you had to install unixODBC ?
I also noticed you updated the odbcinst.ini to add "[TERADSN]", I don't know what it is meant for. You do not have update the odbcinst.ini that comes with Teradata ODBC driver package. Please note, odbc.ini is not the same as odbcinst.ini.
Please follow the instructions in my earlier post in this thread, and let me know if you encounter any error at any of the step. If you have the basic environment ready and connectivity test is successful, then you can work on configuring PERL.
Sorry about the confusion. First I tried to install DBD::ODBC from cpan but it complained that I needed the unixODBC driver, so I installed it. I then installed DBD::ODBC and then I installed the following from teradata. All of the installs were to a custom directory since i don't have root.
I am sorry I confused you with the odbcinst.ini file setup. The instructions that I could find for editing the odbc.ini and the odbcinst.ini files are confusing. If I follow your instructions from above , this is what I have in my odbc.ini file.
The cat file is ~/teradata/client/14.10/odbc_64/msg/tdodbc.cat and I have set the NLSPATH. However I'm not sure what to kickoff from samples/C
Finally some commands show
=> odbcinst -s -q
Please let me know anything you'd like me to post. One thing is I can't seem to get any trace file information from the isql command?
Teradata ODBC driver is supported with DataDirect ODBC driver manager (shipped with Teradata ODBC driver package), not the unixODBC. DBC::ODBC module by default configured to work unixODBC, so you need to re-build DBD::ODBC module to work with DataDirect ODBC driver manager.
Instead of tweaking in what you have installed, I suggest you un-install all you have previously installed and follow instructions in my post on "18 Mar 2011" in this thread to setup Teradata ODBC driver. Verify the connectivity using the tool located in
After verifying the connectivity, you can start configuring and building DBC::ODBC module to work with DataDirect ODBC driver manager, below link describes the steps.
Thanks again for the help. I will uninstall this like you said but I just want to verify this before starting. I downloaded the odbc linux driver, version 14.10.00.00. The order of installing these should be
The DataDirect ODBC driver manager will be included here? I just found out that the teradata odbc will be the only connection I will need to setup, so do I then still need to install DBD::ODBC or will the teradata installation be all that I need?
Is there any documentation on the tdxodbc tool?
No, if you do not need to use PERL you do not need to re-configure DBD::ODBC module.
The installation order is correct, tdicu, teragss, tdodbc in order. Yes, tdodbc package will also install DataDirect ODBC Driver Manager too. No specific action is needed.
tdxodbc is a simple connectivity, SQL query execution test tool. When invoked it prompts from ODBC DSN name, databaser user-name and password. Once connected, it prompts from SQL request to execute or type 'quit' to close.
tdxodbc -h option can show help about command-line arguments.
I have 1 more question if you don't mind. After I install the teradata packages, how do I know which is the correct path for the odbc.ini file? These were all installed the first time.
Both are correct, but please use the above ones. These are links to the ones with version(14.10) number. If you use these paths(without version), you would not need to update your odbc.ini when you upgrade to later version in future.