OGR and oracle (MS4W 1.5)

[listuser HH]

Frank Warmerdam wrote:

> listuser HH wrote:
>
>> Hi all,
>>
>> I started to test the new ms4w package - I like it. I tried the 
>> oracle connection with mapserver and ogr - both work fine.
>>
>> The next thing I wanted to test was a ogr VRT with points from a x / 
>> y table. I get the message: ORA-12514: TNS:listener does not 
>> currently know of service requested in connect descriptor in 
>> <unnamed>. In the .ovf file I use the same connection like in the 
>> mapfile before (OCI:usr/pwd@//serverIp:port/dbName). I have to say 
>> that I don't use a TNS because the oracle instant client don't have a 
>> tnsnames.ora file and I wasn't sure where to put one. I hoped that 
>> this will not be necessary since the other connections work. Has 
>> anyone a hint?
>
>
> Norbert,
>
> You should be able to put the same thing in your <SrcDataSource> element
> in the VRT file that you would normally use as the datasource name when
> doing direct access with ogrinfo or MapServer.  The only think I can
> think to be careful of is to apply XML escaping for an characters likely
> to be special in your connect info.  For instance if there is an angle
> bracket in it, you would need to replace this with < or >.
>
> I don't believe the "TNS" aspect will be any different through VRT or
> more directly.  It is more likely that the initial connect is failing
> due to some corruption in the connect info and then the OCI libraries are
> falling back to the TNS mechanism, that fails and that is the error that
> is reported.
>
> PS. This is great news that the new MS4W supports Oracle!  Kudo's to
> Howard and Assefa.
>
> Best regards,

Hi Frank,

thanks for the answer. You are right something in the connection is 
failing. I used SrcLayer for the data source definition - when I use 
SrcSQL with a "select * .." it works.

Shouldn't SrcLayer work too or have I overlooked something?

Best regards

Norbert