Livecode and AWS Sql

Fri Apr 10 21:17:09 EDT 2020

Okay, went back to the PC side and was able to successfully connect to a
local SQL server.  When I put in the address and db info for the AWS web
server, I am getting this when connecting:
"Invalid String or Buffer Length.

I will deal with the Mac side later... just need to get the PC side up and
running for now.  Any suggestions on this error message?

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

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