Let's take a step back.
Do you have
any experience with VFP and SQL Server?
>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,
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer