Livecode and AWS Sql

Fri Apr 10 14:15:38 EDT 2020

I have connected to SQLserver and MySQL remote servers. Did you try to use MS Access via the ODBC connector as a test?

Ralph DiMola

IT Director

Evergreen Information Services

rdimola at evergreeninfo.net

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

Interestingly enough, I brought over everything to the Windows side to test there and I STILL cannot connect!  This might go back to an AWS question OR remote SQL question.  Ralph, do you normally connect to SQL via your local machine/local network or do connect to remote SQL servers.  Going back in my internal memory banks, I don't know if I have ever connected to a remote, cloud based SQL server before.

SKIP

On Fri, Apr 10, 2020 at 1:31 PM Skip Kimpel <skiplondon at gmail.com> wrote:

Good to know.

SKIP

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

You can have multiple versions of Xcode installed. For instance you can have 10.1 and 11.4 installed. Point LC to 11.1. I have all of my Xcode versions in a desktop folder and have none in applications. You just have to make sure the proper version is active  for building.

Display current version è xcode-select -print-path

Change version è sudo xcode-select -switch <path/to/>Xcode.app

Ralph DiMola

IT Director

Evergreen Information Services

rdimola at evergreeninfo.net

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

Just a as follow up, I installed that Xcode 11.4, ran the previous script and it looks like it installed properly. HOWEVER, I still cannot connect to my SQL database.  Also, by doing that, my Mac mobile development environment disappeared.  I have since uninstalled 11.4 and went back to 10.1.

Beyond frustrating... I must be getting old ;

SKIP

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

I do appreciate your help, Ralph.  You and I are in the same boat in regards to their comfort level having primarily worked in a Windows environment in the past.

SKIP

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

>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

_______________________________________________
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