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