troubleshooting Question

Cannot edit query link to sql sever

Avatar of oldbridge
oldbridge asked on
Microsoft SQL ServerMicrosoft ApplicationsMicrosoft Excel
10 Comments3 Solutions723 ViewsLast Modified:
I had setup several complex link in excel 2003 to MS-SQL 2003. The link were setup using ODBC DSN.

The company decided to upgrade and move SQL server to SQL 2008 with new SQL server name.

I change ODBC DSN to link to the new server and my financial applicaiton works fine. The problem is with Excel. It gives error that SQL server dose not exists. It seems that Excel setup is looking for old server. It will not allow me to even Edit the query to change the link to new server.
I have several years of files that needs to be updated. Is there a location where i can find the link outside of excel to oepn and change the link?


ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros