DBMSSOCN General Network Error

[James]

Periodically, our entire website will display the following error for all
users when requests are made to ASP pages:

DBMSSOCN General Network Error

HTML pages will load just fine, and I *believe* that ASP pages that don't
access SQL Server will also load. Someone suggested this problem has to do
with named pipes, but I don't have any clue when it comes to networking and
our network admin just resigned. This happens very sporadically (maybe once
a day) and never seemed to occur when he had DSN based connections. We also
have migrated our SQL Server to another machine (used to reside on the same
machine as our webserver).

Any ideas on what could be causing this? Googling it has proven
futile...and I'm pulling my hair out here.

Thanks!
James

[Mark Schupp]

Show your connection string (change passwords and/or server address).

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"James" <le********@verizon.net> wrote in message
news:eX****************@TK2MSFTNGP12.phx.gbl...

Periodically, our entire website will display the following error for all
users when requests are made to ASP pages:

DBMSSOCN General Network Error

HTML pages will load just fine, and I *believe* that ASP pages that don't
access SQL Server will also load. Someone suggested this problem has to
do
with named pipes, but I don't have any clue when it comes to networking
and
our network admin just resigned. This happens very sporadically (maybe
once
a day) and never seemed to occur when he had DSN based connections. We
also
have migrated our SQL Server to another machine (used to reside on the
same
machine as our webserver).

Any ideas on what could be causing this? Googling it has proven
futile...and I'm pulling my hair out here.

Thanks!
James

[James]

conn.Open "Provider=SQLOLEDB;Data Source=XXXXX;Initial Catalog=XXXXX;User ID
= XXXXX;Password=XXXXX"

Thanks!
James

"Mark Schupp" <no******@email.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Show your connection string (change passwords and/or server address).

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"James" <le********@verizon.net> wrote in message
news:eX****************@TK2MSFTNGP12.phx.gbl...

Periodically, our entire website will display the following error for all users when requests are made to ASP pages:

DBMSSOCN General Network Error

HTML pages will load just fine, and I *believe* that ASP pages that don't access SQL Server will also load. Someone suggested this problem has to
do
with named pipes, but I don't have any clue when it comes to networking
and
our network admin just resigned. This happens very sporadically (maybe
once
a day) and never seemed to occur when he had DSN based connections. We
also
have migrated our SQL Server to another machine (used to reside on the
same
machine as our webserver).

Any ideas on what could be causing this? Googling it has proven
futile...and I'm pulling my hair out here.

Thanks!
James