A connection was successfully established with the server, but then an error occurred during the log

[matt.delvecchio]

i saw a similar post from last year, but i didnt see any clear
solution. the error message:

"A connection was successfully established with the server, but then an
error occurred during the login process. (provider: TCP Provider,
error: 0 - The specified network name is no longer available.)

Exception Details: System.Data.SqlClient.SqlException: A connection was
successfully established with the server, but then an error occurred
during the login process. (provider: TCP Provider, error: 0 - The
specified network name is no longer available.)"


....it would appear to have something to do w/ SQL Server connectivity.
when i get it, i get it repeatedly. however, if i go to a non-db page,
then page to a db-page, it's cleared up.

i am running ASP.NET 2.0, on a commerical hosting environment
(www.datapacket.net), w/ a SQL 2000 server. no problems in dev, usually
works in this prod env.


any ideas what would cause this strangeness?

thanks,
matt

 

[sloan]

Do a google search for

"Network Library"
"dbmssocn"

You can add some extra "hints" to the connection string, which might help.

You should post your connection string to the group, so it can be evaluated
also.

 

[matt.delvecchio]

connection string:

<connectionStrings>
<add name="FooBar"
connectionString="server=x.x.x.x; database=FooBar; UID=foo; Pwd=bar"
providerName="System.Data.SqlClient"/>
</connectionStrings>

 

[matt.delvecchio]

Do a google search for

"Network Library"
"dbmssocn"

ok can you be a littler more specific here (or, even, completely
clear)? i found some links that indicate this is a way one can set the
network library via the conn string:

http://support.microsoft.com/kb/q238949/

and the 2nd post here:

http://www.mcse.ms/archive85-2004-10-1155447.html

....says "dbmssocn" is the TCP/P network library and "dbnetlib" is the
new.

but, i have no idea what network libraries are, or why id want to use
them. none of the ASP.NET 2.0 articles/docs/code examples ive come
across specify a network library in the conn strings. what are these?
why did you refer them to me? are you aware of ongoing connection
difficulities if specifiying one is omitted?


thanks,
matt