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
