Log4OM data connection using ODBC

Regarding connecting to external program's.
Post Reply
dmalcolm
Advanced Class
Posts: 55
Joined: 03 Nov 2015, 13:31

Log4OM data connection using ODBC

Post by dmalcolm » 03 Jan 2017, 01:47

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?
Dan Malcolm
K4SHQ

User avatar
G4POP
Log4OM Alpha Team
Posts: 6561
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Log4OM data connection using ODBC

Post by G4POP » 03 Jan 2017, 07:54

Why do you want to change to MySQL
73 Terry G4POP

dmalcolm
Advanced Class
Posts: 55
Joined: 03 Nov 2015, 13:31

Re: Log4OM data connection using ODBC

Post by dmalcolm » 03 Jan 2017, 12:32

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

User avatar
G4NVB
Log4OM Beta Team
Posts: 85
Joined: 21 Jan 2013, 17:22
Location: Bletchley, Buckinghamshire

Re: Log4OM data connection using ODBC

Post by G4NVB » 04 Jan 2017, 08:31

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.
73 de David G4NVB

dmalcolm
Advanced Class
Posts: 55
Joined: 03 Nov 2015, 13:31

Re: Log4OM data connection using ODBC

Post by dmalcolm » 04 Jan 2017, 13:06

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.
Dan Malcolm
K4SHQ

User avatar
G4NVB
Log4OM Beta Team
Posts: 85
Joined: 21 Jan 2013, 17:22
Location: Bletchley, Buckinghamshire

Re: Log4OM data connection using ODBC

Post by G4NVB » 04 Jan 2017, 15:18

Hello Dan,

I'm pleased to hear you are sorted.
73 de David G4NVB

Post Reply