error TCP/IP sockets
am 24.09.2003 17:59:14 von markHi,
I know I've already asked this but I'm very stuck. Here is my code:
Operating System: Windows NT
Using Tomcat:
Have DBI and mysql driver installed.
my $database = 'mysql';
my $hostname = "localhost";
my $port = '';
my $user = 'root';
my $password = 'NO';
my $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
my $dbh = DBI->connect($dsn,$user,$password);
getting error in tomcat's log files:
cgi: runCGI (stderr):DBI
connect('database=mysql;host=127.0.0.1;port=','root',...) failed: Can't
create TCP/IP socket (10106) at
C:\jakarta-tomcat-4.1.24\webapps\pds\WEB-INF\cgi\example.pl line 50
have done the following:
(1)granted permissions for root with user password "NO" to database 'mysql'
(2)have this working through perl on command line.
(3)no port suppled, therefore uses default port.
(4)Looked at sockets, localhost defined as 127.0.0.1, pinged this and still
worked.
Any ideas is this an issue with tomcat, window's NT or perl database
connectivity.
************************************************************ **********
This document is strictly confidential and is intended for use by
the addressee unless otherwise indicated.
Allied Irish Banks
************************************************************ **********
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org