- Original Message -
From: Ted Yu [EMAIL PROTECTED]
[snip]
I keep getting an error that reads:
Can't locate DBI.pm in @INC...
Can't really help with main part of your request, but I can tell you that
error means that the DBI module is not installed on your machine - or if it
is
Did you install the DBI module?
I have found that if you need to run your
program for an extended period of time and need to reconnect to your DB,
Win32::ODBC has a memory leak that can cause you problems.
Howard A. Bullock
Computer Security
Tyco Electronics
717-810-3584
What would be the code if i used Win32:ODBC? The result of the
select statement is a single value and not an array. Appreciate your
help, as I am new to using remote connections to a SQL database with
Perl.
I have used
itin a while loop and performed thousands of
I tried to print out the output of the select statement. No error, but no printout either. Not sure if there is an error in my code:
use Win32::ODBC;
my $pw = "password1";my $user = "ted";my $dsn = "db1";$db = new Win32::ODBC("DSN=$dsn;UID=$user;PWD=$pw") || die "ERROR: Failed to open database
-win32-users@listserv.ActiveState.comSubject:
RE: Use DBI; vs. use Win32::ODBC;
I tried to print out the output of the select statement. No error,
but no printout either. Not sure if there is an error in my code:
use Win32::ODBC;
my $pw = "password1";my $user = "ted"