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
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
...@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
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
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