ThumbsPlus

All forums => ThumbsPlus v7-v9 Questions => Topic started by: ducky124 on 2014-05-15 07:56:03

Title: MariaDB connection
Post by: ducky124 on 2014-05-15 07:56:03

I have MariaDb installed. I ran your script to create the database. I then setup the ODBC drivers for MariaDB. Everything seems good. Now my problem is how to I get ThumbPlus9 to access the database. I have tried everything. I checked your website along with the help files, but I  can find no documentation on how to do this. Could someone please send me some info on how I might do this. I am running the latest beta of ThumbPlus9 on windows 7.

Title: MariaDB connection
Post by: IlseKasten on 2014-05-15 09:04:31

If you ran the script, you have to locate the directory with the databasefile in Explorer. Rightclick on Open with.. ,select TP9.
Maybe this hint helps you.

Title: MariaDB connection
Post by: ducky124 on 2014-05-15 09:19:43

Do you know the file name I'm looking for. Or the extension

Title: MariaDB connection
Post by: IlseKasten on 2014-05-15 10:14:58

As far as I see, the MARIADB script on the Thumbsplus Site is a MySQL script. I think thats wrong. The file should be somewhere in the Userdirectory.

Guess by using the built SQLite db if you don't have to meet any specific conditions, this is definitely worth a try. I'm sorry, again, I can not help you in this case.

Title: MariaDB connection
Post by: ducky124 on 2014-05-15 10:19:47

MariaDb is the same as MySQL

Title: MariaDB connection
Post by: Daan van Rooijen on 2014-05-15 12:07:24

If the Mariadb service is running and you have made the ODBC connection to the database, you should be able to open the database through Database | Connect in ThumbsPlus.

Title: MariaDB connection
Post by: ducky124 on 2014-05-15 17:30:50

my problem is the database isn't listed

Title: MariaDB connection
Post by: ducky124 on 2014-05-15 19:24:03

ok I was finally able to get it to show up in the connect list but now I get this message






(http://images/uploaded/2014051523230953754c5d5e365.jpg)

Title: MariaDB connection
Post by: Daan van Rooijen on 2014-05-15 20:59:34

> ok I was finally able to get it to show up in the connect list but now I get this message

Looks like you haven't made a data source yet. Run Start > Run > odbcad32 to launch the ODBC configuration tool, then make a file DSN or system DSN for your database. See also pages 5+6 of [link]ftp://ftp.cerious.com/pub/cerious/sqlserver.pdf[/link].

Title: MariaDB connection
Post by: ducky124 on 2014-05-15 21:12:18

nope...I've already done that..tried a user and a system DSN

Title: MariaDB connection
Post by: Daan van Rooijen on 2014-05-16 00:39:25

In that case I'd turn on SQL logging in the ODBC administrator, try again to connect to the database and see if the logfile contains any hints as to what is going wrong (and be sure to turn logging off afterwards).

Title: MariaDB connection
Post by: ducky124 on 2014-05-16 17:37:50

OK, so I gave up on MariaDB and switched to MYSQL. everything sets up perfectly. no when I try to connect I get Syntax error messages