I'm trying to create an OGR file that can be opened in QGIS that pulls in vector data from an Oracle Database. I've tried a few combinations of things but can't seem to get anything to work. I've few questions if anyone could help:
Does the file need to be .ovf or a .vrt? Does this matter?
Can the OGR file use oracle spatial geometry or do you have to encode it from data in the columns?
The connection string I've used is in the format username/password@databasename. I have Oracle instant client installed (which works correctly with other applications). Is this all you need in the connection string or do you need the full URL + Port number for the database and also the schema?
Thanks very much for any help!
<OGRVRTDataSource> <OGRVRTLayer name="TEST_LAYER_NAME"> <SrcDataSource>OCI:testuser/testpass@testDB</SrcDataSource> <SrcLayer>TEST_POINTS</SrcLayer> <GeometryField encoding="PointFromColumns" x="EASTINGS" y="NORTHINGS"/> </OGRVRTLayer> </OGRVRTDataSource>