Derrick wrote:
> Cannot get a connect to Mysql using DBI
> [snip]
> The code I'm using to connect is.
>
> $dbhandle = DBI->connect("dbi:mysql:products", "",
> "") || &error("\nCouldn't
> co
> nect to DB.\n\n ".$?);
>
> I've modified it Like this
>
> $dbhandle =
> DBI->connect("dbi:mysql:products\@localhost:3306",
> "thrawn",
> "rootroot") || &error("\nCouldn't co
> nect to DB.\n\n ".$?);
> $dbhandle =
>
DBI->connect("dbi:mysql:products\@192.168.1.170:3306",
> "thrawn",
> "rootroot") || &error("\nCouldn't co
> nect to DB.\n\n ".$?);
> [snip]
I'm not a DBI expert, but whenever I connect to mysql,
the first argument generally goes:
DBI:mysql:DATABASE_NAME
Is "products\@192.168.1.170:3306" really the name of
your database? Looks like you should change it back
to simply read "products," but keep your username and
password as is (thrawn, rootroot).
Give it a try (if you haven't already), I'm not sure
if this will make a difference, but hopefully it will!
=====
Dave Hoover
"Twice blessed is help unlooked for." --Tolkien
http://www.redsquirreldesign.com/dave
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
