>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!

sqlH = SQLSTRINGCONNECT([Driver={SQL Server};DataBase=Rydar;Server=MyServerName;Trusted_Connection=yes;])
*** or
sqlH = SQLSTRINGCONNECT([Driver={SQL Server};DataBase=Rydar;Server=MyServerName;UID=user_name_here;PWD=password_here])