It looks as though only one data source can be active on a DB at a particular time. Is there anyway to allow multiple connections to the same db as I would like to pre configure several queries/asset listings and not have the user have to worry about changing the sql.
You can have multiple data sources all connected to the same DB at the same time. What problems are you experiencing?
The connection is fine, the query looks as though it goes through but the asset map fails on updating and when you try and expand the node you get "could not load children: error while getting response: undefined index majoridfile.
Sounds like the query isn't correct. That's looking for something in the result. I'd log a support request so that we can take a look directly at it.
Unfortunately it cant be the query as theres an exact clone of the asset with the same query running directly above it with no problem.
I will log a job with support though so you guys can take a stickybeak.
Thanks for all your help as always Avi.
So if you already have a bridge with this query, why are you creating another one?
It wont be the same query I wanted to make sure that the query wasnt the problem as the two assets are now identical
Ah, ok. It does sound like something isn't happy on your system, so I'm glad you've logged a support request.