Hi Martin, On Thu, 10. Apr 2014 at 23:33:00 +0200, Martin Landa wrote: > C:\OSGeo4W_oci>ogrinfo -ro OCI:user/[email protected]:1251/xe -sql "select > count(*) from emp" > OGR: Auto register C:\OSGeo4W_oci\\bin\gdalplugins\ogr_OCI.dll using > RegisterOGR > OCI. > OCI: Userid=landa, Password=stratos5, Database=127.0.0.1:1251/xe > ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified > in <unnamed> > FAILURE: > Unable to open datasource `OCI:landa/[email protected]:1251/xe' with the > follow > ing drivers.
Also no 11g XE at hand, but for 11g using the service name instead of the SID might help. Not sure what the default for XE is. lsnrctl status should show it. Eg. ogrinfo OCI:foo/bar@localhost/xe.world Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de QGIS PSC member (RM) Germany IRC: jef on FreeNode -- norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502 _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
