0

I have to connect remotely to my MSSQL database. However, I am a little unsure as to the best way to do this. Can I connect directly to the database from my client machine, or would it be best to create some kind of local script that does the connection and serves XML or JSON to my client?
Also, what what will need to be configured on my database to allow this connection, and on the computer hosting the database? Will I need to set it up as a web-server?

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by 12d3
0

I have to connect remotely to my MSSQL database. However, I am a little unsure as to the best way to do this. Can I connect directly to the database from my client machine, or would it be best to create some kind of local script that does the connection and serves XML or JSON to my client?
Also, what what will need to be configured on my database to allow this connection, and on the computer hosting the database? Will I need to set it up as a web-server?

This may help:

http://www.daniweb.com/forums/thread21636.html

Personally, I think there is no need to use XML for this... but I suppose it depends on what you are trying to achieve.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.