[DB-SIG] Simple? ODBC connection issue

[Peter Machell]

I'm using pyodbc to connect to several databases.

On one of them, the database password needs to be a variable.

If I hard code the password, the connection works fine:

cnxn = pyodbc.connect("DSN=test;UID=test;PWD=test")

However substituting a variable fails:

passwd='test'
connectstring='pyodbc.connect("DSN=test;UID=test;PWD='+passwd+'")'
cnxn = connectstring

I get an ODBC login failed error.

Sorry if I'm just having a Friday brain problem but I just can't get  
this to work, can anyone help?

regards,
Peter.