Thank you everybody! You have been a great help. SKIP
On Sun, Apr 12, 2020 at 10:25 AM Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > This next week I will probably get my client-server thingummy going to > where you can securely pass queries and return data, but I only use sqlYoga > when I can help it, so you might have to modify it for your own purposes. > > Bob S > > > > On Apr 12, 2020, at 2:09 AM, matthias rebbe via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > >> Am 12.04.2020 um 01:11 schrieb Bob Sneidar via use-livecode < > use-livecode@lists.runrev.com>: > >> > >> Same as on Windows, but the difference is that Microsoft has built in > drivers for SQL Server, mySQL and some other things. > > Yes, MS Windows has included a SQL Server ODBC driver. But, if i > remember correct, then you need more current ones if you want to use > special features of the news SQL Server versions. > > We are still using the builtin ones, as our SQL Servers still are run in > 2005 compatibility mode. I am not sure this is the correct expression, but > i am sure you know what i mean. > > > > > > It´s a pity that LC does not have built-in MSSQL drivers which allow to > directly communicate with the MSSQL Server without the need of ODBC. It > would make so much things easier. > > > > > > > >> 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 > > > > > > > > - > > Matthias Rebbe > > Life Is Too Short For Boring Code > > > > > > _______________________________________________ > > 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