PureBasic Forum

Does anyone know of a SQL driver that works on the latest version of macOS?

Thanks
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.

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.

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.

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...