Accessing remote SQL Server Database.

Solar2D Network
#1

I’ve already seen that someone created a similiar topic,

but in his case his server was written in PHP and the database was of mysql.

In my case it is an SQL Server Database and ther server is written in Asp.net (c#)

is there a way to access the SQL Server anyways?

Thanks!

#2

Using ASP.net (C#) and SQL Server should be the same concepts.  You will write an interface script in ASP.net that speaks standard HTTP GET, POST, PUT and DELETE requests for inbound data, and output JSON or XML to the request.  Then whoever is writing your server side script should know how to make ASP.net talk to MS SQL.

I wrote a basic tutorial for MySQL and PHP because that’s what I know.  But the ideas should be the same.

http://omnigeek.robmiracle.com/2012/04/15/using-corona-sdk-with-rest-api-services/

Rob

#3

Using ASP.net (C#) and SQL Server should be the same concepts.  You will write an interface script in ASP.net that speaks standard HTTP GET, POST, PUT and DELETE requests for inbound data, and output JSON or XML to the request.  Then whoever is writing your server side script should know how to make ASP.net talk to MS SQL.

I wrote a basic tutorial for MySQL and PHP because that’s what I know.  But the ideas should be the same.

http://omnigeek.robmiracle.com/2012/04/15/using-corona-sdk-with-rest-api-services/

Rob