Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

Re: Error connecting to Teradata via ODBC

by Generoso (Parson)
on Dec 02, 2010 at 16:35 UTC ( #874939=note: print w/replies, xml ) Need Help??

in reply to Error connecting to Teradata via ODBC

Have you tested your connection for DSN=odbc_entry in Data Sources (ODBC)?

  • Comment on Re: Error connecting to Teradata via ODBC

Replies are listed 'Best First'.
Re^2: Error connecting to Teradata via ODBC
by MoFiddy (Sexton) on Dec 02, 2010 at 18:04 UTC
    Hi Generoso, That is a good question. Our server is Solaris, so I poked around and found /opt/teradata/client/odbc64/samples/C. I ran the adhoc program, but discovered that the file that I am referencing in my code ($ENV{'ODBCINI'} = '/path/to/.odbc.ini';) is NOT the same odbc.ini file that /opt/teradata/client/odbc64/samples/C references. It seems that I need to add my dsn entry to /opt/teradata/client/odbc64/odbc.ini for it to work. Do I also need to add it to odbcinst.ini too? Is that correct? Am I on the right track? Thanks Edit: Added sentence about odbcinst.ini.
      It turns out that the problem was that I was using 64-bit odbc drivers. Our version of Perl only supports 32-bit at this time. I changed the odbc entry to point to the 32-bit drivers and I was able to connect. Thanks for your help! Dennis

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://874939]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (6)
As of 2016-10-24 10:02 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (304 votes). Check out past polls.