I have some extra data sources / data connections in my report because I was trying to figure out something. They all point to the same MS SQL database server, but use different "drivers" (ODBC, OLE DB, ...). I was not forward thinking enough to name them appropriately, and the one I am using is one of them. I was able to delete all but 2 datasources. One of them appears to be the current datasource, and the other I'm pretty sure is extra. The problem is that the one I think is the current data source is the only one of the two that has the delete option when I right click on it. This is backwards from what I'd expect.
How can I tell which datasource my report is set to use? Why can't I delete the datasource that I think is extra?
The datasource names are "dc1" and "dc1_2". I have the option to delete dc1, but not dc1_2. As far as I can tell, the report is using dc1, but both of those datasources point to the same database server, also named dc1.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.