I have changed my connection to:
lcConnection = "DRIVER={Oracle in OraClient10g_home1};" + ;
"DBQ=myserver;" + ;
"UID=myappuid;" + ;
"PWD=myapppwd"
? SQLSTRINGCONNECT(lcConnection)
The prompt is gone and the result is 1. Thank you.
>>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