Problem with an odbc connection

antti siukola siukola.antti at GMAIL.COM
Thu Jun 28 16:25:14 EDT 2007


Hi!
I get this error now:

I run #ogrinfo name.ovf --debug on
ERROR 4: Update access not supported for VRT datasources.
OGR_ODBC: EstablishSession(DSN:"dsn", userid:"user", password:"pass")
ODBC: SQLConnect(myodbc)
ODBC: ... failed: [unixODBC][Driver Manager]Driver's SQLAllocHandle on
SQL_HANDLE_HENV failed
ODBC: SQLDisconnect()
ERROR 1: Unable to initialize ODBC connection to DSN for user/pass at dsn,
[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
FAILURE:
Unable to open datasource `name.ovf' with the following drivers.

ODBC connection works fine with isql and ogrinfo if used directly but
not with ovf.

What can I do?

Here's the ovf:

<OGRVRTDataSource>

    <OGRVRTLayer name="name">
        <SrcDataSource>ODBC:user/pass at dsn</SrcDataSource>
        <SrcSQL> Tested and working SQL</SrcSQL>
        <GeometryField encoding="WKT" field="geom"/>
     </OGRVRTLayer>

</OGRVRTDataSource>

The same ovf works fine on 2 other servers but not on my new one.

Regards!

Antti S



More information about the mapserver-users mailing list