PMTo: perl-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 =
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
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
it in a while loop and performed thousa
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ted Yu
Sent: Tuesday, June 14, 2005 2:43
AM
To:
perl-win32-users@listserv.ActiveState.com
Subject: Use DBI; vs. use
Win32::ODBC;
I recently wanted to use the following code for a select statement:
use DBI;
my
- 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 i
I recently wanted to use the following code for a select statement:
use DBI;my $dbh = DBI->connect( "dbi:ODBC:{database}","{username}", "{password}") or &error('CONNECT_SQL');
my $results = $dbh->selectall_arrayref('select count(*) from tblTicketFileProcessLog');
print $results;use DBI;my $dbh
