In Linux, The Python script is used to access the mdb database.

In Linux, The Python script is used to access the mdb database.

If you connect to the mdb database in linux, the default drive of mdb cannot identify non-windows paths, so you cannot use conventional connections.Method

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\\dir\\file.mdb

Install

Here we need to use some libraries to implement third-party drivers.

We need to install these packages: mdbtools, unixODBC, and libmdbodbc

If libmdbodbc cannot be found in a deb-supported system, add the following path to the software source list.

Deb http://ftp.de.debian.org/debian squeeze main

After updating the source, you can install libmdbodbc.
Configuration

After the required package is installed, some configuration is required to support the libmdbodbc driver.

Copy codeThe Code is as follows:/etc/odbcinst. ini

[MDBToolsODBC]
Description = MDB Tools ODBC
Driver =/usr/lib/libmdbodbc. so.0
Setup =
FileUsage =
CPTimeout =
CPReuse =

/Etc/odbc. ini or ~ /. Odbc. ini

Copy codeThe Code is as follows: [test]
Description = Microsoft Access Try DB
Driver = MDBToolsODBC
Database =/path/to/mdb/file/test. mdb
Servername = localhost
Username =
Password =
Port = 5432

Code

After the data source is configured, it can be used in any application that supports odbc access. Here, pyodbc is used as an example.

#-*-Coding: UTF-8-*-import pyodbcconn = pyodbc. connect ('dsn = test'); cursor = conn.cursor(your cursor.exe cute ('select * from "Province" ') for row in cursor. fetchall (): print row. name

Note: If the operation name is a Chinese table or field, you need to include it in double quotation marks. Otherwise, an error will occur. Of course, the method of making the table name Chinese is as follows, it is not recommended.

Pyodbc is a very good library, and the api is also very useful, but it does not support Chinese, it does not use unicode to process data by default, so for Chinese-related applications, coding problems are everywhere, so I had to wait for a while.