Livecode and AWS Sql

matthias_livecode_150811 at m-r-d.de matthias_livecode_150811 at m-r-d.de
Sun Apr 12 14:51:18 EDT 2020


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=<my_server>;DATABASE=<my_database>;UID=<my_userID>;PWD=<my_password>;",,,)

//SQLite
get revOpenDatabase("ODBC","DRIVER={Actual Open Source Databases};Type=SQLite;DBQ=<path_to_file>;”,,,)

//PostgreSQL
get revOpenDatabase("ODBC","DRIVER={Actual Open Source Databases};Type=PostgreSQL;SERVER=<my_server>;DATABASE=<my_database>;UID=<my_userID>;PWD=<my_password>;”,,,)

//MySQL
get revOpenDatabase("ODBC","DRIVER={Actual Open Source Databases};SERVER=<my_server>;DATABASE=<my_database>;UID=<my_userID>;PWD=<my_password>;”,,,) 
//MySQL is default, so there is no need to specify the Type
//or
get revOpenDatabase("ODBC","DRIVER={Actual Open Source Databases};Type=MySQL;SERVER=<my_server>;DATABASE=<my_database>;UID=<my_userID>;PWD=<my_password>;”,,,)

//Access
get revOpenDatabase("ODBC","DRIVER={Actual Access};DBQ=<full_path_to_database>;”,,,)

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 <use-livecode at lists.runrev.com>:
> 
> 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 at 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 at 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 at 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 at 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 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





More information about the use-livecode mailing list