Yikes. Can you give any pointers as to what I should be looking at? In terms of setting up the environment, all I've done is install the Oracle 9i client on the web server, and mapserver/mapscript with a version of gdal compiled with the ogr_oci dll as a plugin. To have the plugin recognized I set the GDAL_DRIVER_PATH variable (until then ogrinfo didn't recognize OCI as a supported format) to the Windows\system32 folder where this dll resides.
What do you mean by other OCI client programs? Oracle client itself has no troubles connecting to the database. Also, 2083788472 doesn't look like an Oracle error code? (Aren't they usually "ORA-XXXXX"?) Thanks. ------------------------------ Mark Adams Senior Analyst & Project Manager Cuesta Systems (DPRA Canada) 5230 South Service Road Burlington, ON L7L 5K2 Phone: 905-333-4544 x14 Fax: 905-333-0455 Email: [EMAIL PROTECTED] -----Original Message----- From: Frank Warmerdam [mailto:[EMAIL PROTECTED] On Behalf Of Frank Warmerdam Sent: June 6, 2006 9:36 PM To: Mark Adams Cc: [email protected] Subject: Re: [UMN_MAPSERVER-USERS] problem with ogr oracle spatial layer Mark Adams wrote: > OCI: OCIEnvCreate() failed with status 2083788472. > > Presumably Oracle is not properly installed, skipping. Mark, Based on this, I would say the problem is not with your connection string or something later. But rather is somehow related to the version of libraries being used. This error message is produced by the following code: if( ghOracleEnvironment == NULL ) { nStatus = OCIEnvCreate( &ghOracleEnvironment, OCI_OBJECT, (dvoid *)0, 0, 0, 0, (size_t) 0, (dvoid **)0 ); if( nStatus == -1 || ghOracleEnvironment == NULL ) { CPLDebug("OCI", "OCIEnvCreate() failed with status %d.\n" "Presumably Oracle is not properly installed, skipping."); return FALSE; } } As you can see, there is no meaningful arguments passed to OCIEnvCreate() so the problem would appear to be regardless of anything about mapserver, or GDAL. I would suggest looking into OCI library versions and setup. Do other OCI client programs work on this system? You might also try looking up the error code in the Oracle error database. Best regards, -- ---------------------------------------+-------------------------------- ------ I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush | President OSGF, http://osgeo.org
