Re: Creating an ODBC new DSN fails

From: David G. (david_nospam_at_nospam.com)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 12:38:34 -0400

Colin Bate wrote:
> I am not able to create a new DSN to a SQL MSDE 2000 SQL server, I
> get the message:-
> Connection failed
> SQLState '01000'
> SQL server error 11001
> [Microsoft][ODBC SQL Server driver]TCP/IP sockets]ConnectionOpen()).
> 'Connection failed'
> SQLState '08001'
> SQL Server error: 6
> [Microsoft][ODBC SQL Server driver]TCP/IP sockets]SQL Server not
> found.
>
> I have two PC's both giving this error and both have existing System
> DSN's that work fine, I just can't add a new one with out getting hte
> above error when selecting the Next button on the second pageof the
> wizard. Interestingly I deleted the existing DSN which was working
> and I can't create a new one to this database. The database is on
> 'local' and I'm using Windows NY Authentication and all parameters at
> the default value.
> One PC is an XP SP2 box the other a Win2K server with SP4.
>
> Any ideas what the hell has gone wrong?
> Many thanks, Colin

Well, if the database is local, it's not local to one of those PCs. Try
loggin in as "sa" because it's possible that our Windows User Name does
not have rights to connect to the server. Also try using the real
workstation name instead of local. If you use local use "(local)"
without the quotes. 

-- 
David Gugick
Imceda Software
www.imceda.com