Try adding the database name to your connection string (database = mydata). If I leave it out in my string it opens a box asking for a table name (not DSN?).

John

>I am trying to connect to my SQL server with FoxPro. I know I can create a ODBC connecton and have Fox connect using =SQLCONNECT("odbc connection"), but how do I connect with out create a odbc connection or dsn connection. I would like to do something like this:
>
>lcDSNLess="driver = SQL Server;server=server;uid=sa;pwd="
>lnConnHandle=sqlstringconnect(lcDSNLess)
>
>(Notes: I changed the above not to match my server name and password.)
>
>when I do this it pops up a box for me to select a dsn file. I do not want to create any files on the workstations. I just want to copy the program onto the harddrvie to the workstations and run it.
>
>What am I doing wrong??????
>
>
>Thanks