Livecode and AWS Sql

[matthias_livecode_150811 at m-r-d.de]

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 at 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 at 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 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
>> 
> _______________________________________________
> 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