Page 1 of 1
SQL driver for macOS
Posted: Mon Nov 09, 2020 6:56 pm
by fsw
Does anyone know of a SQL driver that works on the latest version of macOS?
Thanks
fsw
Re: SQL driver for macOS
Posted: Thu Nov 12, 2020 12:30 am
by fsw
I’ve tried:
iOBDC -> doesn’t work
unixODBC -> doesn’t work
The only one that worked was this one from actual technologies:
https://www.actualtech.com/
The free version lets you only fetch 3 database entries per call, the full version costs $39.95.
IMHO quite a lot for a single ODBC SQL driver, but if this is the only one l might bite the bullet.
In the meantime I’m still looking for a full functioning free or cheaper one...
Hope this info is of help to someone.
Re: SQL driver for macOS
Posted: Thu Nov 12, 2020 6:43 pm
by mk-soft
Unfortunately the iODBC interface of macOS is still not fixed. There is a Unicode problem. Under Linux the iODBC in Unicode is UC16 and under macOS it is UC32
But I reported this long ago.
Here is the bug report:
viewtopic.php?f=24&t=72104
and here is the temporary solution:
https://www.purebasic.fr/german/viewtop ... 73#p350773
P.S.
Even if the solution runs via the ASCII driver, the data exchange to the database is possible via UTF8.
Re: SQL driver for macOS
Posted: Fri Nov 13, 2020 8:28 am
by fsw
Yes, I saw that thank you.
The app needs to work on Windows and macOS... too many CompilerIF's if using a workaround.
Ended up compiling the app with PB_5.45_LTS which works when using the one driver mentioned above.
I just think that $39.95 is too much for one single driver.
Re: SQL driver for macOS
Posted: Fri Nov 13, 2020 5:54 pm
by mk-soft
Do you use a MS SQL database?
If so, how do you get the MS SQL client to run under macOS?
Re: SQL driver for macOS
Posted: Fri Nov 13, 2020 8:58 pm
by fsw
mk-soft wrote:Do you use a MS SQL database?
If so, how do you get the MS SQL client to run under macOS?
Well, 16 years ago I wrote a database viewer (the SQL Client) app in PureBasic to facilitate my tasks at work.
This database is a corporate database and in the past I used a Windows desktop at work to access the database.
Since covid happened I'm working from home (since March) and can only use my corporate laptop which is a MacBook...
(corporate VPN & security...)
Over the years I've updated the app in many ways and a lot of coworkers use it as well but they all have a Windows laptop.
So I need to get it to work on my MacBook as well as I don't have time to write it again in a different programming language.
Compiling it with PB5.45LTS was flawless and works well while using the one driver I mentioned above.
Hope this answers your question...