[Chicago-talk] perl DBI error

[Don Drake]

Try using the INFORMATION SCHEMA database:

my $dbh = DBI->connect( "DBI:mysql:information_schema;192.168.0.1", $usrr, $passw, { RaiseError => 3 } );

-Don

--
Don Drake
www.drakeconsulting.com
www.maillaunder.com
312-560-1574
800-733-2143

On Apr 2, 2013, at 12:51 PM, Richard Reina <richard at rushlogistics.com> wrote:

> use DBI;
> my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, { RaiseError => 3 } );
> my $dbs = $dbh->selectcol_arrayref("show databases");
> 
> my $dbs = $dbh->selectcol_arrayref('show databases');
> 
> print "@$dbs\n";
> 
> When I query the server for a list of databases with the code above it returns the name of just two and there are over 10.
> 
> Any ideas?
> 
> Thanks
> -- 
> Richard Reina
> Rush Logistics, Inc.
> Watch our 3 minute movie: 
> http://www.rushlogistics.com/movie
> 
> _______________________________________________
> Chicago-talk mailing list
> Chicago-talk at pm.org
> http://mail.pm.org/mailman/listinfo/chicago-talk

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/chicago-talk/attachments/20130402/c77cfcaf/attachment.html>