adoconnection1.connectionstring := loadFromRegistry('connection
String');
or something similar. Then customize it as needed.
N
Greg Nixon wrote:
>
> Sorry dumb question, but how do you mean?
>
> -----Original Message-----
> From: Nic Wise [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 6 January 2000 12:44
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: ADO questions
>
> Why not just the connection string when you start, before the DB is
> connected??? Then it doesn't matter what you use....
>
> N
>
> Greg Nixon wrote:
> >
> > Thanks for the advice.
> >
> > >7.0 ADO driver should work with 6.5, afaik. Going thru ODBC to 6.5 is
> > >not too slow, anyway.... (and its just a string! store it in the
> > >registry!)
> >
> > I only tried the 6.5 on the server with NTSP5 and SQL SP5a installed and
> it
> > couldn't find the same provider. Maybe I did something wrong I used the
> > connection string:
> >
> > Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial
> > Catalog=master;Data Source=MYSQLServer
> >
> > Which worked fine from Win98 sec to MSSQL7 but not from the server of the
> > 6.5 machine (And yes I did change the "MySQLServer" name).
> >
> ---------------------------------------------------------------------------
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
>
> --
> Nic Wise - Human (just) - at home
> [EMAIL PROTECTED] - 021.676.418
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
--
Nic Wise - Human (just) - at home
[EMAIL PROTECTED] - 021.676.418
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz