How to provide authentication information to queries involving Linked Tables ??

[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

[MMcCarthy]

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

Chandan

You can establish an odbc/dsn link in code but you will have to go to the C++ forum for the syntax.

Mary

[NeoPa]

It may be possible also, to set up the link so that it gets the credentials another way (stored in the DSN or even using NT credentials passed through). You'd need to check this out in the Oracle forum though.
Don't ignore Mary's post though, that could also help find a workable solution for you. Hopefully these are at least starting points for you.
Good luck.