Log4OM data connection using ODBC

[K4SHQ]

I find I have an ODBC driver for MySQL on my Win10 machine. Does anyone have any experience using ODBC to connect to Log4OM?

I am currently using Log4OM's interface to SQLite. How difficult would it be to convert to MySQL?

[G4POP]

Why do you want to change to MySQL

[K4SHQ]

I have a php script that pulls data from an ODBC connection. I am having little luck getting PHP connected directly from SQLite. My thought was if I can make an ODBC connection with the Log4OM database, there would be a lot less work to do while converting the script from HRD Logbook to Log4OM. That said a working direct connection to SQLite would be fine. PHP does support it but won't open the file. Permissions should be ok as is and the path is verified.

[G4NVB]

Dan,

Have you looked at the Log4om Help File, there is a section describing the set-up of MySQL although having said that you may like to read :-
viewtopic.php?f=7&t=1091&p=6392&hilit=mysql+leak#p6392
I don't know if this issue has been fixed or will be fixed in Log4om Ver 2.

[K4SHQ]

Thanks for the heads up David. In searching for a solution I have found that there are third party ODBC drivers for SQLite. I downloaded one that is free, and found that it will connect to and then provide access to a copy of the Log4OM SQLite file. The catch seems to be that it only does this as long as I'm running my script in a PHP debugger. If try to run outside the debugger I get an error that says the ODBC driver can't open the connection.

Thanks to your heads up, MySQL is a least temporarily off the table.

[G4NVB]

Hello Dan,

I'm pleased to hear you are sorted.