Skip,
As i wrote in my previous post i am using Actualtech´s ODBC drivers. They are not free, but what i think they are cheap. They cost 39,- USD. https://www.actualtech.com/product_sqlserver.php There´s also a trial version available. There are also free ODBC drivers for MSSQL for Mac from Microsoft, but i never were able to use them with ODBC Manager. In the middle of the page at https://docs.microsoft.com/de-de/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15 you´ll find more information about it Matthias > Am 12.04.2020 um 01:15 schrieb Skip Kimpel via use-livecode > <use-livecode@lists.runrev.com>: > > I downloaded the ODBC Administrator for Mac but when I click to add a > connection, it has a blank drivers box. Like you said, Bob, you need to > load the SQL drivers. Where can I download these drivers from? I > originally started down this path with not a ton of luck. > > Thank you, > > SKIP > > On Sat, Apr 11, 2020 at 7:12 PM Bob Sneidar via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> Same as on Windows, but the difference is that Microsoft has built in >> drivers for SQL Server, mySQL and some other things. The Mac does not. You >> have to download the ODBC Administrator (need the 64 bit version you know) >> and the drivers. >> >> This is why I created my Socket based Client Server apps. I will have the >> server reside on a Windows computer where ODBC connections are easy and >> built in. Then I will have my Mac or Windows LC apps send queries via the >> socket apps. >> >> Since they encrypt both ways, it’s secure as well, and I do not have to >> enable SSL on my mySQL server and futz with SSL certs. >> >> Bob S >> >> >>> On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode < >> use-livecode@lists.runrev.com> wrote: >>> >>> Thank you Matthias, >>> >>> So how would you connect to a remote SQL database on a Mac? >>> >>> SKIP >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode