|
A connection string for ADO for Access looks like this: conn.Open('Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\temp\\Database1.accdb') The other stuff looks like the connection string for an ODBC connection. If you don't have Office 2007 or later installed, then you need the download at the link you provided. Otherwise, you have no need for it. Zev Spitz On 8/23/2012 1:00 PM,
python-win32-requ...@python.org wrote:
Send python-win32 mailing list submissions to python-win32@python.orgTo subscribe or unsubscribe via the World Wide Web, visit http://mail.python.org/mailman/listinfo/python-win32 or, via email, send a message with subject or body 'help' to python-win32-requ...@python.org You can reach the person managing the list at python-win32-ow...@python.org When replying, please edit your Subject line so it is more specific than "Re: Contents of python-win32 digest..." Today's Topics: 1. AccessDB 2007 (S, Sachin (NSN - IN/Bangalore)) ---------------------------------------------------------------------- Message: 1 Date: Thu, 23 Aug 2012 17:27:11 +0800 From: "S, Sachin (NSN - IN/Bangalore)" <sachi...@nsn.com> To: <python-win32@python.org> Subject: [python-win32] AccessDB 2007 Message-ID: <6cb66254bea4ad42b4be7becc123d33c01953...@sgsiexc025.nsn-intra.net> Content-Type: text/plain; charset="us-ascii" Hi, I am facing some problems while accessing the Microsoft Access Database 2007, using win32com. The code and errors are given below. I also tried the steps in the link but to no avail: http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734 Could you help, or also if you know of a any other way of accessing the database using the win32com module. Version: ActivePython 2.7.2.5 (ActiveState Software Inc.) based on Python 2.7.2 (default, Jun 24 2011, 12:22:14) [MSC v.1500 64 bit (AMD64)] on win32 Operating System: Windows 7 Code: try: import sys from win32com.client import Dispatch except ImportError as e: print e sys.exit(1) if __name__ == '__main__': data_source = "C:\\temp\\Database1.accdb" access = Dispatch('ADODB.Connection') access.Open('PROVIDER=Microsoft.ACE.OLEDB.12.0;Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\\temp\\Database1.accdb;') Error: C:\> a_db.py Traceback (most recent call last): File "D:\Data\Python Scripts\For the heck of sharepoint\a_db.py", line 11, in <module> access.Open('PROVIDER=Microsoft.ACE.OLEDB.12.0;Driver={Microsoft Access Driver (*.mdb, *.accdb)} ;DBQ=C:\\temp\\Database1.accdb;') File "<COMObject ADODB.Connection>", line 3, in Open File "C:\ActivePython27\lib\site-packages\win32com\client\dynamic.py", line 276, in _ApplyTypes_ result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType, argTypes) + args) pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, u'ADODB.Connection', u'Provider canno t be found. It may not be properly installed.', u'C:\\Windows\\HELP\\ADO270.CHM', 1240655, -21468245 82), None) ------------------------------ _______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32 End of python-win32 Digest, Vol 113, Issue 12 ********************************************* |
_______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
