DataReader

  • Thread starter Sebastian Santacroce
  • Start date
S

Sebastian Santacroce

I'm using a datareader with SQL server database and trying
to make a connection to one store procedure with a
datareader and then a connection to another withought
closing the first and I get the errror:" there already
exists a connection to the SQl server with this data
reader. Must close and first connection to create another".

Is there a way around this?
 
C

Cor

Hi Sebastian,

I did not try this, but why not make a new datareader also?

I am not sure of this works, but my first thought is why not.

Cor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple DataReaders 6
There is already an open DataReader associated with this Connection which must be closed first 20
SQLConnection questions 5
Connection Sql 2005 Problem 2
question about datareader in function 4
SQL Server connection pooling 9
basic MS Access Question.. get a data into a dataset 3
How to use DataReader with DataGridView in Visual Basic 2005? 3

Top