News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How to change all ODC ...

Microsoft Dynamics GP (Archived)

How to change all ODC connection for GP Excel Reports

(0) Share

Report

Report

Posted on by Clayton Ayers

115

Good Day All,

I recently upgraded a client to a test environment going from GP2013 to the latest version of GP2018. I took their current production environment (Server1) and restored it on a new virtual environment (Server2). However, upon the client testing the environment, I have recently found out that all GP Excel reports are pointing to the old server for their connection strings, instead of using the newly upgraded databases on the new server (server2). Is there a way I can mass update all connection strings to use Server2 instead of Server1?

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (1)

Richard Wheeler 75,730 on at

Like (0)

Report

RE: How to change all ODC connection for GP Excel Reports

Standard connections yes custom connections I doubt it. It would only be those that the Excel reports would use. The same would apply to the SSRS reports.
Clayton Ayers 115 on at

Like (0)

Report

RE: How to change all ODC connection for GP Excel Reports

Will that correct all default and custom odc excel report connection strings?
Verified answer

Richard Wheeler 75,730 on at

Like (0)

Report

RE: How to change all ODC connection for GP Excel Reports

Tools->Setup->System->Reporting Tools Setup and redeploy these reports using the new server name.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,253 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans