Livecode and AWS Sql

[matthias_livecode_150811 at m-r-d.de]

Just an information about using ODBC connection strings in LC on Mac.

Since LC version 7  it is not possible anymore to use odbc connection strings in LC on Mac OS.
On Windows this is not a problem. 

see bug report  https://quality.livecode.com/show_bug.cgi?id=18151 from 2016.


-
Matthias Rebbe
Life Is Too Short For Boring Code

> Am 11.04.2020 um 23:46 schrieb Bob Sneidar via use-livecode <use-livecode at lists.runrev.com>:
> 
> Hi all. I went through something similar of late. One thing to keep in mind, the ODBC driver can connect to a SQL server on another device, but your app that communicates with ODBC must be on the same device as the DSN. 
> 
> May not be your issue. 
> 
> Bob S
> 
> 
>> On Apr 10, 2020, at 4:36 AM, Skip Kimpel via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> I forgot to mention that I am on a Mac... also very new to me.  This might
>> also have something to do with how the SQL connection script is written.
>> 
>> SKIP
>> 
>> On Thu, Apr 9, 2020 at 10:09 PM Skip Kimpel <skiplondon at gmail.com> wrote:
>> 
>>> Any trick to connecting to an AWS Sql instance?  I am using some of my old
>>> scripts that always hooked up properly to a local Sql server.  Wondering if
>>> I might be a trick for AWS or heck, my method might be old and there is a
>>> better way to do it.
>>> 
>>> *put revOpenDatabase("ODBC","DRIVER=SQL
>>> Server;SERVER="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PWD="&tDatabasePassword&"")
>>> into gConnID*
>>> 
>>> 
>>> 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