Skip to Content

Why can't I delete a datasource/data connection?

May 10, 2017 at 06:44 PM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Philip Qumsieh May 11, 2017 at 12:01 AM

Just delete dc1, then rename dc1_2 appropriately.

You can then reset your report to that data source...

Show 1 Share
10 |10000 characters needed characters left characters exceeded

It turns out that the report was using dc1_2 and that's why I could not delete it.