🚀 go-pugleaf

On Sun, 29 Dec 2002 18:55:36 +0100, "Ing Giuseppe Monteleone"
<info@ing-monteleone.com> wrote:

>Hi guys,
>
>I have a strange problem with MSSQL 2000. With a TADOConnection I can
>connect only when i put the connection string in the Object Inspector. When
>i put the same string with istruction
>
>adoConnection->ConnectionString = conString;
>
>does not work.
>
>I need to assign it dinamically because I need to acess to two different
>database (an user choice)
>
>Thanks
>Giuseppe Monteleone
>

Which kind of "strange problem"?

Maybe you are trying to change the connection string in a wrong place. 
A good place to change the connection string could be in the Before Connect
event's body. For example:

void __fastcall TdmMain::adoConnectionBeforeConnect(TObject *Sender)
{
    adoConnection->ConnectionString = GetAConnectionString();
}

Also, make sure to invoke 'Disconnect' before changing the connection string
if you are already connected. For example, try with something like the
following code:

void __fastcall TdmMain::SetConnString( AnsiString Val )
{
    if ( Val != adoConnection->ConnectionString ) {
        Disconnect();
        adoConnection->ConnectionString = Val;
    }
}

Hope this helps.

Giuliano