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