python lotus notes: odbc connect error

Question

Hello Everybody...

I am developing a client server application for a cross-database system.

I am using Eclipse IDE with Python 2.5 and PyODBC2.5; need to read content from a Lotus Notes database, so run some basic query like - SELECT peronname FROM tablename.

'import pyodbc' is ok - python see it!

But when I try to run

conn = pyodbc.connect("DRIVER={Lotus NotesSQL Driver};SERVER=localhost;UID=John Meyer;PWD=yellowbird;DATABASE=mydb.nsf")

it gives the error

pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnectW)') [01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0)

Any suggestions - what should be missing here? All comments and suggestions are highly appreciated.

Answer 1

Hi again.. I have done the same test using pyodbc, but to MySQL ODBC driver. It works fine for MySQL. The problem still remains to Lotus Notes. Any hints please?

Answer 2

I think it's odd that you want to try accessing Lotus Notes data vie SQL. When I have interfaced Notes and Python in the past, I always used the Lotus Note COM object to access data. After all, Notes is a document database like CouchDB, not a relational database.

Answer 3

Hi, I've met the same problem with an Oracle database. It used to work on my previous computer, with these parameters: DRIVER={Microsoft ODBC for Oracle};SERVER=myServer.COM;UID=admin;PWD=admin But I can't make it work on my new machine.

I've got no problem to connect to my base with other programs, like Squirrel, so I wonder why pyodbc can't.

Any idea ?

Answer 4

I almost forgot to post the solution here...

We have managed to put NotesSQL to work through ODBC with python to access data from our Lotus Notes *.NSF files (database). It works as queries using the same type of queries syntax you would need normally use to get the data when working on MS-Access to grab the info inside the Lotus Notes *.nsf file.

So we got access to the data via SQL using ODBC.