I am trying to get an Oracle connection without using Administrative Tools - Data Sources (ODBC).

Right now I have a connection in the ODBC part of my computer which tells VFP to go to the "prod" Oracle database. I would like to get rid of this manual process of setting up the machine. I would prefer to go "DSN Less" as it would be stated in the Help files.

I have a connection string that looks like the following:

lcConnection	= "DRIVER={Oracle in OraClient10g_home1};" + ;
	"SERVER=myserver;" + ;
	"UID=myappuid;" + ;
	"PWD=myapppwd"

? SQLSTRINGCONNECT(lcConnection)

When the SQLSTRINGCONNECT() fires, a prompt comes up with the UID and PWD filled in. The SERVER part is not. The Dialog has a caption beside it that says "SERVICE NAME". I have also tried "SERVICE=myserver;", but the dialog still pops up. When I enter in the value "myserver" into the field and press enter, the process returns 1.

Does anyone know what it will take to make this work?