Hi, 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.