Re: Perl Teradata

Geoffrey Rommel <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <CAAcGyGVzwf1+w0YPg+xUNEZDE0QjufjxmhT5V6cxVDnfJtacBw@mail.gmail.com>
As you probably know, DBD::Teradata is not actively supported by the author
and probably hasn't been tested with TTU 15.0. You may wish to try using
Teradata::SQL instead.

When you say "Teradata Client 15.00", are you referring to the client
software (TTU) on your Red Hat machine? What version is the database?

Is the name in /etc/hosts (or DNS) really "myHost"?

Sorry I can't be more helpful. If you want to try Teradata::SQL, you can
write directly to me for support.


On Wed, Feb 4, 2015 at 8:51 AM, Buehre, Joseph R <[email protected]
> wrote:

>  Good Morning,
>
>
>
> I am looking for help to solve my problem with the Perl DBD::Teradata
> install 1.52.  After a successful, error free, build and install  I get the
> follow message when trying to make a connection.  I can guarantee you the
> host is ping-able and exists.  Any help would be greatly appreciated.
>
>
>
> DBD Terdata version 1.52
>
> Teradata Client 15.00
>
> Redhat verion 6.5
>
>
>
> Error:
>
> DBI connect(myHost;database=thedatabase','info',...) failed: Unable to get
> host address. at ./test_teradata.pl line 23.
>
> Can't call method "prepare" on an undefined value at ./test_teradata.pl
> line 26.
>
>
>
> Connect syntax:
>
> my $tdh =
> DBI->connect("dbi:Teradata:$SERVER;database=$DEFAULTDB",$USERNAME,$KEY,
>
>                         {  RaiseError => 0, tdat_mode => 'ANSI' }
>
>                       );
>
>
>
> Environment variables set:
>
> TD_ICU_DATA=/opt/teradata/client/15.00/tdicu/lib64
>
> COPLIB=/opt/teradata/client/15.00/lib64
>
> COPERR=/opt/teradata/client/15.00/lib64
>
>
>
>
>
> Thanks,
> Joseph (Joe) R. Buehre
> Business Hours Phone: 314-791-9725
>
> MOn - Fri 5:30 - 2:00 PM CDT
>
>
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.