Microsoft Access从Linux python读取 [英] Microsoft Access read from linux python
问题描述
您好，
我需要从MS Access数据库中读取数据。
程序（阅读器）安装在Linux机器上并且
是用python语言编写的。
数据库是安装在Win XP盒子上的MS Access 2002
与linux盒子联网。
python / linux是否有可能从MS Access读取数据
数据库？
我已经阅读了很多内容关于mxODBC，iODBC等的事情，
但我仍然很困惑，看起来好像是_not_
可能。
想法？体验？
David ROBERT。
Hello,
I need to read data from a MS Access database.
The program (reader) is installed on a linux box and
is written in python langage.
The database is MS Access 2002 installed on a Win XP box
networked with the linux box.
Is it possible for python/linux to read data from MS Access
Database ?
I''ve read a lot of things about mxODBC, iODBC and so on,
but I''m still very confused, It looks like it is _not_
possible.
Ideas ? experiences ?
David ROBERT.
推荐答案
David ROBERT< da *** @ ombrepixel.com>在消息新闻中写道：< bn *********** @ biggoron.nerim.net> ...
David ROBERT <da***@ombrepixel.com> wrote in message news:<bn***********@biggoron.nerim.net>...
你好，
我需要从MS Access数据库读取数据。
程序（阅读器）安装在Linux机器上，用python语言编写。
数据库是安装在Win XP盒子上的MS Access 2002
与linux盒子联网。
python / linux是否有可能从MS Access数据库中读取数据？
我读过关于mxODBC，iODBC等的很多事情，
但是我仍然很困惑，看起来它可能是_not_
可能。
想法？经历？
AFAIK，Python能够从Windows访问MS Access 2002。您将需要在Win XP上安装Python，并安装Mark Hammond的win32all。
它可以与任何Microsoft COM组件连接，其中包括MS
Office程序。
您需要在Win XP上编写一个Python脚本，询问
Access数据库。然后你需要写一些Python网络
的东西来连接Win XP到Linux（也许使用XML-RPC）。
这假定你不能只是导出访问更开放的
数据库，并且放弃访问。
David ROBERT。
Hello,
I need to read data from a MS Access database.
The program (reader) is installed on a linux box and
is written in python langage.
The database is MS Access 2002 installed on a Win XP box
networked with the linux box.
Is it possible for python/linux to read data from MS Access
Database ?
I''ve read a lot of things about mxODBC, iODBC and so on,
but I''m still very confused, It looks like it is _not_
possible.
Ideas ? experiences ?
AFAIK, Python IS able to access MS Access 2002 from Windows. You will
need to install Python on Win XP, and install Mark Hammond''s win32all.
It can interface with any Microsoft COM component, which includes MS
Office programs.
You will need to write a Python script on Win XP that interrogates an
Access database. Then you''ll need to write some Python networking
stuff to connect Win XP to Linux (maybe using XML-RPC).
This assumes that you can''t just export Access to a more open
database, and ditch Access.
David ROBERT.
在文章< d3 ************************* @ posting.google.com> ，
Mark Carter< ca ********** @ ukmail.com>写道：
In article <d3*************************@posting.google.com> ,
Mark Carter <ca**********@ukmail.com> wrote:
David ROBERT< da *** @ ombrepixel.com>在消息中写道
新闻：< bn *********** @ biggoron.nerim.net> ...
David ROBERT <da***@ombrepixel.com> wrote in message
news:<bn***********@biggoron.nerim.net>...
你好，
我需要从MS Access数据库中读取数据。
程序（阅读器）安装在Linux机器上，
是用python语言编写的。
数据库安装在MS Access 2002上一个Win XP盒子与linux盒子联网。
python / linux是否有可能从MS Access数据库中读取数据？
我'已经阅读了很多关于mxODBC，iODBC等的东西，
但我仍然很困惑，看起来它可能是_not_
。
想法？体验？
Hello,
I need to read data from a MS Access database.
The program (reader) is installed on a linux box and
is written in python langage.
The database is MS Access 2002 installed on a Win XP box
networked with the linux box.
Is it possible for python/linux to read data from MS Access
Database ?
I''ve read a lot of things about mxODBC, iODBC and so on,
but I''m still very confused, It looks like it is _not_
possible.
Ideas ? experiences ?
AFAIK，Python能够从Windows访问MS Access 2002。您将需要在Win XP上安装Python，并安装Mark Hammond的win32all。
它可以与任何Microsoft COM组件连接，其中包括MS
Office程序。
您需要在Win XP上编写一个Python脚本来查询
Access数据库。然后你需要编写一些Python网络来连接Win XP到Linux（可能使用XML-RPC）。
这假设你不能只导出Access到一个更开放的数据库和沟渠访问。
AFAIK, Python IS able to access MS Access 2002 from Windows. You will
need to install Python on Win XP, and install Mark Hammond''s win32all.
It can interface with any Microsoft COM component, which includes MS
Office programs.
You will need to write a Python script on Win XP that interrogates an
Access database. Then you''ll need to write some Python networking
stuff to connect Win XP to Linux (maybe using XML-RPC).
This assumes that you can''t just export Access to a more open
database, and ditch Access.
[David ROBERT]
[David ROBERT]
我需要从中读取数据一个MS Access数据库。
程序（阅读器）安装在一个linux盒子上，
是用python语言编写的。
嗯。什么是程序？它是你写的python脚本吗？
或者其他人写过你必须更新？什么是
阅读它呢？它目前是如何做到的？是否在一个
非Linux操作系统上运行？
在linux上运行的python客户端可以访问任何服务器上的任何数据库
操作系统，如果可以获得该数据库的ODBC驱动程序。
服务器和客户端都需要了解ODBC，这是一种
通用数据库协议/ API 。
数据库是安装在Win XP盒子上的MS Access 2002
与linux盒子联网。
如果你能得到一个ODBC数据源设置为该数据库，然后
你在那里的一半。在Win 2K上（关于XP的dunno）转到控制
面板 - >管理工具 - >数据源（ODBC），然后添加DSN ;
为您的MS Access数据库。存在与安全选择系统DSN相关的安全/隐私问题
。与用户DSN相对应，我将给你留下你想要读取的内容。
python / linux是否有可能从MS Access读取数据
数据库？
是的，如果linux客户端支持ODBC。也可以将
修改回数据库。
Python有一个名为DB-API的标准化数据库API，它具有非常
对很多不同数据库的原生支持。许多当前可用的DB-API模块也支持ODBC，你可以在这个页面上查看
http://www.python.org/topics/database/modules.html
据我所知，大多数或所有支持ODBC的模块将在linux上运行。
我读了很多关于mxODBC，iODBC等等的东西，
但我仍然很困惑，看起来它可能是_not_
。
I need to read data from a MS Access database.
The program (reader) is installed on a linux box and
is written in python langage.
Hmmm. What is "the program"? Is it a python script you have written?
Or that someone else has written and you must update? What is the
"reading" that it does? How does it do it currently? DOes it run on a
non-linux operating system?
A python client running on linux can access any database on any server
operating system if one can obtain an ODBC driver for that database.
Both server and client need to understand ODBC, which is a kind of
universal database protocol/API.
The database is MS Access 2002 installed on a Win XP box
networked with the linux box.
If you can get an ODBC "data source" set up for that database, then
you''re half way there. On Win 2K (dunno about XP) Go to "Control
Panel"->"Administrative Tools"->"Data Sources (ODBC)", and add a "DSN"
for your MS Access database. There are security/privacy concerns
related to informed choice of "System DSN" vs. "User DSN", which I''ll
leave for you to read up on.
Is it possible for python/linux to read data from MS Access
Database ?
Yes, if the linux client supports ODBC. It''s also possible to make
modifications back to the database.
Python has a standardised database API called "DB-API", which has very
wide native support for a lot of different databases. A number of the
currently available DB-API modules also support ODBC, which you can
see on this page
http://www.python.org/topics/database/modules.html
As far as I''m aware, most or all of the modules that support ODBC will
run on linux.
I''ve read a lot of things about mxODBC, iODBC and so on,
but I''m still very confused, It looks like it is _not_
possible.
一切皆有可能。这只是努力的问题;-)
-
alan kennedy
------ -----------------------------------------------
在此检查http标头： http://xhaus.com/headers
电子邮件alan： http://xhaus.com/mailto/alan
这篇关于Microsoft Access从Linux python读取的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
