Issue 106213

Summary: [notesSQL] connect lotus notes and open-office: odbc problem
Product: Base Reporter: threaderslash <threaderslash>
Component: codeAssignee: AOO issues mailing list <issues>
Severity: Trivial    
Priority: P3 CC: issues, knmc, mechtilde, oooforum
Version: OOo 1.0.0Keywords: oooqa
Target Milestone: ---   
Hardware: Unknown   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description threaderslash 2009-10-23 05:45:53 UTC
Hello Everybody,

I am trying to put NotesSQL to work on Python to allow to connect data from .nsf
files, then select what interest to generate pdf forms through win32com and
openOffice. Unfortunatelty I got stuck in the communication with the NotesSQL.
Here is what I did:

# on winXP, OpenOffice3.1.1, NotesSQL, Lotus Notes 6, pyODBC, python2.5;

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

but it gives me the error:
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);

if I do the same procedure, but to connect MySQL, it works fine.

Any suggestions? All comments are highly appreciated.
Comment 1 Mechtilde 2010-01-09 13:50:20 UTC
Is there a special ODBC Driver for NotesSQL?
Comment 2 oooforum (fr) 2020-03-26 14:04:50 UTC
No news from OP since a long time ago