ODBC error when performing without dialog

[Sanjai]

Hi,

I am using an ODBC driver to query and import data from a DB2 database. Users have their own passwords and login id to the DB2 database. There would be a button to be clicked to query and import the data from DB2. I want that the users should be prompted with the password dialog box and once they enter their password, the entire import process should be automatic.

I have tried working and it works fine when I save the user name and password permanently into the script. As I said that each user has its own login and password, if I don't save the user id and password, the application gives an ODBCError "Invalid userid/password".

Please let me know if anyone has a solution.

Thanks,

--Sanjai