Exporting to a mysql database.

You have a question or need an advice about how to do something? Ask it here!
Post Reply
John2103
Posts: 31
Joined: 11 Nov 2019 16:32
Exporting to a mysql database.

Post by John2103 »

I am moving ProppFrexx to a new computer. I have installed the demo version of ProppFrexx and everything works, except exporting the media libraries to a MySQL server. I use this database export for another application. When I make a connection with the database using the following details:

Connect String: DSN=jukebox;UID=testuser;PWD=123;
Table name: music

I get the message: “The ODBC connection is valid – but the TABLE is empty!”

When I click export, I get the message: "The export was successfully finished”, but when I query the table in the database it is still empty.

I can add records to the database with the same user account, so I don't think it is a rights problem.

Could the issue be that the export option doesn’t work in the demo version of ProppFrexx? It works with the same ODBC driver on another computer with a registered ProppFrexx version. I am using version 4.4.4.1.
User avatar
radio42
Site Admin
Posts: 8926
Joined: 05 Apr 2012 16:26
Location: Hamburg, Germany
Contact:
Re: Exporting to a mysql database.

Post by radio42 »

I am currently on holiday, so I can not double check in the source code and I can not recall, that there was a limit in that respect in the demo version. So my answer is unfortunately I don’t know for sure.

But as nothing was changed in the last releases in that respect. All should work as before!
John2103
Posts: 31
Joined: 11 Nov 2019 16:32
Re: Exporting to a mysql database.

Post by John2103 »

Thank you for your quick response. It’s not the demo version. I downgraded to an older version of MySQL, and now it works. Probably a ODBC driver mismatch.

Post Reply