To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106213 Issue #|106213 Summary|connect lotus notes and open-office: odbc problem Component|Database access Version|1.0.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|threaderslash
------- Additional comments from [email protected] Fri Oct 23 04:45:53 +0000 2009 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
