Pls Help ! "Unspecified error" (1 Viewer)

kelvinsql

Registered User.
Local time
Yesterday, 16:48
Joined
Sep 15, 2005
Messages
22
I'm using Windows Server 2003,
making the webpages with ASP+Access(2000)

When I load some of the pages, it warns me like that:
-----------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

/andre/New0b.asp, line 9
-----------------------------------------------

and sometimes warns me:

-----------------------------------------------
UnSpecified Error

/andre/New0b.asp, line 9
-----------------------------------------------


<!--#include file="Connections/andre.asp" -->
...
Line 9: rsNew.ActiveConnection = MM_andre_STRING

In Connections/andre.asp:

<% ...
Dim MM_andre_STRING
MM_andre_STRING = "DSN=andre;"
...
%>

But It is OK when I run it in XP.

What should I do ???
 

Kodo

"The Shoe"
Local time
Yesterday, 19:48
Joined
Jan 20, 2004
Messages
707
don't use a DSN.. use a file path connection string.
now make sure that the folder that the db is in has IUSR_[machinename] modify rights (machine name is the name of your computer) so something like IUSR_KELVINSQL

make sure those rights propagate to all subfolders and files.
 

Users who are viewing this thread

Top Bottom