Re: [PyDB2-discuss] connecting to DB2

[Jon T. <jon...@gm...>]

I hope this is relevant.
Here's a wrapper that I use to connect from windows to windows DB2
7.2, DB2 8.2, DB2 9.1 and linux DB2 9.1.

You can use the catalog name for the dns name, or you can use a
special DNSString. As you can see you could use that DNSString to
specify port and protocol as well

def Connection(self, autoCommit = False):
        import DB2
        import config
        db_name, db_host, db_username, db_password = config.get_db_parameters()
        if db_host:
            DNSString =
"Provider=IBMDADB2;Database=%s;Hostname=%s;Protocol=TCPIP;Port=50000;"
% (db_name, db_host)
        else:
            DNSString = db_name
        logging.debug(DNSString)
        return DB2.connect(DNSString, uid=db_username,
pwd=db_password, autoCommit=autoCommit)


On 2007-05-04 09:43 Jeremy M. Jones <zanesdad@be...> wrote
>connect() method. It seems that dsn should be the hostname, uid should
>be the user id, and pwd should be the password. But somewhere I read
>that some option in the dsn should be a catalog name if you're