Re: Livecode and AWS Sql

2020-04-12 Thread matthias rebbe via use-livecode
And their support, if ever needed, is excellent. Btw., if you want to use ODBC connection strings with LC <7 and Actualtech´s ODBC drivers, then here is the needed syntax for it //MSSQL get revOpenDatabase("ODBC","Driver={Actual SQL Server};SERVER=;DATABASE=;UID=;PWD=;",,,) //SQLite get

Re: Livecode and AWS Sql

2020-04-12 Thread Skip Kimpel via use-livecode
Matthias, By the way, Actualtech´s ODBC drivers work perfectly. thank you for the recommendation! SKIP On Sun, Apr 12, 2020 at 4:56 AM matthias rebbe via use-livecode < use-livecode@lists.runrev.com> wrote: > > > Skip, > > As i wrote in my previous post > i am using Actualtech´s ODBC

Re: Livecode and AWS Sql

2020-04-12 Thread Skip Kimpel via use-livecode
I first started with the Microsoft driver options but had zero luck... this was a very frustrating part of my learning curve with this project. SKIP On Sun, Apr 12, 2020 at 4:56 AM matthias rebbe via use-livecode < use-livecode@lists.runrev.com> wrote: > > > Skip, > > As i wrote in my previous

Re: Livecode and AWS Sql

2020-04-12 Thread Skip Kimpel via use-livecode
Thank you everybody! You have been a great help. SKIP On Sun, Apr 12, 2020 at 10:25 AM Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > This next week I will probably get my client-server thingummy going to > where you can securely pass queries and return data, but I only

Re: Livecode and AWS Sql

2020-04-12 Thread Bob Sneidar via use-livecode
This next week I will probably get my client-server thingummy going to where you can securely pass queries and return data, but I only use sqlYoga when I can help it, so you might have to modify it for your own purposes. Bob S > On Apr 12, 2020, at 2:09 AM, matthias rebbe via use-livecode >

Re: Livecode and AWS Sql

2020-04-12 Thread matthias rebbe via use-livecode
> Am 12.04.2020 um 01:11 schrieb Bob Sneidar via use-livecode > : > > Same as on Windows, but the difference is that Microsoft has built in drivers > for SQL Server, mySQL and some other things. Yes, MS Windows has included a SQL Server ODBC driver. But, if i remember correct, then you need

Re: Livecode and AWS Sql

2020-04-12 Thread matthias rebbe via use-livecode
Skip, As i wrote in my previous post i am using Actualtech´s ODBC drivers. They are not free, but what i think they are cheap. They cost 39,- USD. https://www.actualtech.com/product_sqlserver.php There´s also a trial version available. There are also free ODBC drivers for MSSQL for Mac from

Re: Livecode and AWS Sql

2020-04-11 Thread Skip Kimpel via use-livecode
I downloaded the ODBC Administrator for Mac but when I click to add a connection, it has a blank drivers box. Like you said, Bob, you need to load the SQL drivers. Where can I download these drivers from? I originally started down this path with not a ton of luck. Thank you, SKIP On Sat,

Re: Livecode and AWS Sql

2020-04-11 Thread Bob Sneidar via use-livecode
Same as on Windows, but the difference is that Microsoft has built in drivers for SQL Server, mySQL and some other things. The Mac does not. You have to download the ODBC Administrator (need the 64 bit version you know) and the drivers. This is why I created my Socket based Client Server

Re: Livecode and AWS Sql

2020-04-11 Thread Skip Kimpel via use-livecode
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

Re: Livecode and AWS Sql

2020-04-11 Thread matthias rebbe via use-livecode
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

Re: Livecode and AWS Sql

2020-04-11 Thread Bob Sneidar via use-livecode
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

Re: Livecode and AWS Sql

2020-04-11 Thread Skip Kimpel via use-livecode
Ralph DiMola >> >> IT Director >> >> Evergreen Information Services >> >> rdim...@evergreeninfo.net >> >> >> >> From: Skip Kimpel [mailto:skiplon...@gmail.com] >> Sent: Friday, April 10, 2020 1:46 PM >> To: How to use LiveCode >>

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
st? > > > > Ralph DiMola > > IT Director > > Evergreen Information Services > > rdim...@evergreeninfo.net > > > > From: Skip Kimpel [mailto:skiplon...@gmail.com] > Sent: Friday, April 10, 2020 1:46 PM > To: How to use LiveCode > Cc: Ralph DiMola

RE: Livecode and AWS Sql

2020-04-10 Thread Ralph DiMola via use-livecode
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

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
gt;> Evergreen Information Services >> >> rdim...@evergreeninfo.net >> >> >> >> From: Skip Kimpel [mailto:skiplon...@gmail.com] >> Sent: Friday, April 10, 2020 1:08 PM >> To: How to use LiveCode >> Cc: Ralph DiMola >> Subject: Re: Liveco

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
t; > IT Director > > Evergreen Information Services > > rdim...@evergreeninfo.net > > > > From: Skip Kimpel [mailto:skiplon...@gmail.com] > Sent: Friday, April 10, 2020 1:08 PM > To: How to use LiveCode > Cc: Ralph DiMola > Subject: Re: Livecode and AWS Sql > &

RE: Livecode and AWS Sql

2020-04-10 Thread Ralph DiMola via use-livecode
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

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
ecode < >> use-livecode@lists.runrev.com> wrote: >> >> https://www.microsoft.com/en-us/download/details.aspx?id=56567 >> >> >> >> Ralph DiMola >> >> IT Director >> >> Evergreen Information Services >> >> rdim...@ev

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
Services > > rdim...@evergreeninfo.net > > > > From: Skip Kimpel [mailto:skiplon...@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

RE: Livecode and AWS Sql

2020-04-10 Thread Ralph DiMola via use-livecode
...@evergreeninfo.net From: Skip Kimpel [mailto:skiplon...@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

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
518-636-3998 Ex:11 > > Cell: 518-796-9332 > > > > From: Skip Kimpel [mailto:skiplon...@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 i

RE: Livecode and AWS Sql

2020-04-10 Thread Ralph DiMola via use-livecode
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

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
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 wrote: > Nope... am able to connect

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
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@lists.runrev.com> wrote: > Firewall port? > > Ralph DiMola > IT Director > Evergreen Information Services > > -Original Message- > From: use-livecode

RE: Livecode and AWS Sql

2020-04-10 Thread Ralph DiMola via use-livecode
Firewall port? Ralph DiMola IT Director Evergreen Information Services -Original Message- From: use-livecode [mailto:use-livecode-boun...@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:

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
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 wrote: > Any trick to connecting to an AWS Sql instance? I am using some of my old > scripts