<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Verdana size=2><SPAN
class=803524815-04052006>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=803524815-04052006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>I've been using
MapServer (with Apache) with Oracle (10g) on Win XP.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>Everything use to
work perfectly ...</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=803524815-04052006></SPAN></FONT> </DIV>
<DIV><FONT><SPAN class=803524815-04052006></SPAN></FONT><FONT face=Verdana
size=2><SPAN class=803524815-04052006>I'm now trying to make MapServer work on
IIS, instead of Apache.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>I'm using the same
computer, but Apache was removed. </SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>Here is what I
did:</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>- MS4W was
downloaded and unzipped.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>- libmap.dll was
downloaded and the original one was replaced (in
...\ms4w\Apache\cgi-bin).</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>- 3 Env. vars were
defined, as specified in (<A
href="http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto/view"><FONT
face=Verdana
size=2>http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto/view</FONT></A>).</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>-
Full control was given (for now) to the internet user on the
Oracle home directory.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>- getCapabilities
looks OK (INPUT=ORACLESPATIAL)</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=803524815-04052006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>As I recall, I'm
using the same computer, so the Oracle connection should be fine (it was
working fine).</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>But I get the
following error when testing :</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=803524815-04052006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana color=#ff0000 size=2><SPAN
class=803524815-04052006><STRONG>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.</STRONG></SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=803524815-04052006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=803524815-04052006>Any solutions
??</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=803524815-04052006></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=803524815-04052006>Thanks</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=803524815-04052006></SPAN></FONT> </DIV>
<DIV align=left><FONT face=Verdana
size=2>__________________________________________</FONT></DIV>
<DIV align=left><FONT face=Verdana size=2><STRONG>James
Léveillé</STRONG></FONT></DIV>
<DIV align=left><FONT face=Verdana size=2><FONT size=1><FONT
face=Verdana> </DIV></FONT></FONT></FONT>
<DIV align=left><FONT face=Verdana color=#0000a0 size=2><STRONG>Intélec
Géomatique</STRONG></FONT></DIV>
<DIV align=left><FONT face=Verdana size=1>420, boul. Charest Est<BR>Bureau
400<BR>Québec (QC), Canada<BR>G1K 8M4</FONT></DIV>
<DIV align=left><FONT face=Verdana size=1></FONT> </DIV>
<DIV align=left><FONT face=Verdana color=#c0c0c0 size=1>Intélec Géomatique:
418.687.5000</FONT></DIV>
<DIV align=left><FONT face=Verdana color=#c0c0c0 size=1>MTQ: 418.380.2005
(#227)</FONT></DIV>
<DIV> </DIV></BODY></HTML>