Could you, please, post here more details? I have a similar issue (with unixODBC 2.2.11).
Nope, does not work even when using UnixODBC 2.3.0
Please someone post some solutions.
Using unixODBC 2.3.1 and tdodbc 13.00.00.08, I am able to connect to Teradata using the 'isql' command included with unixODBC.
My Teradata driver entry in odbcinst.ini:
The DSN entry in odbc.ini:
Description=MY TERADATA SERVER
Some other configuration comments:
In addition to the above, I am also using Perl's DBI and DBD::ODBC packages to access Teradata. When accessing Teradata from Perl, SQL executes correctly but if I encounter a database error, I get the text:
[unixODBC][Driver Manager]Driver returned SQL_ERROR or SQL_SUCCESS_WITH_INFO but no error reporting API found (SQL-HY000)
Without error messages being returned I don't feel comfortable using unixODBC and Teradata, but I'm very close I think.
So if I am on a corporate system with unixODBC 2.2.1 I am SOL unless I go the route of building my own version based on 2.3.0 or 2.3.1?
Also, since I cannot modify /etc/odbcinst.ini, what do I need to do to my odbc.ini to (try) to make it work?
I am facing similar issues with Teradata connectivity. Using unixODBC ( which is the only option if you need to connect to multiple database servers in one application ), there is no error reporting.
This is a serious flaw in the driver stack on Linux.
Is there an official stance on this ( other than the 'unixODBC is not supported' line )?
I need to setup some perl scripts to access a teradata db. I'm on Red Hat 5.7 and I don't have root so I have done the following:
1) Installed unixODBC-2.3.2 into a custom directory
2) I used CPAN to install DBD::ODBC into a custom directory
I see that I'm supposed to now get the teradata ODBC drivers, however the download site only allows an RPM install, and I can't do that on my server. Right now both my 'odbc.ini' and 'odbcinst.ini' are empty.
Can the teradata install be done as non-root?
I'm hoping someone can help me get this to work. I'll be glad to post anything you need to help debug this. So far this is what I've done being a non-root user into custom directories. We're running RedHat 5.7.
1) installed unixODBC-2.3.2
2) installed DBD::ODBC via cpan
3) installed these Teradata odbc drivers
4) updated both the odbc.ini and the odbcinst.ini located in the path for the unixODBC manager. Does the unixODBC manager odbcinst.ini contain info for the teradata?
8) This is in my perl script for the connection string
my $dbh = DBI->connect('dbi:ODBC:tera_dsn',$username,$password);
9) and this is the error that I'm getting when running the script
DESTROY for DBI::db=HASH(0xb70c4d0) ignored - handle not initialised