Livecode and AWS Sql

Fri Apr 10 10:56:11 EDT 2020

>From what I can see you will either need to install Xcode 11.4 or use a previous version of the ODBC SW. But I’m starting to get out of my comfort zone now. I do some Mac dev but I’m mainly a Windows developer.

Ralph DiMola

IT Director

Evergreen Information Services

rdimola at evergreeninfo.net

From: Skip Kimpel [mailto:skiplondon at gmail.com] 
Sent: Friday, April 10, 2020 10:35 AM
To: How to use LiveCode
Cc: Ralph DiMola
Subject: Re: Livecode and AWS Sql

Unfortunately, I don't think it is that straight forward.  I went down this path already.  The files that you can download are Windows MSI installation files.  You can run it manually by using the following commands:

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release

brew update

HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql17 mssql-tools

However, when I run the last command, I get:

Error: Your Xcode (10.1) is too outdated.

Please update to Xcode 11.4 (or delete it).

Xcode can be updated from the App Store.

Do I really need Xcode in order to install SQL?  I also thought I read that I needed to Xcode 10.1 in order to be compatible with the latest version of LC.  Maybe I am wrong here.

SKIP

On Fri, Apr 10, 2020 at 10:28 AM Ralph DiMola via use-livecode <use-livecode at lists.runrev.com> wrote:

https://www.microsoft.com/en-us/download/details.aspx?id=56567

Ralph DiMola

IT Director

Evergreen Information Services

rdimola at evergreeninfo.net

Phone: 518-636-3998 Ex:11

Cell: 518-796-9332

From: Skip Kimpel [mailto:skiplondon at gmail.com] 
Sent: Friday, April 10, 2020 10:19 AM
To: How to use LiveCode
Cc: Ralph DiMola
Subject: Re: Livecode and AWS Sql

I am so used to running in the Windows world that I don't think I have a SQL ODBC driver installed on my MAC.  I googled it a little bit and did not find too much help.  Anybody have suggestions on this piece?

SKIP

On Fri, Apr 10, 2020 at 9:44 AM Skip Kimpel <skiplondon at gmail.com> wrote:

Nope... am able to connect via other programs.....

SKIP

On Fri, Apr 10, 2020 at 8:44 AM Ralph DiMola via use-livecode <use-livecode at lists.runrev.com> wrote:

Firewall port?

Ralph DiMola
IT Director
Evergreen Information Services

-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
Of Skip Kimpel via use-livecode
Sent: Thursday, April 09, 2020 10:10 PM
To: How to use LiveCode
Cc: Skip Kimpel
Subject: Livecode and AWS Sql

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&";PW
D="&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