Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Cannot edit query link to sql sever

Avatar of oldbridge
oldbridge asked on
Microsoft SQL ServerMicrosoft ExcelMicrosoft Applications
10 Comments1 Solution723 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
Avatar of RichardSchollar
Commented:
This problem has been solved!
Unlock 1 Answer and 10 Comments.
See Answers