« previous next »
Pages: [1]   Go Down

Author Topic: MariaDB connection  (Read 4992 times)

0 Members and 1 Guest are viewing this topic.

ducky124

  • Member
  • **
  • Posts: 8
    • View Profile
MariaDB connection
« 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.
Logged

IlseKasten

  • Full Member
  • ***
  • Posts: 50
    • View Profile
MariaDB connection
« Reply #1 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.
Logged

ducky124

  • Member
  • **
  • Posts: 8
    • View Profile
MariaDB connection
« Reply #2 on: 2014-05-15 09:19:43 »
Do you know the file name I'm looking for. Or the extension
Logged

IlseKasten

  • Full Member
  • ***
  • Posts: 50
    • View Profile
MariaDB connection
« Reply #3 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.
Logged

ducky124

  • Member
  • **
  • Posts: 8
    • View Profile
MariaDB connection
« Reply #4 on: 2014-05-15 10:19:47 »
MariaDb is the same as MySQL
Logged

Daan van Rooijen

  • Administrator
  • Sr. Member
  • *****
  • Posts: 938
    • View Profile
MariaDB connection
« Reply #5 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.
Logged
I'm volunteering as a moderator - I do not work for Cerious Software, Inc.

ducky124

  • Member
  • **
  • Posts: 8
    • View Profile
MariaDB connection
« Reply #6 on: 2014-05-15 17:30:50 »
my problem is the database isn't listed
Logged

ducky124

  • Member
  • **
  • Posts: 8
    • View Profile
MariaDB connection
« Reply #7 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






Logged

Daan van Rooijen

  • Administrator
  • Sr. Member
  • *****
  • Posts: 938
    • View Profile
MariaDB connection
« Reply #8 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].
Logged
I'm volunteering as a moderator - I do not work for Cerious Software, Inc.

ducky124

  • Member
  • **
  • Posts: 8
    • View Profile
MariaDB connection
« Reply #9 on: 2014-05-15 21:12:18 »
nope...I've already done that..tried a user and a system DSN
Logged

Daan van Rooijen

  • Administrator
  • Sr. Member
  • *****
  • Posts: 938
    • View Profile
MariaDB connection
« Reply #10 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).
Logged
I'm volunteering as a moderator - I do not work for Cerious Software, Inc.

ducky124

  • Member
  • **
  • Posts: 8
    • View Profile
MariaDB connection
« Reply #11 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
Logged
Pages: [1]   Go Up
« previous next »