Re: Failed to acces the SQL Server table from MS Access by ODBC Li

From: TT (TT_at_discussions.microsoft.com)
Date: 07/27/04 

Date: Mon, 26 Jul 2004 21:44:18 -0700

How can I provide the user name and password in the connection string?
My link table is stored in the access database, I have checked the save password check box when I set up the odbc link table.
I have tried to add "User Id=sa;Password=password" in the ConnStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("abc.mdb") & ";User Id=sa;Password=password"
It failed with error:
Microsoft JET Database Engine error '80040e4d'
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
/MonthlyTime***/index.asp, line 17

Thank you very much.

"Bob Barrows [MVP]" wrote:

> TT wrote:
> > My MS Access database use "link table" to connect the SQL Server by
> > ODBC. But I failed to access the table which link to SQL Server with
> > the following error in ASP.
> >
> > Microsoft JET Database Engine error '80004005'
> > ODBC--connection to '[ConnectionString]' failed.
> > /test.asp, line 21
> >
> >
> > My connection string in ASP is as following:
> >
> > ConnStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
> > Server.MapPath("abc.mdb") & ";"
> >
> > How can I fix the problem?
> >
> >
> You probably failed to provide a SQL Server user name and password in the
> connection string for the linked table (using NT Authentication will
> probably not work, because your asp code is running under the context of the
> IUSR_Machinename account).
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>

Loading