Posted by Shilpa on 04/06/06 06:20

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 (shilpa.nagavara@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, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: datetime diff query syntax
• Prev in forum: SQL 2005 Management Studio Bugs
• Thread view: Re: Transport Level Error has occured

[Reply to this message]