Exporting to a mysql database.
Exporting to a mysql database.
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.
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.
Re: Exporting to a mysql database.
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!
But as nothing was changed in the last releases in that respect. All should work as before!
Bernd - radio42
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
Re: Exporting to a mysql database.
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.