python lotus notes: odbc connect error

threaderslash · 10-22-2009, 03:46 AM

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

Code:

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

it gives the error

Code:

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.

Jim Bengtson · 10-22-2009, 08:41 AM

From Lotus Support (hope this helps):

http://www-01.ibm.com/support/docvie...=utf-8&lang=en

threaderslash · 10-22-2009, 06:31 PM

I will try your suggestion...

then put the final solution here. Thanks a lot!

threaderslash · 10-22-2009, 08:18 PM

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 other hints please?

Jim Bengtson · 10-22-2009, 09:30 PM

Quote:

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

The Lotus help page said the problem is with the server name configured in the connection...I notice in the connection statement above you reference "localhost". Notes refers to the local hard drive as "Local", not "Localhost". Try changing that...

threaderslash · 10-22-2009, 11:36 PM

yes.. I tried using "local". still didn't work and gives the same message error:

Code:

pyodbc.Error: ('S1000', "[S1000] [Lotus][ODBC Lotus Notes]Unable to validate userid John Meyer (23341) 
(SQLDriverConnectW); [01000] [Microsoft][ODBC Driver Manager] 
The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). (0);

any idea?

Jim Bengtson · 10-23-2009, 08:44 AM

I hesitate to ask but...does the userid "John Meyer" have access to that database natively in Notes? Do you have a Notes client installed on the PC you're using?

Have you reviewed this information:

System requirements

To use Notes data through ODBC, you must have:

* NotesSQL, the Lotus Notes ODBC driver
* An ODBC Driver Manager version 3.5 or later
* One of the following:
o Microsoft Windows 2000 or XP
o Microsoft Windows 2003 Server Standard Edition or Enterprise Edition
* One of the following:
o Lotus Notes Client release 6.0 or later
o Lotus Domino release 6.0 or later
o IBM Lotus Domino Designer release 6.0 or later
o IBM Lotus Domino Off-Line Services release 1.01 or later

To download Lotus NotesSQL, visit the developerWorks Lotus Toolkits page or go directly to the IBM Software Downloads site.

threaderslash · 10-23-2009, 05:53 PM

Hi... thanks for the feedback. Yep, I have ticked all the boxes - all the previous listed requirements are present in the system.

At this point I am working on it to check what is the problem. I read that Lotus Notes / NotesSQL doesn't support .Net, but only C++ (http://www-01.ibm.com/support/docvie...id=swg21169645). Maybe, it also doesn't support python.

If anyone else has some other guess, let me know. I will see what come next to put this thing running. If I come to some solution, it will be posted here in the hope to help others too.