在Linux中通过Python脚本访问mdb数据库的方法
在 linux 系统中连接 mdb 数据库，直接连接的话，mdb 默认的驱动无法识别非 windows 的路径， 所以不能使用常规的连接方式
DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\\dir\\file.mdb
安装
这里我们需要借助一些库来实现第三方的驱动
我们需要安装这些包：mdbtools, unixODBC, libmdbodbc
如果是支持 deb 的系统中，如果不能找到 libmdbodbc ，将以下路径加入到软件源列表中
deb http://ftp.de.debian.org/debian squeeze main
更新源后即可可以安装 libmdbodbc 了
配置
安装了需要的包后，需要做一些配置，才能支持 libmdbodbc 的驱动
[MDBToolsODBC]
Description = MDB Tools ODBC
Driver = /usr/lib/libmdbodbc.so.0
Setup =
FileUsage =
CPTimeout =
CPReuse =
/etc/odbc.ini 或者 ~/.odbc.ini
Description = Microsoft Access Try DB
Driver = MDBToolsODBC
Database = /path/to/mdb/file/test.mdb
Servername = localhost
Username =
Password =
port = 5432
代码
配置好数据源后，就可以用于任何支持 odbc 访问的应用中了，这里以 pyodbc 为例
#-*- coding: utf-8 -*-
import pyodbc
conn = pyodbc.connect('DSN=test');
cursor = conn.cursor()
cursor.execute('select * from "省"')
for row in cursor.fetchall():
print row.Name
注：如果是操作名称中文的表或者字段等，需要将其包含在双引号中，不然会出错，当然，将表名做成中文这么二的做法， 还是不推荐使用的啦
pyodbc 是个很不错的库，api 也很好用，不过对中文支持的并不好，它并没有默认以 unicode 处理数据，所以对于中文相关的应用， 编码问题无处不在，只得慢慢折腾了。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Can the Python interpreter be deleted in Linux system?
Apr 02, 2025 am 07:00 AM
Regarding the problem of removing the Python interpreter that comes with Linux systems, many Linux distributions will preinstall the Python interpreter when installed, and it does not use the package manager...
How to solve the problem of Pylance type detection of custom decorators in Python?
Apr 02, 2025 am 06:42 AM
Pylance type detection problem solution when using custom decorator In Python programming, decorator is a powerful tool that can be used to add rows...
Python asyncio Telnet connection is disconnected immediately: How to solve server-side blocking problem?
Apr 02, 2025 am 06:30 AM
About Pythonasyncio...
How to solve permission issues when using python --version command in Linux terminal?
Apr 02, 2025 am 06:36 AM
Using python in Linux terminal...
Python 3.6 loading pickle file error ModuleNotFoundError: What should I do if I load pickle file '__builtin__'?
Apr 02, 2025 am 06:27 AM
Loading pickle file in Python 3.6 environment error: ModuleNotFoundError:Nomodulenamed...
Do FastAPI and aiohttp share the same global event loop?
Apr 02, 2025 am 06:12 AM
Compatibility issues between Python asynchronous libraries In Python, asynchronous programming has become the process of high concurrency and I/O...
How to ensure that the child process also terminates after killing the parent process via signal in Python?
Apr 02, 2025 am 06:39 AM
The problem and solution of the child process continuing to run when using signals to kill the parent process. In Python programming, after killing the parent process through signals, the child process still...
What should I do if the '__builtin__' module is not found when loading the Pickle file in Python 3.6?
Apr 02, 2025 am 07:12 AM
Error loading Pickle file in Python 3.6 environment: ModuleNotFoundError:Nomodulenamed...
