[python-win32] AccessDB 2007

2012-08-23 Thread S, Sachin (NSN - IN/Bangalore)
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

[python-win32] AccessDB 2007 (S, Sachin (NSN - IN/Bangalore))

2012-08-23 Thread Zev Spitz
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

Re: [python-win32] AccessDB 2007

2012-08-23 Thread Vernon Cole
Dear S.: You do have the correct name for the 64-bit Access data provider, and you have downloaded it from the correct place. I suspect that the problem could be that your connect string has both the ADO syntax (PROVIDER=) and ODBC syntax (DRIVER=) at the same time. You should probably eliminate

Re: [python-win32] AccessDB 2007 (S, Sachin (NSN - IN/Bangalore))

2012-08-23 Thread Zev Spitz
That connection string works if you're using the pyodbc library, which uses ODBC under the hood. The questioner is using win32com to get at the ADODB.Connection object, which uses a different connection string format. Zev Spitz On 8/23/2012 4:38 PM, Ahmed, Shakir wrote: You can try this

Re: [python-win32] mxDateTime problem with embedded Python

2012-08-23 Thread Mark Hammond
On 24/08/2012 4:00 AM, Will Sadkin wrote: Hi all, I have a bit of a stumper. We have a C++ program in which we embed a release python interpreter, so that both our C++ and python programs can share a single codebase, written in Python. When building the program for debug, we always #undef