http://qs321.pair.com?node_id=11126240


in reply to Re: DBI::db error I am confused!
in thread DBI::db error I am confused!

Thank you... That is very helpful about the wrong db driver. The on-line running script is using mysql mariadb. I am using mysql workbench on the localhost. I doubt very much that it has anything to do with script or the data. Can anyone give me a hint how to change the driver? I have no idea. Thanks again!

Replies are listed 'Best First'.
Re^3: DBI::db error I am confused!
by stevieb (Canon) on Jan 03, 2021 at 21:49 UTC

    You're just guessing. Show us the code as 1nickt suggested.

[reply]
Re^3: DBI::db error I am confused!
by Bod (Parson) on Jan 03, 2021 at 21:50 UTC
    Can anyone give me a hint how to change the driver?

    The driver is passed to DBI as the first part of the first parameter of the connect method: 

    use DBI;
use DBD::mysql;
my $dbh=DBI->connect("dbi:mysql:$database_schema:localhost:3306",$user
+,$pass);

    [download]
    This is connecting to MySQL which also works for MariaDB. Although there is a DBD::MariaDB but I haven't switched to using it yet.

[reply]
[d/l]
[select]
Re^3: DBI::db error I am confused!
by Bod (Parson) on Jan 03, 2021 at 21:53 UTC
    I am using mysql workbench on the localhost

    erm...you do know that MySQL Workbench isn't a database don't you???

[reply]

In Section Seekers of Perl Wisdom