SqlDataReader
SqlDataReader
How to query from 2 different database using SqlDataReader, kept getting connection already open error since both database using same connection. Thank you in Advance
Tipu
- Support Team
- Site Admin
- Posts: 12145
- Joined: Fri Jul 07, 2006 4:30 pm
- Location: Houston, Texas, USA
- Contact:
Re: SqlDataReader
Hello,
Could you please describe more detailed what you want to do?
Are you using a 'SQL connector' or a code module to connect to your database?
If you are using a code module could you please post a code snippet of your connection handling?
Please make sure that you close your connection after usage.
I have created a solution and used 2 'SQL connectors' to connect to 2 different databases on my SQL Server.
In my solution, I created 2 Test Cases, each of them uses a separate SQL connector/database.
I didn't get an error when executing both Tests.
Regards,
Markus (T)
Could you please describe more detailed what you want to do?
Are you using a 'SQL connector' or a code module to connect to your database?
If you are using a code module could you please post a code snippet of your connection handling?
Please make sure that you close your connection after usage.
I have created a solution and used 2 'SQL connectors' to connect to 2 different databases on my SQL Server.
In my solution, I created 2 Test Cases, each of them uses a separate SQL connector/database.
I didn't get an error when executing both Tests.
Regards,
Markus (T)