Use SQLSTRINGCONNECT() instead.
>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
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."