[Zope] dynamic database connection

Hi, I am using mxODBC to connect to sql server 2000. I need to create a dynamic connection based on dsn,username and password given by the user. All my zsql methods should use this connection. Advise on the same. Thanks in advance. Kailashnath.