Yes, I did reboot ... The real problem was that I had to give READ permissions on the "tnsnames.ora" and "Sqlnet.ora" files to the internet user. Now, its work fine.
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) -----Message d'origine----- De : Bart van den Eijnden (OSGIS) [mailto:[EMAIL PROTECTED] Envoyé : 5 mai 2006 03:40 À : Léveillé, James Cc : [email protected] Objet : Re: [UMN_MAPSERVER-USERS] MapServer, IIS and Oracle IIS only picks up new system environment variables after a reboot. Did you reboot? Best regards, Bart Léveillé wrote: > 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) > -- Bart van den Eijnden OSGIS, Open Source GIS http://www.osgis.nl
