473,326 Members | 2,108 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Transport Level Error has occured

I am getting the following error.
A transport-level error has occurred when sending the request to the
server. (provider: Shared Memory Provider, error: 0 - The system cannot
open the file.)

On performing the same operation again, it happens fine without any
error.
Please help.

Regards,
Shilpa

Apr 5 '06 #1
5 32694
Shilpa (sh*************@unisys.com) writes:
I am getting the following error.
A transport-level error has occurred when sending the request to the
server. (provider: Shared Memory Provider, error: 0 - The system cannot
open the file.)

On performing the same operation again, it happens fine without any
error.


That's just the way it works. If Mgmt Studio looses contact with SQL
Server, because the network goes down and up, or SQL Server is restarted,
you will get this message. Next time you try, SSMS reconnects automatically.
Query Analyzer handles this situation more gracefully, as it reconnects
directly when it detects that the connection is broken.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Apr 5 '06 #2
Hi Erland,
I am using SQL Server 2000. So, it does not hvae a management studio.
Could you please explain now?

Regards,
Shilpa

Apr 5 '06 #3
Shilpa (sh*************@unisys.com) writes:
I am using SQL Server 2000. So, it does not hvae a management studio.
Could you please explain now?


It would help if you had explained exactly in which context you get this
error.

As long as I don't, I will have to assume that you are running a .Net
application that uses SqlClient to connect to SQL 2000. And then as I said
in my previous post, the network connection drops or SQL Server is restared
and you get this error.

That's all I can say with the information you have to provided so far.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Apr 5 '06 #4
Yes, you are right.
I am using a .Net application

Here are the sequence of actions
1) Drop all connections to a database by using the ALTER DATABASE
command
2) Drop the database
3) Recreate the database and populate it with some data
4) Select a value from a table using a where condition (no joins).
Command Object is used to perform this operation and fill a datset
through a data adapter.
All these happen through the .Net application. Before step 4, a
connection is successfully established and the status says 'Open'.

Can you get some clues from the above and suggest me a solution?

Regards,
Shilpa

Erland Sommarskog wrote:
Shilpa (sh*************@unisys.com) writes:
I am using SQL Server 2000. So, it does not hvae a management studio.
Could you please explain now?


It would help if you had explained exactly in which context you get this
error.

As long as I don't, I will have to assume that you are running a .Net
application that uses SqlClient to connect to SQL 2000. And then as I said
in my previous post, the network connection drops or SQL Server is restared
and you get this error.

That's all I can say with the information you have to provided so far.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Apr 6 '06 #5
Shilpa (sh*************@unisys.com) writes:
I am using a .Net application

Here are the sequence of actions
1) Drop all connections to a database by using the ALTER DATABASE
command
2) Drop the database
3) Recreate the database and populate it with some data
4) Select a value from a table using a where condition (no joins).
Command Object is used to perform this operation and fill a datset
through a data adapter.
All these happen through the .Net application. Before step 4, a
connection is successfully established and the status says 'Open'.

Can you get some clues from the above and suggest me a solution?


And after step 4, you get the transport-level error?

I guess the problem is the connection pool. Recall that when you close
a connection from your .Net app, the connection to SQL Server is not
really closed. Instead ADO .Net lingers to it, for another 60 seconds,
and if the applicaiton opens a new connection during this time, it will
reuse the connection.

When you issue ALTER DATABASE WITH ROLLBACK IMMEDIATE, SQL Server will
terminate these connections. However, this is not something that ADO .Net
can detect. So it gives you a connection which it thinks is good, but
which isn't.

There are a couple of ways to approach this. One is to configure the
connection pool, so that all connections are dropped when you drop the
database. Another is to change the connection string, each time you
drop the database, as different connection strings gives different pools.

I would suggest that the best way, though, is simply to set up an exception
handler, so that you simply trap this error, and then try to reconnect.

For the fine details on how to implement any of the above, I would suggest
that microsoft.public.dotnet.framework.adonet is a better venue, as the
issue involved here is more one with SqlClient rather than SQL Server.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Apr 6 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: José Joye | last post by:
Hello, I'm currently reading the MS Developing Web applications with c# (and VB.net). In the chapter related to Error management, there is a sample about "Page-Level Error Pages" eg: In my...
4
by: David Lozzi | last post by:
Howdy, I found a nice little book called ASP.NET 2.0 Cookbook by Michael A Kittel and Geoffrey LeBlond. Anyway, they have some instructions on how to setup application level error handling. Most...
0
by: luresh | last post by:
Hi EveryBody : i am using following code ,it is working fine most of the time but some time "Unable to read data from the transport connection: The connection was closed" error occured in the...
0
by: palmem | last post by:
I am trying to write a simple FTP server in order to learn about sockets This is my first time trying sockets This code should take a connection on port 8110, dump it to a client "thread" (not...
0
by: umeshpotdar | last post by:
i am doing mirroring on the data base i have done every step but i got problem below "Database Mirroring Transport is disabled in the endpoint configuration." this problem occured when i...
4
by: holdingbe | last post by:
ORA-00604 error occured at recursive sql level ORA-12705 cannot access NLS data files or invalid environment specfied.... i got this error when i connect in application error.. my machine is...
1
by: Mohananababub | last post by:
Hi I am getting the below error when i am connection to SQLServer2000 DB through Windows Service in C#.net 2005 A transport-level error has occurred when sending the request to the server. ...
9
by: Yashgt | last post by:
I am facing a wierd problem with SQL Server standard edition SP2. I have a statement like SELECT A,B,C, ...., dbo.TEST_GETATTENDEEDETAILS(CI.SI_ID) AS SI_ATTENDEENAME, X,Y,Z from ..... The...
10
by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:
Hi all, I had a program and it always works fine and suddenly it gives me the following message when a pass a xml file to our server program: error code: -1072896680 reason: XML document must...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.