August 17, 2005 at 3:20 am
Right now we use in our vb6 code an sqloledb connection to connect over the intranet to our sql server.
In the near future we are going to implement mobile devices which need to connect over the internet. Of course we want to re-use as much code as possible.
So question is how to connect to sql server over the internet using an sqloledb connection. We are talking about medical data from patients so security is a main issue!!
Cheers,
Jan
August 17, 2005 at 8:57 am
You should not connect directly between the mobile devices and the sql server over the internet.
If you did that it would expose sql server to the internet, which is not recommended.
Your going to need to refactor your application a little bit for use on these mobile devices. They should make calls to webservice, or IIS to send and receive the data.
There may be 3rd party apps that can help you with this to minimize application changes, but I don't know any off hand.
Or you can have your remote devices run thru a winframe client, and run the application serverside, but that could be a little sluggish.
My $.02
Ray
August 17, 2005 at 9:55 am
Security is an issue and opening SQL to the Internet can be troublesome. Having your SQL ports open, which is all you really need to do, would work. You could do some port redirection, like connect from the Internet to port 53421 and have the firewall redirect that down to 1433.
Better to get some VPN tunnel setup for your app, even build the connect procedure in there and then work as normal through a secured tunnel.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply