RE: DNS required ?

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 16:54:34 GMT

What version of the SQL Server ODBC driver (sqlsrv32.dll) is installed on
the client. There is a issue with wsome of the earlier MDAC 2.6 SQL Server
ODBC drivers. If your driver version is 2000.8.0.194 you may be running
into this problem. It also occurs on some later versions as well. If you
install one of the more recent versions of MDAC, such as MDAC 2.7 then the
problem I am describing will not occur. Of course this assumes that you are
using the version of MDAC that has the problem.

When you ping the ip address does the response come back quickly or dies it
take some time?

Rand
This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • Re: Any help here???
    ... > start looking for things that are non standard (like having MDAC installed). ... > Format your drive, do a new/clean install of XP, and go from there. ... >>> data provider is optimized for SQL Server. ... >>> I've never had any SQL Server connectivity problems since I've switch to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Help Please Wit Error
    ... Occasionally I receive the error you are mentioning when the SQL Server ... I have had to completely remove the MDAC and re-install it as well ... see an example of the connection string you are using. ... Please install Microsoft Data Access Components ...
    (microsoft.public.dotnet.csharp.general)
  • Re: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Any help here???
    ... If you are having odd connectivity issues then ... AFAIK you cannot uninstall MDAC once its installed. ... Format your drive, do a new/clean install of XP, and go from there. ... > troubleshoot SQL Server connectivity issues - you should investigate the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Using vfoledb with webservices?
    ... later MDAC package and install that. ... MDAC 2.7 or 2.8 doesn't install specific OLE or ODBC drivers for any ... particular database engines except Oracle and SQL Server. ...
    (microsoft.public.fox.programmer.exchange)