Re: ODBC security problem
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Fri, 18 Aug 2006 13:49:05 -0600
You could be hitting an MDAC bug where the authentication
mode setting is ignored and windows authentication is always
used. Refer to:
FIX: SQL Server ODBC Driver Ignores Authentication Setting
http://support.microsoft.com/?id=279526
You can use component checker to verify the version and MDAC
installation on any of the clients. You can download
component checker and MDAC versions from this site:
http://msdn.microsoft.com/data/ref/mdac/downloads/
-Sue
On Fri, 18 Aug 2006 11:27:01 -0700, Negri
<Negri@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi, I've a Access 2003 program with linked tables to a sqlexpress configured
with mixed mode security.
From clients XP no problem.source, because try to conect with Windows Authentication Mode security, but
From clients 2000 MSACCESS don't get the right configuration from ODBC
the source is configurated with mixed mode. If I refresh the linked tables
and change the password, works fine, but when I close MSACCESS and open
again, fail.
Anybody knows where's the bug? In ODBC driver? MSACCESS?
.
- Prev by Date: Re: Sybase Connection String
- Next by Date: Re: Help with dtsrun and dts package.
- Previous by thread: MS SQL 2005 to Sybase via Linked server
- Next by thread: Encounter Error when FTP get file using tsql
- Index(es):
Relevant Pages
|
