Not able to connect to Mysql Database using ODBC
- From: Sriman.Narayana@xxxxxxx (Sriman Export License Required - US UTCHQ Narayana)
- Date: Thu, 30 Nov 2006 13:59:05 -0500
Hi,
I am new to perl programming. Installed mysql,perl,mysql odbc drivers
in my machine. Following is my code, its not working. I googled it but
no use :(
use DBI::W32ODBC;
$dbh= DBI->connect("DBI:W32ODBC:TestMyDSN","rootuser","rootuserpwd") ||
die "Got error $DBI::errstr when connecting to $dsn\n";
error msg:
Error connecting to DBI:W32ODBC:TestMyDSN;UID=rootuser;PWD=rootuserpwd:
[911] []
"[Microsoft][ODBC Driver Manager] Data source name not found and no
default dri
ver specified"
Got error when connecting to
is there any thing missing in my machine? Any idea?
Thanks in advance.
Thanks & Regards,
Sri
- Follow-Ups:
- Re: Not able to connect to Mysql Database using ODBC
- From: Martin Evans
- Re: Not able to connect to Mysql Database using ODBC
- Prev by Date: Can't get DBD:Oracle to work
- Next by Date: Re: Not able to connect to Mysql Database using ODBC
- Previous by thread: Can't get DBD:Oracle to work
- Next by thread: Re: Not able to connect to Mysql Database using ODBC
- Index(es):