Re^2: 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!

Comment on Re^2: DBI::db error I am confused!

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]