Microsoft JET Database Engine error '80040e69'

[MS Newsgroups]

Yesterday I wrote about an error I am getting on a ASP page using DSN people
responded with some suggestions which I have tried and now I get the
following error message : (

Microsoft JET Database Engine error '80040e69'
Could not start session.

/argusnet04/contractlist.asp, line 53

I altered my connection string to the following I did substitute user name
with a good name and have also tried it without those callings to no avail'

Please Help Thanks

------------------------------------------------------

cst = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Jet OLEDB:System Database=Y:\security\system.mdw;" & _
"Data Source=Y:\datafiles\contracts.mdb;"
Set Conn = Server.CreateObject("ADODB.Connection")
conn.open cst, "UserName", "Password"

select case SearchType

case "AR"
SearchType = "AR #"
SearchValue = Request("searchValue")
DocHeader = "Contract"
Set RS = Conn.Execute("{Call ContractList_AR('" & SearchValue & "')}")

case "Customer Name"
SearchValue = Request("name")
DocHeader = "Contract"
Set RS = Conn.Execute("{Call ContractList_Name('" & SearchValue & "')}")

end select

If RS.eof then ' There are no contracts
RS.Close
Set RS = nothing %>

[Bob Barrows [MVP]]

MS Newsgroups wrote:

> ------------------------------------------------------
>
> cst = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
> "Jet OLEDB:System Database=Y:\security\system.mdw;" & _
> "Data Source=Y:\datafiles\contracts.mdb;"
> Set Conn = Server.CreateObject("ADODB.Connection")
> conn.open cst, "UserName", "Password"
>

Do not use mapped drives in your connection strings. it is unlikely that the
IUSR_machinename account has access to those mapped drive letters.

Is Y: a local or remote drive? If it's on another machine, see this:
[url]http://www.aspfaq.com/show.asp?id=2168[/url]

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"