I want to develop an application to show the table view of the data which is stored in the Microsoft SQL server which is at a remote location. Is there is any possible way to connect to the database for inserting and fetching the data from the database?
How to connect the application to the microsoft sql server database?
Hello Madhukar,
There are dozens of ways at least. Pick the one you like the best. I strongly suggest having an HTTP front-end for the SQL Server database. Then you can serve content to your app in more friendly formats like JSON. You could also do some clever caching perhaps. You could talk directly to a SQL Server back-end by including a native client library. There are many reasons why that is a bad idea.