Livecode and AWS Sql

[Bob Sneidar]

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