I'm having trouble connecting to an Oracle database via SQLSTRINGCONNECT. I spent hours reading over all related posts and I am still having trouble. Using Connection Designer I am able to connect via the Connection String method. The connection string from the designer is:

DRIVER={Microsoft ODBC for Oracle};UID=xxxxx;PWD=xxxxx;SERVER=oraprod;

I've tried multiple versions of the syntax below.

nConnectHandle = SQLSTRINGCONNECT("DRIVER={Microsoft ODBC For Oracle};SERVER=ORAPROD;UID=xxxxx;PWD=xxxxx")
? SQLEXEC(nConnectHandle,"SELECT DISTINCT"+;
" Vehicle.BaseVehicleID, VehicleToEngineConfig.EngineConfigID, Vehicle.RegionID"+;
" FROM Vehicle INNER JOIN"+;
" VehicleToEngineConfig ON Vehicle.VehicleID = VehicleToEngineConfig.VehicleID","cVALUES")


I have no problem connecting to SQL via SQLCONNET with a DSN.

Any suggestions on whats wrong?

Thanks,

Mark J. Boyer