Studio 11 MacOS and SQL Server

[Joe Maus]

Hi,

I've used:

https://actualtech.com/products.php

In the past to connect Omnis with SQL Server.  It was easy to install and configure.  The downside is it costs about $40.00/seat.  This may be competitive depending on how long it takes to install Homebrew ODBC solutions.  They say it works on SQL Server 2019 and Sonoma.

Regards,

Joe Maus


> On Jan 16, 2024, at 5:53 AM, IT <it at plastipol.com> wrote:
> 
> Hi,
> 
> I’m running Omnis 10.22 and need to access to SQL Server to read some data sporadically. Now, I’m using JAVA jtds Driver from freetds.org with great success for years.
> The configuration is very easy and installation only needs to drop one file in a place.
> 
> 
> Studio 11 has deprecated JDBCDAM so I can’t convert to Studio 11 straightforward.
> 
> Is there an easy way to connect to SQL Server from macOS and Studio 11? In the past, I used ODBC but I don’t have good memories. Many things to install.  Furthermore, currently, macOS doesn’t built-in any kind of ODBC support like it was in the past.
> 
> Any advice?
> 
> regards
> 
> xavier
> 
> 
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com