Does anyone know of a SQL driver that works on the latest version of macOS?
Thanks
fsw
SQL driver for macOS
SQL driver for macOS
I am to provide the public with beneficial shocks.
Alfred Hitshock
Re: SQL driver for macOS
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.
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.
I am to provide the public with beneficial shocks.
Alfred Hitshock
Re: SQL driver for macOS
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.
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.
My Projects ThreadToGUI / OOP-BaseClass / EventDesigner V3
PB v3.30 / v5.75 - OS Mac Mini OSX 10.xx - VM Window Pro / Linux Ubuntu
Downloads on my Webspace / OneDrive
PB v3.30 / v5.75 - OS Mac Mini OSX 10.xx - VM Window Pro / Linux Ubuntu
Downloads on my Webspace / OneDrive
Re: SQL driver for macOS
Yes, I saw that thank you.mk-soft wrote: and here is the temporary solution:
https://www.purebasic.fr/german/viewtop ... 73#p350773
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.
I am to provide the public with beneficial shocks.
Alfred Hitshock
Re: SQL driver for macOS
Do you use a MS SQL database?
If so, how do you get the MS SQL client to run under macOS?
If so, how do you get the MS SQL client to run under macOS?
My Projects ThreadToGUI / OOP-BaseClass / EventDesigner V3
PB v3.30 / v5.75 - OS Mac Mini OSX 10.xx - VM Window Pro / Linux Ubuntu
Downloads on my Webspace / OneDrive
PB v3.30 / v5.75 - OS Mac Mini OSX 10.xx - VM Window Pro / Linux Ubuntu
Downloads on my Webspace / OneDrive
Re: SQL driver for macOS
Well, 16 years ago I wrote a database viewer (the SQL Client) app in PureBasic to facilitate my tasks at work.mk-soft wrote:Do you use a MS SQL database?
If so, how do you get the MS SQL client to run under macOS?
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...
I am to provide the public with beneficial shocks.
Alfred Hitshock