[DB-SIG] connect to db2

[DJ Webre]

I can connect to my db2 table using:

        self.conn = odbc.odbc('SQLPROD/d6407/password')

but I can not connect using:


        con_str =
"'"+self.box_1.GetValue()+'/'+self.box_3.GetValue()+'/'+self.box_4.GetValue()+"'"
        print con_str
        try:
            #self.conn = odbc.odbc('SQLPROD/d6407/password')
            
            self.conn = odbc.odbc(con_str)


I get the following error:

Traceback (most recent call last):
  File "D:\Documents and Settings\djwebre\My Documents\My
Data\Python\mysql\c1.py", line 244, in OnBtnConnect
    self.conn = odbc.odbc(con_str)
dbi.operation-error: [Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified in LOGIN


Any suggestions are appreciated.

__________________________________________________
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute