Livecode and AWS Sql

[Bob Sneidar]

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 at lists.runrev.com> wrote:
> 
>> 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
> 
> 
> _______________________________________________
> 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