C / C++ / MFC

// Embed a CDatabase object<br />
// in your document class<br />
CDatabase m_dbCust;<br />
<br />
// Connect the object to a<br />
// data source (no password)<br />
// the ODBC connection dialog box<br />
// will always remain hidden<br />
m_dbCust.Open( _T( "MYDATASOURCE" ), FALSE,<br />
               FALSE, _T( "ODBC;UID=JOES" ),<br />
<br />
// ...Or, query the user for all<br />
// connection information<br />
m_dbCust.Open( NULL );

CDatabase m_db; //you can have this in the .h file<br />
<br />
//The code checks for Oracle 8 first, and if not found, it checks for Oracle 9<br />
try<br />
{<br />
	CString sConnect;<br />
	sConnect ="DRIVER={Oracle in Ora81RET}; DBQ= MYDATABASE.LOCAL; UID=scott; PWD=tiger; PFC=500";<br />
	m_DB.OpenEx(sConnect, CDatabase::noOdbcDialog);<br />
}<br />
catch(CDBException *x)<br />
{<br />
	try<br />
	{<br />
		CString sConnect;<br />
		sConnect ="DRIVER={Oracle in OraHome92}; DBQ= MYDATABASE.LOCAL; UID=scott; PWD=tiger; PFC=500";<br />
		m_DB.OpenEx(sConnect, CDatabase::noOdbcDialog);<br />
	}<br />
	catch(CDBException *x)<br />
	{<br />
		CString szTemp = "Database Connection not responding due to following reason(s):\n\n";<br />
		szTemp += x->m_strError;<br />
		AfxMessageBox(szTemp, MB_ICONERROR);<br />
		exit(1);<br />
	}<br />
}

CRecordset cSet(&m_DB);<br />
CString szSomething;<br />
CString szSQL = "SELECT SOMETHING FROM SOMEWHERE" //your query<br />
cSet.Open(CRecordset::forwardOnly, szSQL, CRecordset::readOnly);<br />
while(!cSet.IsEOF())<br />
{<br />
	cSet.GetFieldValue((int)0, szSomething);<br />
	cSet.MoveNext();<br />
}<br />
cSet.Close();

"One must learn from the bite of the fire to leave it alone." - Native American Proverb

"One must learn from the bite of the fire to leave it alone." - Native American Proverb