;
# DBI automatically loads ADO
my $dbh = DBI-connect('dbi:ADO:...',...);
-Original Message-
From: Patrix Diradja
[mailto:[EMAIL PROTECTED]
Sent: Thursday, February 08, 2007 10:54 AM
To: dbi-users@perl.org
Subject: Balasan: RE: Balasan: RE: Balasan: RE:
can't execute use
Dear Garrett it still doesn't work.
Here is the error message:
Can't locate DBI/ADO.pm in @INC (@INC contains: C:\Program Files\ActiveState
Perl Dev Kit 6.0\lib\ C:/Perl/site/lib C:/Perl/lib .) at cldump.pl line 8.
BEGIN failed--compilation aborted at cldump.pl line 8.
Please
, February 08, 2007 10:54 AM
To: dbi-users@perl.org
Subject: Balasan: RE: Balasan: RE: Balasan: RE: can't execute use
$database
Dear Garrett it still doesn't work.
Here is the error message:
Can't locate DBI/ADO.pm in @INC (@INC contains: C:\Program
Files\ActiveState Perl Dev Kit 6.0\lib\ C
Patrix Diradja wrote:
Dear my friends,
I wonder why my perl can not execute query use $database.
Sorry, I don't know for sure, but my guess is that the use database
command is a *client* command, and not valid SQL.
Generally speaking, when you want to connect to a specific database, it
Dear my friend, Charles.
I Use Perl on Windows Vista, MS SQL Server 2005, DBI, ADO.
I create 'myperl' as DSN from ODBC Administration Tools.
Here is my connection string:
my $dbh1 = DBI-connect(dbi:ADO:database=gua;host=127.0.0.1;port=1433,
$uname, $pword)
|| die Could not
Dear my friend, Garret.
I Use Perl on Windows Vista, MS SQL Server 2005, DBI, ADO.
I create 'myperl' as DSN from ODBC Administration Tools.
Here is my connection string:
my $dbh1 = DBI-connect(dbi:ADO:database=gua;host=127.0.0.1;port=1433,
$uname, $pword)
|| die Could not
Patrix Diradja wrote:
Dear my friend, Garret.
I Use Perl on Windows Vista, MS SQL Server 2005, DBI, ADO.
I create 'myperl' as DSN from ODBC Administration Tools.
Here is my connection string:
my $dbh1 =
DBI-connect(dbi:ADO:database=gua;host=127.0.0.1;port=1433,
$uname,
Yeah, that's the problem Garrett.
I usually use that way to connect to ms msql.
But now, I want that my perl code can work with several databases. So I need
somewhat like the Connection String which I can modify (forming string) and
than just does $dbh-connect(still be secret for
Patrix Diradja wrote:
Yeah, that's the problem Garrett.
I usually use that way to connect to ms msql.
But now, I want that my perl code can work with several databases.
So I need somewhat like the Connection String which I can modify
(forming string) and than just does