Failed to acces the SQL Server table from MS Access by ODBC Link T

[TT]

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?


Thank you very much.

[TT]

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?


Thank you very much.

[Bob Barrows [MVP]]

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"

[Bob Barrows [MVP]]

You cannot pass the username and password via the connection string used to
connect to the Jet database. You have to save the password information in
the actual link to the sql server table. See an Access newsgroup for
information about doing this if you cannot get it from online help.

Bob Barrows

TT wrote:

> ##### How to set the connection string? #####
>
> 1) I have checked the save password check box when I use odbc to link
> the SQL server tables.
>
> Error:
> Microsoft JET Database Engine error '80004005'
> ODBC--connection to '[ConnectionString]' failed.
> /index.asp, line 21
>
> 2) I have tried to add the user name and password (User
> Id=sa;Password=password) in the connection string
> ConnStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
> Server.MapPath("abc.mdb") & ";User Id=sa;Password=password"
>
> However, error returns:
> Microsoft JET Database Engine error '80040e4d'
> Cannot start your application. The workgroup information file is
> missing or opened exclusively by another user. index.asp, line 17
>
> Any idea?
> 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"

--
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"