MSQuery & ODBC connection

[aitai]

Hi, All

Our IP addresses recently change, and for some reason, the msquery that pulls data from our SQLServer (7.0) into spreadsheets does not work (error message: connection failure). And we have, quite literally, hundreds of these making manual intervention impractical.

The IP address for the ODBC connection used has been updated (pointing to the right server). The problem is, for some reason, MSQuery is still trying to pull from the old ODBC settings.

I would appreciate any insight on this problem. Thank you.

Ivan

 

[BrainB]

Not familiar with the IP address method. I would have thought that it would be better to have users map the server to a drive letter, then all that would be required is an email to each to remap to the new server. (??) Regards
BrianB
** Let us know if you get something that works !
================================

 

[xlbo]

Have a look at your dqy files - might be stored in there Rgds
~Geoff~