connect to sql

Hi
I have two machine one is application server (asp) and one is database
server (sql 2000).
Between them, I use a crossover cable connect each other(1GB) and also they'
re all connect to internet use another network card(100 MB).
I test locally and the speed is good, but just found it's very slow after we
moved the machined to the collocation. How to trouble this? Please help.
just found out use name instead of ip and change from to SQLOLEDB
provider=SQLOLEDB.1 and it works fine.
why is that? please advice.
<js@.someone.com> wrote in message
news:eyKXm6r8GHA.4708@.TK2MSFTNGP05.phx.gbl...
> Hi
>
> I have two machine one is application server (asp) and one is database
> server (sql 2000).
> Between them, I use a crossover cable connect each other(1GB) and also
they'
> re all connect to internet use another network card(100 MB).
> I test locally and the speed is good, but just found it's very slow after
we
> moved the machined to the collocation. How to trouble this? Please help.
>
>
|||It affects things when you have more than two version on the
computer. If you use just SQLOLEDB, it will point to the
latest version of the provider. When you use SQLOLEDB.1, you
are specifying a specific version with the ProgID.
You may want to use the MDAC Component Checker to check your
MDAC installation. You can download it from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
-Sue
On Wed, 18 Oct 2006 12:54:57 -0400, <js@.someone.com> wrote:

>just found out use name instead of ip and change from to SQLOLEDB
>provider=SQLOLEDB.1 and it works fine.
>why is that? please advice.
><js@.someone.com> wrote in message
>news:eyKXm6r8GHA.4708@.TK2MSFTNGP05.phx.gbl...
>they'
>we
>