problem installing DBD::mysql 2.9004

National Stistics Office - Region XI <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
its been quite a while i am trying to test and install DBD::mysql 2.9004 on 
my system under windows 2000.
here's some test id made.

to jan eden would you pls help how to make some script same as you are 
doing with your project queried via perl script to generate my website.
because i am trying make some query tools like you did.
any reply would be appreciated
[email protected]

installation and test of DBI 1.45 ------- ok success
installation and test of dbd::mysql 2.9004 ------- failed.

C:\dbdmy2.9004>perl makefile.pl --cflags="-IC:\tmp\mysql-static\Imysql.h" 
--libs
="-LC:\tmp\mysql-static\Lmysqlclient.lib"
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
I will use the following settings for compiling and testing:
cflags (Users choice) = -IC:\tmp\mysql-static\Imysql.h
libs (Users choice) = -LC:\tmp\mysql-static\Lmysqlclient.lib
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Using DBI 1.45 (for perl 5.008004 on MSWin32-x86-multi-thread) installed in 
c:/P
erl/site/lib/auto/DBI/
Writing Makefile for DBD::mysql
in dos shell while trying to test and install dbd::mysql
i dont know if it is same error when u combine 32 and 64 bit libraries?
it is probably related to the usage of my shared libraries like:
mysqlclient.lib and mysql.h
-------------------------------------------------------------------------------------- 

-------------------------------------------------------------------------------------- 

----------------oooooooooooooo--------------------------------------
sample script to test the connection of dbd::mysql

#!/usr/bin/perl-w
use DBI;
use strict;
my($dsn)= "DBI:mysql:mysql:user:localhost";
my($user_name)="test";
my($password)="test";
my($dbh);
$dbh=DBI->connect($dsn,$user_name,$password)
or die"Could not connect";
if($dbh)
{
print"connected na po sa mysql\n";
}
exit(0);


------------------------------------------------------------------------------------- 

------------------------------------------------------------------------------------- 

output: failed with dsiplayed available drivers:
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC 
contains: . c:/Perl/lib c:/Perl/site/lib .) at (eval 1) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
at C:\Perl\SAMPLE\connect.pl line 11

thanks very much
any reply would be greatly appreciated
naz,


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.