Can i get data/database from Microsoft SQL Server ? How?

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
adrianyong
Posts: 3
Joined: Sat Dec 08, 2018 2:59 pm

Can i get data/database from Microsoft SQL Server ? How?

Post by adrianyong » Fri Jan 04, 2019 10:52 am

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

Klaus
Posts: 13793
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Can i get data/database from Microsoft SQL Server ? How?

Post by Klaus » Fri Jan 04, 2019 11:09 am

Hi Adrian,

welcome to the forum!
I moved this thread to the correct forum (Hint, hint!), since this is really no announcement!


Best

Klaus

bangkok
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 937
Joined: Fri Aug 15, 2008 7:15 am

Re: Can i get data/database from Microsoft SQL Server ? How?

Post by bangkok » Fri Jan 04, 2019 11:13 am

adrianyong wrote:
Fri Jan 04, 2019 10:52 am
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
yes you can access a MS Sql server from Livecode. By using the "odbc" method of connection.

Search the forum.

For instance :

viewtopic.php?f=12&t=31915

bogs
Posts: 5435
Joined: Sat Feb 25, 2017 10:45 pm

Re: Can i get data/database from Microsoft SQL Server ? How?

Post by bogs » Fri Jan 04, 2019 12:36 pm

You can also find a lot of information about it on Max's excellent Wiki.
Image

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 9801
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles
Contact:

Re: Can i get data/database from Microsoft SQL Server ? How?

Post by FourthWorld » Fri Jan 04, 2019 6:23 pm

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
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn

Post Reply

Return to “Databases”