"Lisa Pearlson" <no@spam.plz> wrote in message
news:Ohmp0if2DHA.2528@TK2MSFTNGP10.phx.gbl...
> CDatabase::GetConnect() returns "ODBC; ..."
>
> However, CDatabase::OpenEx() may not include "ODBC;". It will fail to
> connect if it has that prefix.
>
> So you can not simply do:
>
> {
> CDatabase a, b;
> a.OpenEx("..."); // assume this connects fine.
> // try another connection to the same.
> b.OpenEx( a.GetConnect() ); // fails: Data source name not found and
no
> default driver specified
> }
>
> I must remove the "ODBC;" prefix.. Why this intolerance? This is
cumbersome!
> This means I can not simply store GetConnect() string to resource and open
a
> new DB connection using it.
> I guess I can use Open() instead of OpenEx() but that sucks too.

> "Lisa Pearlson" <no@spam.plz> wrote in message
> news:Ohmp0if2DHA.2528@TK2MSFTNGP10.phx.gbl...
> > CDatabase::GetConnect() returns "ODBC; ..."
> >
> > However, CDatabase::OpenEx() may not include "ODBC;". It will fail to
> > connect if it has that prefix.
> >
> > So you can not simply do:
> >
> > {
> > CDatabase a, b;
> > a.OpenEx("..."); // assume this connects fine.
> > // try another connection to the same.
> > b.OpenEx( a.GetConnect() ); // fails: Data source name not found and
> no
> > default driver specified
> > }
> >
> > I must remove the "ODBC;" prefix.. Why this intolerance? This is
> cumbersome!
> > This means I can not simply store GetConnect() string to resource and
open
> a
> > new DB connection using it.
> > I guess I can use Open() instead of OpenEx() but that sucks too.
>
> You could perhaps write a function that extracts the fields you want.
> b.OpenEx( to_conn_str(a.GetConnect()) );
>
> Tom.
>
>