Posted to microsoft.public.excel.programming

Mark Scholes Mark Scholes is offline

external usenet poster

Posts: 16

Remote data query stopped working

Hi,
We have replaced the database server with a new machine
but with the same name. I have a lot of Excel query and
some work but some don't.
The Error message I get is
Connection failed:
SQLState:'01000'
SQL Server Error: 10061
[Microsoft][ODBS SQL Server Driver][TCP/IP Sockets]
ConnectionOpen(Connect()).
Connection failed:
SQLState:'08001'
SQL Server Error: 17
[Microsoft][ODBS SQL Server Driver][TCP/IP Sockets]SQL
Server does not exist or access denied

any sugestion.

Thanks MarkS

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ahh.. so frustrated - Web Query stopped working	Bluepenguin	Excel Discussion (Misc queries)	2	August 17th 07 02:02 PM
XL2000 stock price web query stopped working	Matthew Guerreiro	Excel Discussion (Misc queries)	13	May 30th 06 04:16 PM
Web query has stopped working...	andrewm27	Excel Discussion (Misc queries)	0	April 20th 06 05:28 AM
query wizard has stopped working how do i rectify this	Marie LND	Excel Worksheet Functions	0	February 18th 05 11:31 AM
remote data query and sum not working	Sara	Excel Worksheet Functions	0	November 4th 04 02:17 AM

All times are GMT +1. The time now is 10:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us