Re: question about DBI

2002-04-13 Thread M.W. Koskamp
- Original Message - From: xyl To: [EMAIL PROTECTED] Sent: Saturday, April 13, 2002 10:32 AM Subject: question about DBI >dear sir, >i wrote a simple db.pl do some jobs with database. it works through "$perl >db.pl". compiling it with perlcc, execute "$./db". the error is: >Undefined s

RE: DBI, DBD::ODBC - password hiding method

2002-04-13 Thread Jeff Urlwin
I believe, but I'm not sure, that if you pass NO parameters to username and password and you are using the integrated NT authentication, you should be able to login. If not, please let me know. Regards, JEff > -Original Message- > From: mrtlc [mailto:[EMAIL PROTECTED]] > Sent: Saturday

Re: DBI, DBD::ODBC - password hiding method

2002-04-13 Thread Terrence Brannon
The two CPAN modules oriented towards password security are: DBIx::Password (by Brian Aker) DBIx::Connect(by me!) Your approach is most similar to DBIx::Password, but the weaknesses of this approach are discussed in the docs of DBIx::Connect Stacy Mader writes: : I put my usernam

Re: DBI, DBD::ODBC - password hiding method

2002-04-13 Thread Stacy Mader
I put my username and password in a file (dbinfo) in a secure location, open it, and pass the variables to my script - dbinfo should not be accessible from the web! For example: use strict; #Open the Oracle database: if (!defined(open(DBINFO, "$base/dbinfo"))) { die "Can't open dbi

question about DBI

2002-04-13 Thread xyl
dear sir,   i wrote a simple db.pl do some jobs with database. it works through "$perl db.pl". compiling it with perlcc, execute "$./db". the error is: Undefined subroutine &DBI::dr::connect called at  /usr/lib/perl5/site_perl/5.6.0/i386-linux/

DBI, DBD::ODBC - password hiding method

2002-04-13 Thread mrtlc
Hello all, Is there any method to hide the password when we code: DBI->connect('dbi:ODBC:DSN', 'user', 'password'); I am using SQLServer2K on Win2K, can we set up a trusted connection without putting a user id and password? Like the way we run osql or dtsrun using the /E option. Thanks in adv

Problem compiling the DBD::mysql module in cygwin environment

2002-04-13 Thread coco
Hello there, I couldn't find the similar answer in mailing lists. I hope someone can have a good solution. I am using cygwin. I have MySQL and DBI(1.21) installed. When I tried to install DBD::mysql (2.1012), I tried both ways. First, perl -MCPAN -e shell. Second, menually compile. I have pro