in reply to MySQL ODBC under Windows hangs

Hi Stephen Toney,

Should you not provide the username and password when connecting?
Like $dbh = DBI->connect('dbi:ODBC:DSN', 'user', 'password');
If when you examine the SQL log queries are running as you would expect, please post your code so that someone may point out why it is not displaying the results.

Cheers.

Martin

Replies are listed 'Best First'.
Re^2: MySQL ODBC under Windows hangs
by Stephen Toney (Sexton) on Nov 16, 2005 at 15:47 UTC
    Sorry I wasn't clear about that. The "ODBC" user has no password, and I have tried a connection strings like 
    $::dbh = DBI->connect ("dbi:ODBC:$dsn", "ODBC");
$::dbh = DBI->connect ("dbi:ODBC:$dsn", "ODBC", "");
$::dbh = DBI->connect ("dbi:ODBC:$dsn", "ODBC", NULL);

    [download]
    My impression was that if the user "ODBC" is set in the DSN, which it is, then it is not required in the connection string. If it is required, then maybe my problem is that I'm not sure how to enter the password when no password is required. Maybe I should try assigning the ODBC user a password and then I would know the syntax.

    Thanks for replying!

    Stephen
[reply]
[d/l]

In Section Seekers of Perl Wisdom