Python/MS Access Interface

[Joyrider564]

Hi, I am looking on using Python to interface with MS Access databases. If someone could help me out with comparing databases with it, or just pointing me in the right direction, that would be great! Thank you!

 

[EBGreen]

I haven't tried it, but I would start here:

http://www.python.org/windows/win32/odbc.html

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[Cagliostro]

any of DAO/ADO/ODBC/just ActiveX

Ion Filipski

 

[mikrom]

I use ADO to process *.dbf (dBase/FoxPro) or AS/400 (DB/2) databases with Python.
The procedure is the same, you only need to specify another connection string for every database.

for *.dbf databases the connection string is e.g.

DSN='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\Perl_Python\Database;\
	      Extended Properties=FoxPro 3.0;'

for DB/2 on AS/400 e.g.

DSN='PROVIDER=IBMDA400;DATA SOURCE='+csebk+'; USER ID='+userid+'; PASSWORD='+pwd

and for MS Access it would be probably (i never tried it) something like this

DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:/MyDB.mdb;'

Excellent soure, where you shoud start if you want use ADO in Python is this page

http://www.ecp.cc/pyado.html

 

[123qweasdzc]

And for Oracle?

 

[EBGreen]

This is where I always start for connection strings:

http://www.connectionstrings.com/

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]