I'm afraid that you're not giving us a lot to go on NateTut. Teradata is a database well outside of my experience. What version of Teradata were you using when your Perl code used to work?

Are you sure it's a Perl issue? Could the upgrade have deprecated a bunch of username/passwords including the one(s) that your script is using?

Can you connect to the database using the same username and password that the script is using?

A simple google search for: 

teradata V2R5.1 "deprecated logon"

[download]
has given me the following information.

Teradata Database Utilities - Gateway Control

Release V2R5.1 introduces the Encryption feature.

The following table provides information about the option used to control encrypted logons in the Gateway Control utility

Option:

bAllowDeprecatedLogons

[download]
Note: Deprecated logon is a clear text.

Description:
Enables deprecated logons.

To enable deprecated logons, use the -b option as follows: 

 
       gtwcontrol -b yes

[download]
allows the gateway to accept deprecated and encrypted logons. 
       gtwcontrol -b no

[download]
ensures that the gateway accepts only encrypted logons.

The default is NO.

Comments:
In Release V2R5.1, the Teradata Gateway always supports encrypted logons. However, if you have not upgraded to Teradata Tools and Utilities 7.1, you can enable the gateway to accept both encrypted and unencrypted, also referred to as deprecated logons.

You can read more about all of this kind of thing at http://www.teradataforum.com/teradata_pdf/b035-1098-083a.pdf

It doesn't look like a Perl issue at all. Perhaps it's advice to Upgrade client software to latest version is the way to go... Of course, for some bizarre reason the writer of DBD::Teradata has chosen only to sell the later versions and you may not be able to afford the US$2695.00 ... but I can't help you with that. Check that the newest version of DBD::Teradata handles encryption before you spend your money on it though.

Hope this helps.

jarich

In reply to Re: DBD::Teradata and Teradata V2R5.1 by jarich
in thread DBD::Teradata and Teradata V2R5.1 by NateTut

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.