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
how to connect to MsSQL server database
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Re: how to connect to MsSQL server database
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).
Re: how to connect to MsSQL server database
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
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
-
- VIP Livecode Opensource Backer
- Posts: 9840
- Joined: Sat Apr 08, 2006 7:05 am
- Location: Los Angeles
- Contact:
Re: how to connect to MsSQL server database
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.
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
-
- Posts: 720
- Joined: Thu Sep 11, 2014 1:49 pm
- Location: The Netherlands
Re: how to connect to MsSQL server database
Within the Local Area Network (LAN) the ODBC driver is installed on the user's PC.