Hello, I'm using CDatabase and CRecordset classes to access to an Oracle DataBase. I have created on the Windows Control Panel a new DSN called "SYSDD".
In the application I have the member CDatabase m_DBDescw

to access to the database I would like to know if it's right the following set of statements:

if(m_DBDescw.IsOpen())
return true;

try
{
m_DBDescw.OpenEx("DSN=SYSDD;UID=UserId;PWD=Password");
}
catch(..)
.....

The userId and Password to specify are those of the DB I want to use?
If yes, Could you possibly give me some clues on why it doesn't work?
Thank you for your attention!!!! Nicola