Constantinos
|
| Posted: 04/09/2002, 6:36 AM |
|
Hello,
CC must be a great product.... but still after many days that I have download the trial version 2.0, cant get any site to run properly.
I get always the same output (ex:for the portal):
###############################
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
Please try the following:
Click the Refresh button, or try again later.
Open the localhost home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\portal\data\Portal_MSAccess.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/portal/Common.asp, line 25
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; AUTOSIGN W2000 WNT VER03)
Page:
GET /portal/Default.asp
################################
-I did looked at Code Charge 2.0 help, YesSoftware CodeCharge.htm, .pdf help and all the threads in this community and followed the instructions.
-I did looked at Microsoft support for the Microsoft JET Database Engine (0x80004005)error types.
- Publishing properties are: [Location]Local/network, [output code path]C:\inetpub\wwwroot\portal\, [output file format]Windows, [live site url]http://localhost/portal
- The connection string is:
[type-Custom]Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Inetpub\wwwroot\portal\data\Portal_MSAccess.mdb;Mode=ReadWrite;Persist Security Info=False
[login]Admin, [advanced]ReadWrite
- I have test it with "Create Automatically(MS Access only)", useHTML Encoding(checked), copy the database(unchecked), MS Access version:2000, Local database path:C:\Inetpub\wwwroot\portal\data\Portal_MSAccess.mdb, Join style:ANSI SQL
- I tried the DSN connection
- I have set (with IIS) all the proper folders to read, write and execute (such as the site folders, the data folders and Temp folders too)
- My system: WinXP (english), Office XP(Access 2002-SP1), IIS 5.1
- With other ASP pages with database connections have no problem at all!
- When I set up manually the DSN-less connection to the common.asp, it loads and loads and loads...
- I have reinstall 2 times the trial version in case somtehing went wrong.
I have try all the above cases many times...
...and get the same stupid error!
Any ideas or suggestions?
thanks in advance
Constantinos
|
|
|
 |
CodeCharge
|
| Posted: 04/09/2002, 11:33 AM |
|
Do you see this problem only when CodeCharge is opened?
For example if you close CodeCharge, does the same error still appear?
Generally I see two potential issues:
1. Database file permissions/security. Please right-click on your database file (.mdb), click on Security tab, and allow user "IUSR_" to Write to it (plus Read and Execute). If you cannot find such user, just use user "Everyone".
2. When the page is loading for a very long time, it often indiciates a problem with your computer or IIS server.
You may try running your pages on another computer and see if your pages work there. There are some hosts who provide free ASP hosting for developers, like www.brinkster.com
If you have further questions, please contact our support to see if they can research this furher for you. http://support.codecharge.com
Regards,
Adam
|
|
|
|
dean
|
| Posted: 04/09/2002, 2:33 PM |
|
I was getting the same error you have described.
The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\portal\data\Portal_MSAccess.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/portal/Common.asp, line 25
What I found out is that when you have Code Charge open it has that mdb file opened as well and then when you try to access you web page you get that error. Close Code Charge first and then try. That let everything work ok for me.
|
|
|
|
Nicole
|
| Posted: 04/10/2002, 1:11 AM |
|
Constantinos,
are you using Access97? I've encountered the same problem with Access97, and there's no one with Access2000
|
|
|
|
Stefan
|
| Posted: 04/10/2002, 2:02 AM |
|
I think you need to let IUSR_xxxx get permissions on the whole directory where the database resides. Else you it will not get permissions to the .LDB file that is created as soon as anybody connects to the database.
|
|
|
|
scott
|
| Posted: 04/10/2002, 1:59 PM |
|
With IIS, sometimes you have to enable "websharing" on a database to get it to be able to be accessed. Share it to the IUSR_XXXXXX (or whatever you webserver runs as) and it should work.
|
|
|
|
Constantinos
|
| Posted: 04/22/2002, 6:13 AM |
|
Ok,
thanks a lot for all the replies...
The problem was that in WINXP there is a certain way to setup a web shared temp file for IUSR_servername in IIS 5.x
After setting up the temp file, everything went ok...
|
|
|
|
lily
|
| Posted: 04/23/2002, 6:30 PM |
|
Hi,
can you tell me how you solved the problem?i have this problem too!!!i don't understand what you all are saying.but you tell me the specify steps on how to get it done and what is the problem...pls help me i'm struck for many weeks!!!
|
|
|
|
Nicole
|
| Posted: 04/24/2002, 2:22 AM |
|
Lily,
refer to CC FAQs article:
http://support.codecharge.com/files/CodeChargeFAQ.html#_Toc517263838
If you won't be able to handle with problem you'll find there link to more detailed Microsoft article.
|
|
|
|
|
