Re: Need help connecting to Teradata using DBI and DBD::ODBC packages

Jeff,
     The script worked. Thank you so much.

  ($database_connect = DBI->connect('DBI:ODBC:DSNInfo', 'userid',
'password',{PrintError => 0,RaiseError => 1, })) ;

On Thu, Sep 29, 2011 at 11:04 AM, Perl developer
<[email protected]>wrote:

> Jeff,
>
> The following perl script is used to connect to SQL server database using
> DBI and DBD::ODBC modules.
>
> *my *$dbh = DBI->*connect*("DBI:ODBC:Driver={SQL
> Server};Server=$db_instance;Database=$db_name;UID=$db_user;PWD=$db_pass") or
> *die*("\n\nCONNECT ERROR:\n\n$DBI::errstr");
>
>
> I used the same syntax to connect to Teradata but I couldn't connect.
>
> I have Installed the cli, teragss, and tdicu Teradata software packages on
> my local machines on windows.
>
> I edited windows etc/hosts file and added hostname and ip address entries.
>
>
> But I receive the following error. Any ehlp is appreciated.
>
> DBI
> connect('Driver={Teradata};Server=servername;Database=database;UID=userid;PWD=******','',...)
> failed: [Teradata][ODBC Teradata Driver] Not enough information to log on
> (SQL-28000) at Teradata_test.pl line 46
>
>
> Thanks,
>
> Vineel Kota
>
>
>
> On Wed, Sep 28, 2011 at 3:41 PM, Jeff Tate <[email protected]> wrote:
>
>> I am developing an app that pulls data from a Teradata data-server through
>> DBI, DBD::ODBC. It is developed on a Win32 platform, but targeted for an AXI
>> platform.****
>>
>> ** **
>>
>> In debugging a difference between the two platforms (after rigorous code
>> identity policing) I used Data::Dumper to print the in-memory image of the
>> working data after running a stored procedure and then running
>> ’fetchrow_hashref’. I have attached an edited file that shows:****
>>
>> ** **
>>
>> **·         **One tag retrieved only on AIX****
>>
>> **·         **Two tags named differently across the Win and AIX instances
>> ****
>>
>> ** **
>>
>> I have looked at obvious sources and not seen any warnings about this. Can
>> anybody tell me if this is a known issue, and if so whether there is a
>> canonical way of handling it.****
>>
>> ** **
>>
>> Thanx****
>>
>> ** **
>>
>> Jeff Tate****
>>
>> CHAMPS-DW Project Manager****
>>
>> (415) 606 7621 (cell)****
>>
>> (517) 993-0946 (OI office)****
>>
>> (925) 887 6825 (eFax)****
>>
>> [email protected] (scheduling)****
>>
>> ** **
>>
>
>