Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
problem with sql server 2000 DSN
Name: Saleem Rao Date: August 26, 2008 at 21:03:23 Pacific OS: win 2000 server CPU/Ram: 1 GB RAM Product: INTEL
Comment:
I am trying to connect to a SQL database on windows 2000 advance server and it returns the following error when I want to connect SQL Server through the System DSN in Control Panel - Administrative tools - ODBC:
Connection failed: SQLState: '01000' SQL Server Error: 1231 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()) Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found.
I am using win 2000 server and when i want to configure the dsn in the list box the the choice of sql server is not available. It doesn't matter which way I connect through the authentication of Windows login or authentication to the SQL Server using login and password with ID's we have in the SQL Server. PLEASE HELP!!!!!
Name: Fist (by fmwap) Date: August 29, 2008 at 20:54:15 Pacific
Reply:
I had similar problems on a Windows 2000 box w/ SQL2000. As it turned out, the machine would never connect when using the hostname, it would only work when using the IP address.
Just a suggestion, I pulled my hair out trying to figure it out & I've only ever seen it on that one box.
Even 'localhost' wouldn't connect to the local SQL---whatever, windows sucks.
0
Response Number 2
Name: Saleem Rao Date: August 30, 2008 at 00:54:09 Pacific
Reply:
hi dear Fist
what do u mean by giving the ip address , because the machine is not running on any network ,please elloborate ur solution
Summary: Greetings Maina, I am not a very experienced programmer but I would like to try to help in some way. If you have SQL Server 2008 and Visual Studio 2008 installed, then you should be able in a code-beh...
Summary: Hello, I am Software Development Intern at a small company. We run Microsoft SQL Server 2000 on Win2k. One of our database tables was recently destroyed by a rogue update statement. Now ALL our orders...
Summary: I am using windows 2000 recently the Ip of my system has been changed and now I am unable to connect to the databse server can anybody tell me that how could I reconfigure the sql server 2000 on the c...
0 
