Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    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...

    Add comment
    10|10000 characters needed characters exceeded