Hi,

I'm trying to build a prototype in VFP 8 which uses a SQL Server 2000 backend. I mean to get it done very quickly as it is only a prototype and the frontend will not be built with VFP. Here's where I am right now:

-created a new project, created a new form
-right-clicked form and opened the data-environment
-clicked cancel to the dialog box
-right-click data-environment box, selected builder

And that's where I'm at. The database resides on a remote server called "Rydar" and the sql server 2000 DB is there and waiting. I would prefer to use a connection string but am not having any success with it. When using the DB via SQL Server Enterprise Manager I am using windows suthentication, however, I am also able to use SQL Server authentication. Any help with the connection string??

Thanks very much!