It is currently Thu Jan 21, 2021 6:08 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: SQL driver for macOS
PostPosted: Mon Nov 09, 2020 6:56 pm 
Offline
Addict
Addict
User avatar

Joined: Tue Apr 29, 2003 9:18 pm
Posts: 1488
Location: North by Northwest
Does anyone know of a SQL driver that works on the latest version of macOS?

Thanks
fsw

_________________

I am to provide the public with beneficial shocks.
Alfred Hitshock


Top
 Profile  
Reply with quote  
 Post subject: Re: SQL driver for macOS
PostPosted: Thu Nov 12, 2020 12:30 am 
Offline
Addict
Addict
User avatar

Joined: Tue Apr 29, 2003 9:18 pm
Posts: 1488
Location: North by Northwest
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.

_________________

I am to provide the public with beneficial shocks.
Alfred Hitshock


Top
 Profile  
Reply with quote  
 Post subject: Re: SQL driver for macOS
PostPosted: Thu Nov 12, 2020 6:43 pm 
Offline
Addict
Addict
User avatar

Joined: Fri May 12, 2006 6:51 pm
Posts: 2816
Location: Germany
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.

_________________
My Projects ThreadToGUI / OOP-BaseClass / OOP-BaseClassDispatch / EventDesigner V3
PB v3.30 / v5.70 - OS Mac Mini OSX 10.xx - VM Window Pro / Linux Ubuntu
Downloads on my Webspace


Top
 Profile  
Reply with quote  
 Post subject: Re: SQL driver for macOS
PostPosted: Fri Nov 13, 2020 8:28 am 
Offline
Addict
Addict
User avatar

Joined: Tue Apr 29, 2003 9:18 pm
Posts: 1488
Location: North by Northwest
mk-soft wrote:

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.

_________________

I am to provide the public with beneficial shocks.
Alfred Hitshock


Top
 Profile  
Reply with quote  
 Post subject: Re: SQL driver for macOS
PostPosted: Fri Nov 13, 2020 5:54 pm 
Offline
Addict
Addict
User avatar

Joined: Fri May 12, 2006 6:51 pm
Posts: 2816
Location: Germany
Do you use a MS SQL database?
If so, how do you get the MS SQL client to run under macOS?

_________________
My Projects ThreadToGUI / OOP-BaseClass / OOP-BaseClassDispatch / EventDesigner V3
PB v3.30 / v5.70 - OS Mac Mini OSX 10.xx - VM Window Pro / Linux Ubuntu
Downloads on my Webspace


Top
 Profile  
Reply with quote  
 Post subject: Re: SQL driver for macOS
PostPosted: Fri Nov 13, 2020 8:58 pm 
Offline
Addict
Addict
User avatar

Joined: Tue Apr 29, 2003 9:18 pm
Posts: 1488
Location: North by Northwest
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...

_________________

I am to provide the public with beneficial shocks.
Alfred Hitshock


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

 


Powered by phpBB © 2008 phpBB Group
subSilver+ theme by Canver Software, sponsor Sanal Modifiye