ODBC issue when importing 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, all the steps in the import process(eg: clicking on ok to select the import order, clicking on ok to perform auto enter operations while import etc) are manual. If I don't save the password and perform the import without dialog then the application gives an ODBCError "Invalid userid/password".

Please let me know if anyone has a solution to perform an import automatically and each user should enter his own password.

Thanks,

--Sanjai