RE: SQL server Login connection failed sqlstate 28000 sql server e

From: Michael Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 06:52:09 GMT

Hi,

Thanks for your detailed information!

Now, I understood that any modifications to the existing mdb file will lead
to the error when you try to save these modifications. However, it remains
fine when nothing changed. Have I understood correctly this time?

It seems you are not able to passing user name and it's passowrd via DSN.
If modifies the mdb file in another box, will it reproduce this sceanrio?
Anyway, I am looking into this issue and will update you as soon as
possible when I find something useful.

BTW, here is a workaround using ODBC connections without DSN. I have
noticed that there must be much modifications in this way, so it's just for
your reference:)

How To Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875

ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafast/ShowArticle.aspx?File=Articles/odbctu
tor01.htm

Using DSN-Less Connections
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html

BTW2, is it possible for you to share the CASE ID with me? I guess I might
find more information from the case study.

Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Get Secure! - http://www.microsoft.com/security

This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!