Page 1 of 1
SqlDataReader
Posted: Mon Dec 03, 2012 4:21 pm
by omayer
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
Re: SqlDataReader
Posted: Mon Dec 03, 2012 5:10 pm
by Support Team
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)