[mapserver-users] Oracle access using CONNECTIONTYPE PLUGIN

[Smith, Michael ERDC-RDE-CRREL-NH]

I recommend using the EZConnect syntax

User/pass at host:port/service_name

Or if port is 1521 then just

User/pass at host/service_name




On 7/30/13 9:24 AM, "Jeff McKenna" <jmckenna at gatewaygeomatics.com> wrote:

>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-1
>0g-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
>> 
>_______________________________________________
>mapserver-users mailing list
>mapserver-users at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/mapserver-users