Livecode and AWS Sql

Skip Kimpel skiplondon at gmail.com
Sat Apr 11 18:46:02 EDT 2020


Thank you Matthias,

So how would you connect to a remote SQL database on a Mac?

SKIP

On Sat, Apr 11, 2020 at 6:17 PM matthias rebbe via use-livecode <
use-livecode at lists.runrev.com> wrote:

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



More information about the use-livecode mailing list