mrtlc wrote:
>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?
>
Why do you want to use an UDL file? They are not encrypted. You can open
the UDL file like any other text file using Perl and copy the DSN.There is also a DSN syntax for UDL files: "File name=path\\my.udl;" (from memory) > >Thanks in advance, > >Stan L > > > > > >
smime.p7s
Description: S/MIME Cryptographic Signature
