[PyDB2-discuss] [Fwd: pydb2 dsn question]

[Patrick K. O'B. <po...@or...>]

David,

I'm forwarding your question to the pydb2 mailing list where I think you
have a better chance of getting a reply.  Feel free to join as well.

Pat

-- 
Patrick K. O'Brien
Orbtech       http://www.orbtech.com
Schevo        http://www.schevo.org
Louie         http://www.pylouie.org


-------- Original Message --------
Subject: pydb2 dsn question
Date: Tue, 25 Apr 2006 10:34:08 +0200
From: DAVID ARAKELIAN <dav...@et...>
To: po...@or..., man...@gm...



hello I read https://www6.software.ibm.com/dw/education/dm/db2pylnx
a quick little question about the DSN.

I am really new to db2, so here is my question
I have a IBM db2 server running at : SERVER on PORT and the dns='DBSCXXXX'
I instaled the pydb2 module, installation worked fine. the import DB2 too.

but when I try to do

conn = DB2.connect(dsn='SERVER:PORT/DBSCXXXX',uid='myuser',
pwd='mypassword')

I obtain:
  File "/usr/lib/python2.3/site-packages/DB2.py", line 271, in __init__
    self._db = _db2.connect(*args, **kwargs)
_db2.DatabaseError: ('I', -1, 'Invalid Handle')

I think i didn't understodd how the DSN exactly works. could you explain
me if
I run the server on other port/machine how should I bind the dsn?

best regards
A.David