Communication of VB6 application outside client network with SQL server inside network

Is there way to make the vb6 desktop application which i开发者_开发问答s not on client network to communicate with sql server which is in the client premises?

A far better option (a necessity if the app is for general distribution) is to use an intermediary service, either over web/HTTP or some other (possibly custom) protocol.

If you app is specific to your company/employer for their internal use, then you will need to use a VPN or similar to allow it to work as if it was on the same internal network.

Note that opening up a database server to the wider internet is asking for trouble and should be avoided at all costs.

Easiest would be to use port forwarding on border router to SQL server.

Better would be to encrypt traffic to/from SQL Server like this: IPSec through NAT: Securing SQL Server remote connections