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@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 <skiplon...@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
