Busy Connection error... 1

[sphungtham]

When I try to use the multiple input filter to get data from 2 data sources I get a Connection is busy error. It works fine if I only have one data source, but this defeats the purpose of using the multiple input filter.

Can anyone help me?

 

[bcaslow]

Are you using SQL Server? Oracle? Can you describe where you have your connection object? You may need to have two connection objects: one for each query source.



Bill

 

[sphungtham]

I'm using SQL Server. Yeah it worked after I used more than one connection. I wanted to avoid this since it decreases performance by a significant amount.

Thanks for the reply.

 

[bcaslow]

With Oracle you can usually get away with one connection, but with SQL Server, as you have found out, there often is a problem with more than one query source per connection.

Glad you found your solution.


Bill