Can i get data/database from Microsoft SQL Server ? How?
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- Posts: 3
- Joined: Sat Dec 08, 2018 2:59 pm
Can i get data/database from Microsoft SQL Server ? How?
I would like to ask how can I get data/database from Microsoft SQL Server to LiveCode as Im currently building a User LogIn Registration part of an app, in terms of getting user's username, password, phone num & email address. Thx
Re: Can i get data/database from Microsoft SQL Server ? How?
Hi Adrian,
welcome to the forum!
I moved this thread to the correct forum (Hint, hint!), since this is really no announcement!
Best
Klaus
welcome to the forum!
I moved this thread to the correct forum (Hint, hint!), since this is really no announcement!
Best
Klaus
Re: Can i get data/database from Microsoft SQL Server ? How?
yes you can access a MS Sql server from Livecode. By using the "odbc" method of connection.adrianyong wrote: ↑Fri Jan 04, 2019 10:52 amI would like to ask how can I get data/database from Microsoft SQL Server to LiveCode as Im currently building a User LogIn Registration part of an app, in terms of getting user's username, password, phone num & email address. Thx
Search the forum.
For instance :
viewtopic.php?f=12&t=31915
Re: Can i get data/database from Microsoft SQL Server ? How?
You can also find a lot of information about it on Max's excellent Wiki.
-
- VIP Livecode Opensource Backer
- Posts: 9802
- Joined: Sat Apr 08, 2006 7:05 am
- Location: Los Angeles
- Contact:
Re: Can i get data/database from Microsoft SQL Server ? How?
Unless the app is carefully restricted to work only within your local network, you will not want your app to connect to the database directly, as that would require exposing your database to the open Internet. Your client app will instead make HTTP calls to an API on the server which then connects to the database locally on that server.
You can craft your HTTP API in LiveCode Server, or PHP, Perl, Python, or any other scripting language suitable for server work.
When PHP is used in that role, generically the setup is referred to as LAMP (Linux, Apache, MySQL, PHP), and there are innumerable tutorials available around the web on setting that up.
To use LiveCode Server in that role, these lessons will be helpful:
http://lessons.livecode.com/m/4070
You can craft your HTTP API in LiveCode Server, or PHP, Perl, Python, or any other scripting language suitable for server work.
When PHP is used in that role, generically the setup is referred to as LAMP (Linux, Apache, MySQL, PHP), and there are innumerable tutorials available around the web on setting that up.
To use LiveCode Server in that role, these lessons will be helpful:
http://lessons.livecode.com/m/4070
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