Ranorex Studio, Spy, Recorder, and Driver.
Posts: 458
Joined: Thu Oct 28, 2010 6:14 pm


Post by omayer » Mon Dec 03, 2012 4:21 pm

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

User avatar
Support Team
Site Admin
Site Admin
Posts: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA

Re: SqlDataReader

Post by Support Team » Mon Dec 03, 2012 5:10 pm


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.

Markus (T)