помойму эта тема уже пролетала както сдеся ...

Вот что нарыл


No matter what I try, I get a GUI popup when I try to connect to a database, including when I take the connect string from a successful GUI connection and try to feed it back into a new connection. Help please.

// dbTechs.OpenEx(NULL, 0);
// dbTechs.OpenEx("ODBC;DSN=TechWiz;ServerName=DATABASE;ServerDSN=TechWiz;ArrayFetchOn=1;ArrayBufferSize=8;TransportHint=TCP:SPX;DecimalSymbol=.;UID=admin;PWD=rufus;");
// dbTechs.OpenEx("ODBC;Driver={Pervasive ODBC Client Interface};ServerName=DATABASE;ServerDSN=TechWiz;UID=admin;PWD=rufus");
dbTechs.OpenEx("ODBC;Driver={Pervasive ODBC Client Interface};dbq=TechWiz;ServerName=DATABASE;");
CString Connect = dbTechs.GetConnect();
dbTechs.Close();
dbTechs.OpenEx(Connect, 0);
dbTechs.Close();

-========================================================----

If you are trying to connect to a local database, create a Pervasive ODBC Engine DSN on the local machine for the database. You can use the ODBC Administrator and select "Pervasive ODBC Engine Interface" as the driver.

Let's say the Pervasive ODBC Engine DSN you've created is named MYLOCALDB.

In MFC, use this.

CDatabase db;
db.OpenEx("DSN=MYLOCALDB;");
// Do whatever you need here...
db.Close;

If you want to access a remote database, create a Pervasive ODBC Client DSN that references that remote database. You would need to specify the remote server name and remote database name during the creation of Pervasive ODBC Client DSN via ODBC Administator.

Once the Client DSN is created, let's say it is named "MYREMOTEDB", connect to MYREMOTEDB as below.

CDatabase db;
db.OpenEx("DSN=MYREMOTEDB;");
// Do whatever you need here...
db.Close;

Does it work for you?

может это еще пригодится ??

http://www.firststeps.ru/mfc/odbc/r.php?6