>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?
Hi Gordon,

dbq=' + pcdatabase

this is what I use and do not get the prompt coming up. pcdatabase should be the name of the database connecting to.

HTH
Beth