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?
Log4OM data connection using ODBC
Log4OM data connection using ODBC
Dan Malcolm
K4SHQ
K4SHQ
Re: Log4OM data connection using ODBC
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.
Dan Malcolm
K4SHQ
K4SHQ
Re: Log4OM data connection using ODBC
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.
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.
73 de David G4NVB
Re: Log4OM data connection using ODBC
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.
Thanks to your heads up, MySQL is a least temporarily off the table.
Dan Malcolm
K4SHQ
K4SHQ
Re: Log4OM data connection using ODBC
Hello Dan,
I'm pleased to hear you are sorted.
I'm pleased to hear you are sorted.
73 de David G4NVB