>Using Visual Fox Pro.
>
>I am trying to connect to a SQL Server without using a DSN
>that is already defined. I was able to do this in Microsoft Visual
>Basic by creating a connection string and using an RDO object.
>
>In Visual Basic it looks like this
>
>sDSN = "uid= " & Login & ";pwd=" & Password & ";Server=" & Server) _
> ";driver={SQL Server};database=" & DBase & ";DSN='';"APP=AppName"
>
>I pass in Login, Password, Server, and DBase.
>
>Then using an rdoConnection I can connect to my SQL server. This prevents me from having to setup a DSN on all the users computers.
>
>
>Thanks for your help

Menachem,

You can create DSNless connection TO SQL Server using code beloW:

SQLSTRINGCONNECT("DRIVER={SQL Server}; Server=Myserver; UID=Myid; PWD=mypassword; DATABASE=mydatabase;"