🚀 go-pugleaf

Thanks Carlos

Samuel

"Carlos" <shangri-la@teleline.es> wrote in message news:3d481fb2_1@dnews...
> If you want to change the content of the Connection String if the user
> change the DSN you have 2 options:
>
> If you use a DSN in a file:
>
> ConnectionString = "FILE NAME=old_path\file.dsn";
> Connected = false;
> ConnectionString = "FILE NAME=new_path\file.dsn"
>
> If you use a system DSN:
>
> ConnectionString =  "Provider=provider ; Data Source=old_DSN; ..."
> Connected = false;
> ConnectionString = "Provider=provider ; Data Source=new_DSN; ..."
>
> Bye!
>
>
> "Samuel" <samuel@hectrix.com> escribi?en el mensaje
> news:3d479081_1@dnews...
> > May be my question is not clear. I want to know what should be the
content
> > of the connection string. Or, any other method can make my program
change
> > the database manually.
> >
> > Samuel
> >
> > "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
> > news:3d478d39_1@dnews...
> > > You do not need DSN with ADO (if your OLEDB provider is not ODBC). You
> can
> > > change ConnectionString as
> > >
> > > ADOConnection1->Connected = false;
> > > ADOConnection1->ConnectionString = "NewConnectionString";
> > > ADOConnection1->Connected = true;
> > >
> > > Regards,
> > > Vassiliev V.V.
> > > http://www.oledbdirect.com
> > >
> > > "Samuel" <samuel@hectrix.com> ������?�������� ?�������� ��������?
> > > news:3d475995$1_1@dnews...
> > > > Hi,
> > > >     I have an application that my client can change his DSN / ODBC
> > > setting.
> > > > Can I use ADO to do this? As I use mODBC before but I want to change
> to
> > > ADO
> > > > now. Could anyone tell me how to change the connection string???
> > > > Thanks alot
> > > >
> > > > Samuel
> > > >
> > > >
> > >
> > >
> >
> >
>
>