python pyodbc - connect error

[GoogleCodeExporter]

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.

Original issue reported on code.google.com by threader...@gmail.com on 22 Oct 2009 at 6:52

[GoogleCodeExporter]

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.

Original comment by mkleehammer on 22 Oct 2009 at 11:53

• Changed state: Investigating

[GoogleCodeExporter]

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

Original comment by threader...@gmail.com on 22 Oct 2009 at 11:25

[GoogleCodeExporter]

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?

Original comment by threader...@gmail.com on 23 Oct 2009 at 1:31

[GoogleCodeExporter]

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!

Original comment by threader...@gmail.com on 4 Nov 2009 at 10:39

[GoogleCodeExporter]

One more thing, I think the original problem was that you had

  SERVER=local

instead of

  SERVER=localhost

Original comment by mkleehammer on 31 Dec 2009 at 6:48

• Changed state: Invalid

[GoogleCodeExporter]

Original comment by mkleehammer on 21 Nov 2010 at 4:43

• Changed state: NoFix

[GoogleCodeExporter]

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" ?

Original comment by joe.roch...@gmail.com on 3 Jun 2011 at 11:42