Re^2: MySQL ODBC under Windows hangs

vek -- thanks for the reply.

Here's a tiny program the shows the problem. This snippet works with SQL Server and Foxpro db's using ODBC.

#! /usr/local/bin/perl -w

use strict;

use CGI qw(:standard escapeHTML);

$::DSN = "MWEBMYSQL";

use DBI;
$::dbh = DBI->connect ("dbi:ODBC:$::DSN", "ODBC") || die ("Cannot conn
+ect to Data Source '$::DSN'");

my ($count) = $::dbh->selectrow_array ("select count(*) from logon");

print header ('text/html', '200 OK');

print "<html><body>Found $count records in LOGON</body></html>";
[download]

When I run this from the command line (instead of as a web app), the correct results are shown, but the cursor stays right after </html> and I never get back to a command prompt.

"marto" suggested (thanks!) that I should use DBD::MySQL. However, the latest on the ActiveState website is version 2.1004, November 16, 2001. Has anyone tried this with MySQL 5.0 yet?

Thanks a million for any ideas!

Stephen

Comment on Re^2: MySQL ODBC under Windows hangs Download Code