MapServer, IIS and Oracle

[Léveillé, James]

Hi,
 
I've been using MapServer (with Apache) with Oracle (10g) on Win XP.
Everything use to work perfectly ...
 
I'm now trying to make MapServer work on IIS, instead of Apache.
I'm using the same computer, but Apache was removed. 
Here is what I did:
- MS4W was downloaded and unzipped.
- libmap.dll was downloaded and the original one was replaced (in
...\ms4w\Apache\cgi-bin).
- 3 Env. vars were defined, as specified in
(http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto/view
<http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto/view> ).
- Full control was given (for now) to the internet user on the Oracle home
directory.
- getCapabilities looks OK (INPUT=ORACLESPATIAL)
 
As I recall, I'm using the same computer, so the Oracle connection should be
fine (it was working fine).
But I get the following error when testing :
 
The WMS Server issued the following exception: msDrawMap(): Image handling
error. Failed to draw layer named 'MyLayer'. msOracleSpatialLayerOpen():
OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check
the connection string. Error: ORA-12154: TNS: could not resolve service
name.
 
Any solutions ??
 
Thanks
 
__________________________________________
James Léveillé
 
Intélec Géomatique
420, boul. Charest Est
Bureau 400
Québec (QC), Canada
G1K 8M4
 
Intélec Géomatique: 418.687.5000
MTQ: 418.380.2005 (#227)
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060504/a236d4f3/attachment.html