CDatabase Open

[magix]

Hi,

I'm using Visual C++ and doing INSERT process into mdb file
May I know if it is possible to use Absolute path to specifiy mdb file ?
where mdb file is at the same directory as the executable.
How to change to accomodate absolution path in CDatabase Open ?


i.e
CString sDriver;
CString sDsn;
CString sFile;
CDatabase db;

sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)";
sFile = "my.mdb";

sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);
db.Open(NULL,false,false,sDsn);

Thanks.

Regards,
Magix

 

[peter koch]

Hi,

I'm using Visual C++ and doing INSERT process into mdb file
May I know if it is possible to use Absolute path to specifiy mdb file ?
where mdb file is at the same directory as the executable.
How to change to accomodate absolution path  in CDatabase Open ?

i.e
 CString sDriver;
 CString sDsn;
 CString sFile;
 CDatabase db;

 sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)";
 sFile = "my.mdb";

 sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);
 db.Open(NULL,false,false,sDsn);

Thanks.

Regards,
Magix

Better ask that in a microsoft forum. They have loads of knowledgeable
experts there (and the quesiton would be on-topic as well).

/Peter