[mapserver-users] Oracle access using CONNECTIONTYPE PLUGIN

[Tamas Szekeres]

Hi,

I'm not exactly sure about your issue specifically but if you don't specify
the full tns name in the connection string, then oci will look up for
tnsnames.ora at specific locations. Use Process
Monitor<http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx>to
identify the possible lookup locations.

Best regards,

Tamas



2013/7/30 <Nelly.Howind at kivbf.de>

>   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****
>
>
>
> Kommunale Informationsverarbeitung Baden-Franken
>
> Nelly Howind
> **
> Kommunale Dienstleistungen**
> **Geoinformation und Umwelt**
> Betriebsstätte Karlsruhe****
> **
> Pfannkuchstraße 4**, 76185** Karlsruhe
>   Fon: +49 721 9529 351  Fax: +49 721 9529 500351  E-Mail:
> Nelly.Howind at kivbf.de  Internet: http://www.kivbf.de
>
>  ------------------------------
>
> Zweckverband
> Kommunale Informationsverarbeitung Baden-Franken
>
> Pfannkuchstraße 4, 76185 Karlsruhe
>
> Fon +49 721 9529 0, Fax +49 721 9529 120
> Verbandsvorsitzender: LR Hämmerle
> Hauptgeschäftsführer: William Schmitt
>
> Kommunales Rechenzentrum Baden Franken GmbH
>
> Pfannkuchstraße 4, 76185 Karlsruhe
>
> Fon +49 721 9529 0, Fax +49 721 9529 120
>
> Hauptgeschäftsführer: William Schmitt
> Handelsregister des Amtsgerichts Mannheim Nr. HRB 109683
>
>
>
> **
>
>  **
>  **
>  ****
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130730/6254810c/attachment.htm>