|
Home > Archive > MS SQL Server > December 2006 > Localhost Vs Servername in Connection string of SQL Server 2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Localhost Vs Servername in Connection string of SQL Server 2000
|
|
| ipramod@gmail.com 2006-11-22, 5:15 am |
| 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
| |
| Norman Yuan 2006-11-22, 7:12 pm |
| 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.googlegroups.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
>
| |
| ipramod@gmail.com 2006-12-04, 7:12 pm |
| Hi,
Is there any difference when we use (local) or localhost in connection
strings of SQL Server 2000 ?
Thanks,
Pramod
Norman Yuan wrote:[color=darkred
]
> 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.googlegroups.com...
|
|
|
|
|