ODBC cannot connect to MSDE 2000a

From: Padji (gil.pajany_at_free.fr)
Date: 08/03/04

Next message: NAZEER: "How to Replicate using OSQL?"
Previous message: steve: "server agent fails"
Next in thread: Andrea Montanari: "Re: ODBC cannot connect to MSDE 2000a"
Reply: Andrea Montanari: "Re: ODBC cannot connect to MSDE 2000a"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 3 Aug 2004 11:54:21 +0200

Using MSDE 2000a (w/spk3a). XP Pro. Cannot connect w/ ODBC driver to server.
Have tried many things.
Below is the error when trying to connect via ODBC.

Help!

GIL

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist
or access denied.

Next message: NAZEER: "How to Replicate using OSQL?"
Previous message: steve: "server agent fails"
Next in thread: Andrea Montanari: "Re: ODBC cannot connect to MSDE 2000a"
Reply: Andrea Montanari: "Re: ODBC cannot connect to MSDE 2000a"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Like Operator with Unicode
... The first thing to do would be to replace the old ODBC driver ({SQL Server}) ... with something more recent; preferably the SQL Native Client ODBC Driver; ...
(microsoft.public.access.queries)
Re: Datetime overflow with DBI ODBC setting 19th century dates with placeholders
... >> the date is passed to SQL Server ODBC driver in the same way for both ... >> I've also tried the SQL Server profiler on the server side, ... > In this way, you're defining what the data type is for the database, not ...
(comp.lang.perl.misc)
Component errors after ip address change
... We have SMS 2003 running on one server connecting to SQL on a different ... SQL Server problem on this site or one or more secondary ... check the SQL Server error logs. ...
(microsoft.public.sms.admin)
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [233].
... Microsoft SQL Server Login ... connection to SQL Server. ... SQL Server Error: 0 ...
(microsoft.public.sqlserver.odbc)
Re: MS SQL Server 2000 ODBC driver crash
... I was using the latest odbc driver, ... > SQLFreeHandle crashes to free the statement handle. ... Did you apply any SQL Server service pack? ...
(microsoft.public.data.odbc)