Localhost Vs Servername in Connection string of SQL Server 2000

Hi,
Do you know how ADO will behave based upon the servername that is
specified in the connection string of SQL Server 2000? When does it
work with localhost and when does it not? Is it documented that this is
the expected behavior?
Thanks,
Regards,
Pramod
With SQL Server2000 or older, the server name is "Compuername" or "(local)",
(plus "\instanceName" if necessary). It is not "localhost", which is used to
refer to web server, not SQL Server (I may be wrong on this: you can use
"localhost' for SQL Server 2005, though).
<ipramod@.gmail.com> wrote in message
news:1164191517.623131.63680@.e3g2000cwe.googlegrou ps.com...
> Hi,
> Do you know how ADO will behave based upon the servername that is
> specified in the connection string of SQL Server 2000? When does it
> work with localhost and when does it not? Is it documented that this is
> the expected behavior?
> Thanks,
> Regards,
> Pramod
>
|||Hi,
Is there any difference when we use (local) or localhost in connection
strings of SQL Server 2000 ?
Thanks,
Pramod
Norman Yuan wrote:[vbcol=seagreen]
> With SQL Server2000 or older, the server name is "Compuername" or "(local)",
> (plus "\instanceName" if necessary). It is not "localhost", which is used to
> refer to web server, not SQL Server (I may be wrong on this: you can use
> "localhost' for SQL Server 2005, though).
> <ipramod@.gmail.com> wrote in message
> news:1164191517.623131.63680@.e3g2000cwe.googlegrou ps.com...