[mapserver-users] Oracle access using CONNECTIONTYPE PLUGIN

[Jeff McKenna]

For MS4W, I use the following syntax:

#Direct through OracleSpatial

  CONNECTIONTYPE oraclespatial
  CONNECTION "jeff/pass at SID"

#Through OGR

  CONNECTIONTYPE OGR
  CONNECTION "OCI:jeff/pass at SID"

In your shoes I would be likely be trying to connect to your Oracle data
through an ogrinfo call, and then using that exact syntax in my mapfile
for testing.

http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g-11g

-jeff


-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/



On 2013-07-30 4:07 AM, Nelly.Howind at kivbf.de wrote:
> Hi,
> 
>  
> 
> I try to access an oracle DB using following entry in mapfile:
> 
>  
> 
> CONNECTIONTYPE PLUGIN
> 
> PLUGIN "msplugin_oracle.dll"
> 
> CONNECTION "localhost,port:1521,<DBname>,<user>,<password>"
> 
> DATA "GEOM FROM WSG USING SRID 31467"
> 
>  
> 
> I installed Oracle 11g locally on Windows 2008 R2 64 bit system and can
> connect to it via Net Manager or SQL Developer.
> 
> I use a compiled mapserver  release MSVC2010 Win 64 downloaded from
> http://www.gisinternals.com/sdk/, which works fine with file based geodata.
> 
>  
> 
> Now I get an error message ORA-01005 (null password given; logon
> denied), but I set password correctly.
> 
>  
> 
> Has anybody an idea, what I am making wrong? Has connection string using
> oracle another syntax?
> 
>  
> 
> Thanks in advance
> 
> Nelly
>