Changes between Version 1 and Version 2 of PGeo

Timestamp:

Dec 6, 2007, 9:07:17 AM (16 years ago)

Author:

Mateusz Łoskot

Comment:

Added PGeo notes

PGeo

@@ -1 +1 @@
 = OGR PGeo Driver = 
 
-Put notes about OGR PGeo driver here. 
+This page collects notes about OGR [http://www.gdal.org/ogr/drv_pgeo.html PGeo] driver.
+
+The PGeo driver works very well on Windows. On Unix-like systems, it uses [http://www.unixodbc.org/ unixODBC] with [http://mdbtools.sourceforge.net/ MDB Tools] driver (libmdbtools) and the driver is unstable and broken in some places (refer notes below and PGeo driver manual for details).
+
+== DSN-less Connection Notes ==
+
+Generally, DSN-less connection is broken in MDB Tools. Here is post about this [http://article.gmane.org/gmane.comp.db.mdb-tools.devel/1038 DSN-less connection not supported?] sent to mdbtools-dev list but no reply has arrived so far. The libmdbtools expects ''DSN'' token in connection string, so opening .mdb file directly fails. This problem was identified in version ''mdbtools-0.6pre1'' but ''mdbtools-0.5.99.0.6pre1.0.20050409'' worked fine.
+
+As manual recommendeds, the best option is to open Personal Geodatabase (.mdb file) using configured DSN connection. However, if one needs to open .mdb file directly, here is small patch for MDB Tools' file ''src/odbc/odbc.c'': 
+
+{{{
+#!C
+--- mdbtools-0.6pre1/src/odbc/odbc.c    2004-05-30 10:06:43.000000000 +0200
++++ patched/mdbtools-0.6pre1/src/odbc/odbc.c    2006-05-23 23:08:54.000000000 +0200
+@@ -156,7 +156,8 @@
+ 
+    params = ((ODBCConnection*) hdbc)->params;
+ 
+-   if (!(dsn = ExtractDSN (params, szConnStrIn)))
++   /* XXX - mloskot DSN-less connection
++    * if (!(dsn = ExtractDSN (params, szConnStrIn)))
+    {
+       LogError ("Could not find DSN in connect string");
+       return SQL_ERROR;
+@@ -168,6 +169,7 @@
+    }
+    else 
+    {
++   */
+       SetConnectString (params, szConnStrIn);
+ 
+       if (!(database = GetConnectParam (params, "Database")))
+@@ -175,7 +177,7 @@
+         LogError ("Could not find Database parameter");
+         return SQL_ERROR;
+       }
+-   }
++   /* }*/
+    ret = do_connect (hdbc, database);
+    return ret;
+ }
+}}}