How to update ODBC connection properties in Excel

M

MattRS

Just working on testing a migration from SQL 2000 to SQL 2008. I have an
Excel 2003 document with macros - when I open the document, I get Microsoft
SQL Server Login failed.

I'm trying to update the connection properties for the database/username,
but I can't find out where it's trying to connect. I combed through the VB
macros and I can't seem to find it anywhere.

So where can the information be modified so I can make sure it's pointing
and authenticating to the new server?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Synchronization problems while moving folders to new email 1
Converting URLs in comments to Markdown-formatted links 2
read ODBC Connection 7
ODBC Error en Organigrama en Visio. 0
Can I edit macro buttons on the quick access toolbar in excel? 0
ODBC Failure, error 18456 1
How to modify and updte specific styles for specific paragraphs across the document 0

Top