General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only