Re: Connecting via ODBC

This is a pretty general error. It could be caused by your network, or by SQL Server settings. You didn't say how long ago it worked. Yesterday, or last year? If yesterday you may have changed something. If last year, it could be lots of things.
You didn't say what version you are using. If SQL Server 2005, check out the connectivity tutorial which was designed to help users with just this problem. http://msdn2.microsoft.com/en-us/library/ms345318.aspx
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Suttd via SQLMonster.com" <u25367@uwe> wrote in message news:7e0eab8790a4c@xxxxxx
Hi all,

Hope you can help, I am trying to link to some data tables into Access via
the ODBC connection. It worked for me before but i have had issues with my PC
and now i get this message:

[INTERSOLV][ODBC SQL Server driver]Communication link failure.[INTERSOLV]
[ODBC SQL Server driver][SQL Server]ct_connect(): directory service layer:
internal directory control layer error: Requested server name not found.

I suspect this will be a hard question to answer but I'd appreciate any input.


Cheers

Dave

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-connectivity/200801/1


.

Relevant Pages

  • ConnectionWrite(send()) errors
    ... We use ODBC to communicate with SQL server. ... 01000 means "General error", but I didn't find ... On some occasions the error codes are "0x, ...
    (microsoft.public.sqlserver.programming)
  • Re: sql server does not exist or access denied. connectionopen connect
    ... This is a very general error that indicates the client can't find the ... A mistyped SQL Server name in the connection string. ... Network Utility to configure those. ... The client name resolution has cached an old IP address. ...
    (microsoft.public.sqlserver.connect)
  • Re: FoxPro Views Causing Blocking?
    ... And review the sql server settings - I'm betting there's a sql server ... The one thing I find odd is when I do see blocking in the sql database ... know we're not setting transactions any where and originally thought ...
    (microsoft.public.fox.programmer.exchange)
  • Re: ASP SQL Server slow connection
    ... > I just migrated the database and web pages from one machine to another ... > I wonder if anything to do on IIS or SQL Server settings?? ...
    (microsoft.public.inetserver.iis.security)
  • Re: Required Steps
    ... added myself to every user group (sso admin, sso ..., admin, sql ... when deploying a bizTalk orchestration. ... the problem is with either my user setup, sql server settings or SSO ...
    (microsoft.public.biztalk.general)
Loading