Matthias, By the way, Actualtech´s ODBC drivers work perfectly..... thank you for the recommendation!
SKIP On Sun, Apr 12, 2020 at 4:56 AM matthias rebbe via use-livecode < use-livecode@lists.runrev.com> wrote: > > > 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 > _______________________________________________ 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
