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