>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