Skip to Content
author's profile photo
Former Member

Can't remove database connection

I have a report that was associated with a DataSource that moved servers. I can go in and Set Datasource Location and it adds it to the report... but the old datasource is still attached to the report and I can't delete it AND when I go to preview the report... it's grabbing the old Datasource instead of the new one.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Oct 16, 2007 at 12:00 AM

    I'm assuming you mean that in the report designer, you selected Set Database Location and pointed the report to the new database location. After saving the report with the changes, at runtime, the report is still looking for the the original datasource?

    If you have multiple tables, and/or subreports in your report, make sure you do a Set Database Location for them as well, just to make sure all datasources in the report have changed.

    Also, check your code to ensure that you are not inadvertently specifying the old database credentials.

    -MJ

    Add comment
    10|10000 characters needed characters exceeded