db.OpenEx

**Jalabert** · 05-30-2005

hi guys

i have a new problem :|

Code:

void CDeploymentDlg::OnOK() 
{
	CString str;
	CDatabase db;

	try
	{
		db.OpenEx("DRIVER={Microsoft Access Driver(deployment.mdb)};DBQ=D:\\c_projekter\\deployment\\deployment.mdb", CDatabase::noOdbcDialog);

		//("ODBC;Description=;DRIVER=SQL Server;SERVER=TPTEST"); 
		//db.OpenEx("Driver = {Microsoft Access Driver(deployment.mdb)};DBQ=deployment.mdb");
		//db.OpenEx("deployment.mdb");
		//db.OpenEx("deployment.mdb", CDatabase::noOdbcDialog );
		//db.OpenEx("Driver={Microsoft Access Driver (deployment.mdb)};DBQ=deployment.mdb;", CDatabase::noOdbcDialog);
	}
	catch(CDBException*)
	{
		AfxMessageBox("The database deployment.mdb was not found!!!", MB_ICONERROR);
		exit(0);
		throw;
	}

i have to manually select the data source to be access... anyone know how to make it do that automaticly ?

**novacain** · 05-30-2005

>>i have to manually select the data source to be access
You can create a DSN (Data Source Name) under Windows. It holds info on the DB (driver, location ect)
[Administrative Tools -> Data Sources (ODBC)]

Then use the DSN in the call to OpenEx()

Code:

//for DSN called MyDSN
//sDB = "MyDSN"

CString  sOpenDB;
sOpenDB.Format("DSN=%s;UID=%s;PWD=%s;" ,sDB, sUserName ,sPassword);
DB.OpenEx(sOpenDB, CDatabase::noOdbcDialog);

I posted the code for a system DSN in the last thread. Can be used at run time so can be sure your app has an accurate DSN. Should work over network and local.

Thread: db.OpenEx

Thread Tools

Search Thread

Display

db.OpenEx