I want to pull some data down from a Teradata database to a Win2k/NT server.
I use DBI or Win32::ODBC, a system DSN (teradata1) is created.
use DBI;
use DBD::ODBC;
my $dbh = DBI->connect("DBI:ODBC:teradata1", "uname", "moo");
...
or
use Win32::ODBC;
$data = new Win32::ODBC("DSN = teradata1; UID=uname; PWD=moo;");
...
My questions are:
(1) How do I create an encrypted file to store "moo", open that file and
pass "moo" to the database?
or
(2) How do I pass an user name and a password to the DSN teradata1 from
an UDL file
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/h
tml/vxtskcreatingconfiguringuniversaldatalinkfiles.asp)
to the above lines?
Thanks in advance,
Stan L
