Page 1 of 1
how to connect to MsSQL server database
Posted: Mon Jun 25, 2018 12:20 pm
by studentmy
Hi all, i know how to connect to MySQL , create table, update data, delete data from the live code lessons, but i have no idea how to connect to Microsoft MsSQL Server with Livecode, using ODBC or web service API?
anyone can help? any example?
thank you
Re: how to connect to MsSQL server database
Posted: Mon Jun 25, 2018 1:04 pm
by bogs
Max's Wiki has some excellent information about the subject, about halfway down the page under "Databases" (use the links under it, some of them don't link from the categories page).
- Databases
- Selection_003.png (10.59 KiB) Viewed 4989 times
Re: how to connect to MsSQL server database
Posted: Mon Jul 02, 2018 9:58 am
by studentmy
Hi,
I don't understanding The ODBC driver, it should be install on the SQL server? or the computer who running the live code program?
My Livecode program installed on Mac Os, do i need to download and OCBC with mac Os version (iODBC)?
Thank you
Re: how to connect to MsSQL server database
Posted: Mon Jul 02, 2018 4:36 pm
by FourthWorld
Unless this is strictly for LAN use, you'll want to use something like PHP, Python, or LiveCode on the server to create an HTTPS API, rather than expose the DB directly to the open Internet.
Re: how to connect to MsSQL server database
Posted: Mon Jul 02, 2018 9:18 pm
by mrcoollion
Within the Local Area Network (LAN) the ODBC driver is installed on the user's PC.