Re: Livecode and AWS Sql
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 revOpenDatabase("ODBC","DRIVER={Actual Open Source Databases};Type=SQLite;DBQ=;”,,,) //PostgreSQL get revOpenDatabase("ODBC","DRIVER={Actual Open Source Databases};Type=PostgreSQL;SERVER=;DATABASE=;UID=;PWD=;”,,,) //MySQL get revOpenDatabase("ODBC","DRIVER={Actual Open Source Databases};SERVER=;DATABASE=;UID=;PWD=;”,,,) //MySQL is default, so there is no need to specify the Type //or get revOpenDatabase("ODBC","DRIVER={Actual Open Source Databases};Type=MySQL;SERVER=;DATABASE=;UID=;PWD=;”,,,) //Access get revOpenDatabase("ODBC","DRIVER={Actual Access};DBQ=;”,,,) Some general info about the Access driver: When the Actual Access driver connects to a .CSV (or .TXT) file, the table is always named “table1”. If the “Top row contains column names” checkbox for the DSN is selected, then the columns will be named according to the values in the first row of the CSV file. If it is not selected, then the column names will be “col1”, “col2”, “col3”, etc. Regards, - Matthias Rebbe Life Is Too Short For Boring Code > Am 12.04.2020 um 20:22 schrieb 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 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 Microsoft, but i >> never were able to use them with ODBC Manager. >> In the middle of the page at >> >> https://docs.microsoft.com/de-de/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15 >> you´ll find more information about it >> >> >> Matthias >> >> >> >> >>> Am 12.04.2020 um 01:15 schrieb Skip Kimpel via use-livecode < >> use-livecode@lists.runrev.com>: >>> >>> 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, Apr 11, 2020 at 7:12 PM Bob Sneidar via use-livecode < >>> use-livecode@lists.runrev.com> wrote: >>> 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 apps. I will have >> the server reside on a Windows computer where ODBC connections are easy and built in. Then I will have my Mac or Windows LC apps send queries via >> the socket apps. Since they encrypt both ways, it’s secure as well, and I do not have to enable SSL on my mySQL server and futz with SSL certs. Bob S > On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode < use-livecode@lists.runrev.com> wrote: > > Thank you Matthias, > > So how would you connect to a remote SQL database on a Mac? > > 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 >> > ___ > 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,
Re: Livecode and AWS Sql
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 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 Microsoft, but i > never were able to use them with ODBC Manager. > In the middle of the page at > > https://docs.microsoft.com/de-de/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15 > you´ll find more information about it > > > Matthias > > > > > > Am 12.04.2020 um 01:15 schrieb Skip Kimpel via use-livecode < > use-livecode@lists.runrev.com>: > > > > 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, Apr 11, 2020 at 7:12 PM Bob Sneidar via use-livecode < > > use-livecode@lists.runrev.com> wrote: > > > >> 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 apps. I will have > the > >> server reside on a Windows computer where ODBC connections are easy and > >> built in. Then I will have my Mac or Windows LC apps send queries via > the > >> socket apps. > >> > >> Since they encrypt both ways, it’s secure as well, and I do not have to > >> enable SSL on my mySQL server and futz with SSL certs. > >> > >> Bob S > >> > >> > >>> On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode < > >> use-livecode@lists.runrev.com> wrote: > >>> > >>> Thank you Matthias, > >>> > >>> So how would you connect to a remote SQL database on a Mac? > >>> > >>> 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 > ___ 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
Re: Livecode and AWS Sql
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 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 Microsoft, but i > never were able to use them with ODBC Manager. > In the middle of the page at > > https://docs.microsoft.com/de-de/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15 > you´ll find more information about it > > > Matthias > > > > > > Am 12.04.2020 um 01:15 schrieb Skip Kimpel via use-livecode < > use-livecode@lists.runrev.com>: > > > > 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, Apr 11, 2020 at 7:12 PM Bob Sneidar via use-livecode < > > use-livecode@lists.runrev.com> wrote: > > > >> 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 apps. I will have > the > >> server reside on a Windows computer where ODBC connections are easy and > >> built in. Then I will have my Mac or Windows LC apps send queries via > the > >> socket apps. > >> > >> Since they encrypt both ways, it’s secure as well, and I do not have to > >> enable SSL on my mySQL server and futz with SSL certs. > >> > >> Bob S > >> > >> > >>> On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode < > >> use-livecode@lists.runrev.com> wrote: > >>> > >>> Thank you Matthias, > >>> > >>> So how would you connect to a remote SQL database on a Mac? > >>> > >>> 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 > ___ 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
Re: Livecode and AWS Sql
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 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 < > use-livecode@lists.runrev.com> wrote: > > > >> Am 12.04.2020 um 01:11 schrieb Bob Sneidar via use-livecode < > use-livecode@lists.runrev.com>: > >> > >> 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 more current ones if you want to use > special features of the news SQL Server versions. > > We are still using the builtin ones, as our SQL Servers still are run in > 2005 compatibility mode. I am not sure this is the correct expression, but > i am sure you know what i mean. > > > > > > It´s a pity that LC does not have built-in MSSQL drivers which allow to > directly communicate with the MSSQL Server without the need of ODBC. It > would make so much things easier. > > > > > > > >> 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 apps. I will have > the server reside on a Windows computer where ODBC connections are easy and > built in. Then I will have my Mac or Windows LC apps send queries via the > socket apps. > >> > >> Since they encrypt both ways, it’s secure as well, and I do not have to > enable SSL on my mySQL server and futz with SSL certs. > >> > >> Bob S > >> > >> > >>> On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode < > use-livecode@lists.runrev.com> wrote: > >>> > >>> Thank you Matthias, > >>> > >>> So how would you connect to a remote SQL database on a Mac? > >>> > >>> 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 > > > > > > > > - > > Matthias Rebbe > > Life Is Too Short For Boring Code > > > > > > ___ > > 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
Re: Livecode and AWS Sql
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 > wrote: > >> 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 more current ones if you want to use special features > of the news SQL Server versions. > We are still using the builtin ones, as our SQL Servers still are run in 2005 > compatibility mode. I am not sure this is the correct expression, but i am > sure you know what i mean. > > > It´s a pity that LC does not have built-in MSSQL drivers which allow to > directly communicate with the MSSQL Server without the need of ODBC. It would > make so much things easier. > > > >> 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 apps. I will have the >> server reside on a Windows computer where ODBC connections are easy and >> built in. Then I will have my Mac or Windows LC apps send queries via the >> socket apps. >> >> Since they encrypt both ways, it’s secure as well, and I do not have to >> enable SSL on my mySQL server and futz with SSL certs. >> >> Bob S >> >> >>> On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode >>> wrote: >>> >>> Thank you Matthias, >>> >>> So how would you connect to a remote SQL database on a Mac? >>> >>> 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 > > > > - > Matthias Rebbe > Life Is Too Short For Boring Code > > > ___ > 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
Re: Livecode and AWS Sql
> 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 more current ones if you want to use special features of the news SQL Server versions. We are still using the builtin ones, as our SQL Servers still are run in 2005 compatibility mode. I am not sure this is the correct expression, but i am sure you know what i mean. It´s a pity that LC does not have built-in MSSQL drivers which allow to directly communicate with the MSSQL Server without the need of ODBC. It would make so much things easier. > 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 apps. I will have the > server reside on a Windows computer where ODBC connections are easy and built > in. Then I will have my Mac or Windows LC apps send queries via the socket > apps. > > Since they encrypt both ways, it’s secure as well, and I do not have to > enable SSL on my mySQL server and futz with SSL certs. > > Bob S > > >> On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode >> wrote: >> >> Thank you Matthias, >> >> So how would you connect to a remote SQL database on a Mac? >> >> 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 - Matthias Rebbe Life Is Too Short For Boring Code ___ 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
Re: Livecode and AWS Sql
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 Microsoft, but i never were able to use them with ODBC Manager. In the middle of the page at https://docs.microsoft.com/de-de/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15 you´ll find more information about it Matthias > Am 12.04.2020 um 01:15 schrieb 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, Apr 11, 2020 at 7:12 PM Bob Sneidar via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> 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 apps. I will have the >> server reside on a Windows computer where ODBC connections are easy and >> built in. Then I will have my Mac or Windows LC apps send queries via the >> socket apps. >> >> Since they encrypt both ways, it’s secure as well, and I do not have to >> enable SSL on my mySQL server and futz with SSL certs. >> >> Bob S >> >> >>> On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode < >> use-livecode@lists.runrev.com> wrote: >>> >>> Thank you Matthias, >>> >>> So how would you connect to a remote SQL database on a Mac? >>> >>> 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
Re: Livecode and AWS Sql
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, Apr 11, 2020 at 7:12 PM Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > 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 apps. I will have the > server reside on a Windows computer where ODBC connections are easy and > built in. Then I will have my Mac or Windows LC apps send queries via the > socket apps. > > Since they encrypt both ways, it’s secure as well, and I do not have to > enable SSL on my mySQL server and futz with SSL certs. > > Bob S > > > > On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > > Thank you Matthias, > > > > So how would you connect to a remote SQL database on a Mac? > > > > 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
Re: Livecode and AWS Sql
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 apps. I will have the server reside on a Windows computer where ODBC connections are easy and built in. Then I will have my Mac or Windows LC apps send queries via the socket apps. Since they encrypt both ways, it’s secure as well, and I do not have to enable SSL on my mySQL server and futz with SSL certs. Bob S > On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode > wrote: > > Thank you Matthias, > > So how would you connect to a remote SQL database on a Mac? > > 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
Re: Livecode and AWS Sql
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 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 > 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="&";DATABASE="&";UID="&";PWD="&"") > >>> 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 > ___ 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
Re: Livecode and AWS Sql
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 > : > > 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 >> 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 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="&";DATABASE="&";UID="&";PWD="&"") >>> 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
Re: Livecode and AWS Sql
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 > 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 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="&";DATABASE="&";UID="&";PWD="&"") >> 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
Re: Livecode and AWS Sql
So I was able to solve this, kind of. Here is was I did to be able to get it to work on Windows LC environment: *put* revOpenDatabase("ODBC",tDatabaseDSN, tDatabaseName, tDatabaseUser,tDatabasePassword) into gConnID I was using this connection string but getting the "Invalid String or Buffer Length." As I was researching this online I saw a couple of different options, including updating drivers, but the main cause seemed to be due to trying to talk to a 64 bit version of SQL server. I created a direct connection using the ODBC Data Source Administrator and then referencing the DSN name in my LC connection script. Once I did that and BAM! I was able to start accessing my AWS SQL database. At least I can continue programming for now. Eventually I need to find a better solution for the DB connection. Luckily this project is for internal purposes only so I can live with the extra steps I need to take to make it work. I also need to figure out a solution for the Mac side. Is there such a thing on a Mac like the Microsoft ODBC Data Source Administrator? Thought I would share this in case anybody else is struggling with this. Also, I am hoping somebody will read this someday and find the answers to the other two issues I just listed. Hope this helps somebody out there. SKIP KIMPEL On Fri, Apr 10, 2020 at 9:17 PM Skip Kimpel wrote: > 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@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 >> >> 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 >> 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 wrote: >> >> Good to know. >> >> >> >> >> >> SKIP >> >> >> >> On Fri, Apr 10, 2020 at 1:30 PM Ralph DiMola via use-livecode < >> use-livecode@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 Xcode.app >> >> >> >> Ralph DiMola >> >> 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 >> >> >> >> 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 >> 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. &
Re: Livecode and AWS Sql
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@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 > > 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 > 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 wrote: > > Good to know. > > > > > > SKIP > > > > On Fri, Apr 10, 2020 at 1:30 PM Ralph DiMola via use-livecode < > use-livecode@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 Xcode.app > > > > Ralph DiMola > > 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 > > > > 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 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@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 > > 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 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-livecod
RE: Livecode and AWS Sql
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 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 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 wrote: Good to know. SKIP On Fri, Apr 10, 2020 at 1:30 PM Ralph DiMola via use-livecode 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 Xcode.app Ralph DiMola 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 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 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 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 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 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 wrote: https://www.microsoft.com/en-us/download/details.aspx?id=56567 Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net Phone: 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 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 via other programs. SKIP On Fri, Apr 10, 2020 at 8:44 AM Ralph DiMola via use-livecode wrote: 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: 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 mi
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 wrote: > Good to know. > > > SKIP > > On Fri, Apr 10, 2020 at 1:30 PM Ralph DiMola via use-livecode < > use-livecode@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 Xcode.app >> >> >> >> Ralph DiMola >> >> 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 >> >> >> >> 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 >> 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@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 >> >> 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 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@lists.runrev.com> wrote: >> >> https://www.microsoft.com/en-us/download/details.aspx?id=56567 >> >> >> >> Ralph DiMola >> >> IT Director >> >> Evergreen Information Services >> >> rdim...@evergreeninfo.net >> >> Phone: 518-636-3998 Ex:11 >> >> Cell: 518-796-9332 >> >> >> >> From: Skip Kimpel [mailto:skiplon...@gmail.com] >> Sent: Friday, April 10, 2020
Re: Livecode and AWS Sql
Good to know. SKIP On Fri, Apr 10, 2020 at 1:30 PM Ralph DiMola via use-livecode < use-livecode@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 Xcode.app > > > > Ralph DiMola > > 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 > > > > 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 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@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 > > 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 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@lists.runrev.com> wrote: > > https://www.microsoft.com/en-us/download/details.aspx?id=56567 > > > > Ralph DiMola > > IT Director > > Evergreen Information Services > > rdim...@evergreeninfo.net > > Phone: 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 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 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 [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: Livecode and AWS Sql > > Any trick to connecting
RE: Livecode and AWS Sql
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 Xcode.app Ralph DiMola 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 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 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 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 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 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 wrote: https://www.microsoft.com/en-us/download/details.aspx?id=56567 Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net Phone: 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 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 via other programs. SKIP On Fri, Apr 10, 2020 at 8:44 AM Ralph DiMola via use-livecode wrote: 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: 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="&";DATABASE="&";UID="&";PW D="&"") 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/listi
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 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@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 >> >> 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 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@lists.runrev.com> wrote: >> >> https://www.microsoft.com/en-us/download/details.aspx?id=56567 >> >> >> >> Ralph DiMola >> >> IT Director >> >> Evergreen Information Services >> >> rdim...@evergreeninfo.net >> >> Phone: 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 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 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 [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: 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="&";DATABASE="&";UID="&";PW >> D="&"") >> into gConnID* >> >> >> SKIP >> __
Re: Livecode and AWS Sql
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@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 > > 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 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@lists.runrev.com> wrote: > > https://www.microsoft.com/en-us/download/details.aspx?id=56567 > > > > Ralph DiMola > > IT Director > > Evergreen Information Services > > rdim...@evergreeninfo.net > > Phone: 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 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 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 [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: 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="&";DATABASE="&";UID="&";PW > D="&"") > 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 > > ___ > 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
RE: Livecode and AWS Sql
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 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 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 wrote: https://www.microsoft.com/en-us/download/details.aspx?id=56567 Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net Phone: 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 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 via other programs. SKIP On Fri, Apr 10, 2020 at 8:44 AM Ralph DiMola via use-livecode wrote: 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: 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="&";DATABASE="&";UID="&";PW D="&"") 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 ___ 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
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@lists.runrev.com> wrote: > https://www.microsoft.com/en-us/download/details.aspx?id=56567 > > > > Ralph DiMola > > IT Director > > Evergreen Information Services > > rdim...@evergreeninfo.net > > Phone: 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 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 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 [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: 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="&";DATABASE="&";UID="&";PW > D="&"") > 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 > ___ 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
RE: Livecode and AWS Sql
https://www.microsoft.com/en-us/download/details.aspx?id=56567 Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net Phone: 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 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 via other programs. SKIP On Fri, Apr 10, 2020 at 8:44 AM Ralph DiMola via use-livecode wrote: 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: 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="&";DATABASE="&";UID="&";PW D="&"") 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
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 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@lists.runrev.com> wrote: > >> 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: 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="&";DATABASE="&";UID="&";PW >> D="&"") >> 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
Re: Livecode and AWS Sql
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 [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: 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="&";DATABASE="&";UID="&";PW > D="&"") > 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
RE: Livecode and AWS Sql
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: 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="&";DATABASE="&";UID="&";PW D="&"") 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
Re: Livecode and AWS Sql
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 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="&";DATABASE="&";UID="&";PWD="&"") > 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