Change the password on fly

Hi,

This is .Net application Visual Studio 2003 and have crystal reports. I need to connect the database with another password. I am using as back end 10 g.

For e.g -

Acutal

Server - a

user id - b

password - c

but on fly I have to give

Server - a

user id - b

password - d or no password

Can I do this through proxy passord or otherways ? Please advice me

For Each CrTable In CrTables

crtableLogoninfo = CrTable.LogOnInfo

crtableLogoninfo.ConnectionInfo = crConnectionInfo

crtableLogoninfo.TableName = CrTable.Name

CrTable.ApplyLogOnInfo(crtableLogoninfo)

Next

Please let me if you need further clarification