Post reply

connecting from vb6 over the internet using sql oledb

  • August 17, 2005 at 8:57 am

    #582771

    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

    #582806

    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 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply