how to connect to MsSQL server database

[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

[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 5627 times

[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

[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.

[mrcoollion]

Within the Local Area Network (LAN) the ODBC driver is installed on the user's PC.