[mapserver-users] Oracle access using CONNECTIONTYPE PLUGIN
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.how...@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Oracle access using CONNECTIONTYPE PLUGIN
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 Monitorhttp://technet.microsoft.com/en-us/sysinternals/bb896645.aspxto identify the possible lookup locations. Best regards, Tamas 2013/7/30 nelly.how...@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.how...@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Oracle access using CONNECTIONTYPE PLUGIN
On our site we use CONNECTIONTYPE oraclespatial CONNECTION 'username/password@service_name' and in tnsnames.ora: instance = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = port)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = service_name) ) ) Although you go with the plugin method I would guess it finally uses the same connection string as the integrated driver. -Ursprüngliche Nachricht- Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] Im Auftrag von nelly.how...@kivbf.de Gesendet: Dienstag, 30. Juli 2013 09:07 An: mapserver-users@lists.osgeo.org Betreff: [mapserver-users] Oracle access using CONNECTIONTYPE PLUGIN 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/ 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.how...@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Oracle access using CONNECTIONTYPE PLUGIN
For MS4W, I use the following syntax: #Direct through OracleSpatial CONNECTIONTYPE oraclespatial CONNECTION jeff/pass@SID #Through OGR CONNECTIONTYPE OGR CONNECTION OCI:jeff/pass@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.how...@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Oracle access using CONNECTIONTYPE PLUGIN
I recommend using the EZConnect syntax User/pass@host:port/service_name Or if port is 1521 then just User/pass@host/service_name On 7/30/13 9:24 AM, Jeff McKenna jmcke...@gatewaygeomatics.com wrote: For MS4W, I use the following syntax: #Direct through OracleSpatial CONNECTIONTYPE oraclespatial CONNECTION jeff/pass@SID #Through OGR CONNECTIONTYPE OGR CONNECTION OCI:jeff/pass@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.how...@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users