Windows 2003 Server ODBC Error -Not a valid password - connecting to MS Access DB

[Eduard]

We are currently busy moving our website from a NT4 Server to a
Windows 2003 Server. One of the site are making use of an MS access
DB. A DSN was setup for the website. The MS Access DB is only secured
by a password. When we try to access the page on the new Windows2003
Server we get:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Not a valid password.

I have moved the Site to a Windows 2000 Server, and have setup the DSN
the same as it was setup on the NT4 Server and Windows 2003 server,
and here it is working. I think that this error was posted on this
site before, but could not find a link to it.

Any advice would be appreciated.

Regards

Eduard

[Bob Barrows [MVP]]

Eduard wrote:

> We are currently busy moving our website from a NT4 Server to a
> Windows 2003 Server. One of the site are making use of an MS access
> DB. A DSN was setup for the website. The MS Access DB is only secured
> by a password. When we try to access the page on the new Windows2003
> Server we get:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Not a valid password.
>

Look here for the correct connection string to use to connect to a pass-word
secured Jet database (no workgroup security):
[url]www.able-consulting.com/ado_conn.htm[/url]
I suggest using the OLEDB Provider for Microsoft Jet instead of the
deprecated ODBC driver.
HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.