Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^2: MySQL ODBC under Windows hangs

by Stephen Toney (Sexton)
on Nov 17, 2005 at 16:24 UTC ( [id://509456]=note: print w/replies, xml ) Need Help??


in reply to Re: MySQL ODBC under Windows hangs
in thread 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

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://509456]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others cooling their heels in the Monastery: (4)
As of 2024-04-16 16:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found