Issue 106213 - [notesSQL] connect lotus notes and open-office: odbc problem
Summary: [notesSQL] connect lotus notes and open-office: odbc problem
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-10-23 05:45 UTC by threaderslash
Modified: 2020-03-26 20:27 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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