Hi,

I need to establish a connection with a SQL Database to exchange datas through a VPN. I had neved done that before and I need help.

There is the informations available:

xxx.xxx.xxx.xxx\database name
servdata01.domain.local
username ( domain )
password
The VPN tunnel is always open on the domain.

So, how do I use that to create the connection with the database? Do I have to create an ODBC item? How do I manage the difference between a domain user and a SQL user?

At the end, I should connect to the SQL database from a VFP9 apps to retreive and update datas in differents tables.


Thanks,