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