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
