Livecode and AWS Sql

[matthias_livecode_150811 at m-r-d.de]

> Am 12.04.2020 um 01:11 schrieb Bob Sneidar via use-livecode <use-livecode at 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 at 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 at 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