September 24, 2007 at 9:32 pm
When I try to update existing excel spreadsheets with links to our SQL 2000 server the connection fails. If I set up the same ODBC connections on an XP box they work. If I recreate the spreadsheets on the Vista Box they work on XP, 2000 and Vista.
This is the error I get
Connection Failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server
Driver][Mulit-Protocol]ConnectionOpen (Connect()).
Connection failed:
SQL State: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Multi-Protocol]SQL Server does not exist or access denied.
I can even recreate a worksheet in an existing spreadsheet while using vista and the new sheet will update using the same query but the existing sheets will not.
Any help appreciated.
Doug
September 25, 2007 at 9:00 am
You want to look into what protocols are enabled on the SQL server, and set up the client Network Utility for SQL to match on the new Vista machine. It sounds to me that the SQL server is not set up to talk on named pipes or TCP/IP, so the client is attempting multi-protocol (which as I recall takes advantage of IPX).
Remember - Vista has NO support for IPX, and unless they recant, isn't going to either. Make sure IP is enabled as a protocol on both the SQL server, and as the protocol to use from the client.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply