SQL connections over a VPN

[PhilEvelyn]

I wrote a VB6 app a few years ago that connects to an SQL server 2000 backend over an office network. The connection was via a connection string, "provider; datasourse; blah blah blah".

Now the client wants to install the app on remote sites that will connect via VPN. I had hoped that the app would not need any adaptaions and that the VPN would make the workstation think it was part of the office network. WRONG!!

So how do I make the app aware of the SQL database? Do I have to use an ODBC DSN or do I have to make changes to the app as well?

Any suggestions will be greatfully received.

Phil

 

[TLGsoft]

In ODBC, set your connection to TCP/IP. TLGsoft

"If it works, don't fix it"