How to provide authentication information using DAO classes??

[Chandan Ahuja]

Hello ,
I use MFC DAO classes to access my MS access database .

I am using some linked tables(Linked to Oracle) in my MS Access database .

Also i have some queries in my databse , these queries select some rows from the linked tables and insert them in MS access local tables .

I am facing problem while executing these queries .
The problem is that -- through the code ; when i am asking these query to execute , it prompts for username password of the Oracle Database with which linked tables are linked .

//************* Following is my C++ code

CDaoQueryDef queryDef(piDAOConn.mDatabase);
queryDef.Open("DwnNpr");
queryDef.Execute(dbFailOnError); //this statement prompts for
// Username & Password information through
// an Oracle ODBC Driver Prompt


//*************


Is it possible for me to provide the username and password to the queryDef
through the code itself before executing the query statement so that it does not pops up a prompt window .

I will be very thankful to you if you can help me out in any way .

Thanks and Best Regards ,
Chandan Ahuja