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)