| Issue 71: | python pyodbc - connect error | |
| 1 person starred this issue and may be notified of changes. | Back to list |
What steps will reproduce the problem?
1. I am using Eclipse IDE with Python 2.5; need to read content from a
Lotus Notes database, so run some basic query like - SELECT peronname FROM
tablename.
2. 'import pyodbc' is ok - python see it!
3. But it doesn't connect, when I try to run
conn = pyodbc.connect("DRIVER=Lotus NotesSQL Driver};SERVER=local;UID=John
Meyer;PWD=yellowbird;DATABASE=mydb.nsf")
What is the expected output? What do you see instead?
It should connect. But it gives me the error:
pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified (0) (SQLDriverConnectW)')
What version of the product are you using? On what operating system?
pyodbc25 WinXP
Please provide any additional information below.
Please, any hint or suggestion? Thanks in advance.
Oct 22, 2009
Hi Thanks.. I have already tried with {} -
conn = pyodbc.connect("DRIVER={Lotus NotesSQL Driver};SERVER=local;UID=John
Meyer;PWD=yellowbird;DATABASE=
mydb.nsf")
still gives me the same error:
pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified (0) (SQLDriverConnectW)')
Any other help please? cheers... ThreaderSlash
Oct 22, 2009
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?
Nov 4, 2009
Hello Everybody,
We have managed to put NotesSQL to work through ODBC with python to access data from
our Lotus Notes *.NSF files. 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. But also, on windows, you have to connect
without using UID, Server, and PWD -- it worked just like that:
import pyodbc ...
connection=pyodbc.connect("Driver={Lotus NotesSQL Driver (*.nsf)};
DATABASE=mydb.nsf", autocommit=True)
After I will see how to enable to also use the other parameters - UID, etc. It should
need some additional twigs on WinXP enviroment.
But the important is, we got locally direct access to the data we needed -- using
ODBC. Then we transferred the data from Lotus to our new MySQL db!
Hope this info may save time and help others too.
Yes... we love happy endings!
Dec 31, 2009
One more thing, I think the original problem was that you had SERVER=local instead of SERVER=localhost
Status:
Invalid
Nov 21, 2010
(No comment was entered for this change.)
Status:
NoFix
Jun 3, 2011
Did anyone ever figure out how to bind to a remote domino server? Seems there is some strange Uid/Pwd aspects to this.... (Notes has "ID Files" ? |
You are missing the opening brace for the driver keyword: DRIVER=Lotus NotesSQL Driver} should be : DRIVER={Lotus NotesSQL Driver} Let us know how that works.