Re: ODBC in MS Access ignores DSN authorization method

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/20/04


Date: Tue, 20 Apr 2004 09:17:46 -0600

Regarding the known issue that you already have found, it's
the clients that need to be using MDAC 2.6 SP2. You may want
to check the mdac configuration on the client using
component checker. The odbc driver that causes the issue is
sqlsrv32.dll - version 2000.80.194
You can download the MDAC component checker
from:
http://msdn.microsoft.com/data/downloads/tools/default.aspx

-Sue

On Tue, 20 Apr 2004 08:06:43 -0700, Tina Robichaux
<tina@interland.com> wrote:

>I understand about the trusted connection setting - but even when I do
>not use that, it ignores the DNS username and pw on the next Access
>open, and uses my NT permissions (see last paragraph of original post).
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!



Relevant Pages

  • Re: MDAC 2.8
    ... I have run component checker several times. ... everything I've done indicates that MDAC is okay. ... MDAC Version Number Windows 98 and Windows 98 Second Edition Windows ... Installed with Windows XP SP2, ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Crash VB6 on SP2 Mdac2.8?
    ... I suspect that the version of MDAC your program is designed to use is not ... Run Component Checker ... SP2 introduces a number of interesting side-effects that might also be ... > because it runs excellent on Win98 and Win2000 computers. ...
    (microsoft.public.vb.database)
  • Re: Disconnect Issues & RPC Server Unavailable
    ... We had a similar problem after upgrading clients to XP SP2, ... turned out to be the MDAC version that ships with SP2. ... > We have recently upgraded our main server from NT4 to Active Directory ...
    (microsoft.public.sqlserver.clients)
  • Re: MDAC reinstall under Win XP Sp2
    ... I am having a similar problem with MDAC after the installation of XP ... However MDAC 2.81 XP SP2 is not listed, ... > Component Checker: Diagnose problems and reconfigure MDAC installations ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Server and client MDAC versions
    ... The clients make the connection using MDAC on their PC. ... through a web server, the connection is made through MDAC on the web ...
    (microsoft.public.sqlserver.clients)