|
| |
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
 |
database resuts error - 8/31/2008 19:15:48
This should be a simple one, but so far, not to me.
-Set the PC up as its own web server with IIS services and FP extensions so we can do some testing without connecting to a distant server. That works fine, made a one page web, I script in ASP, (like date and time) and it returns the expected results.
-Made up an .mbd, with two tables. Put this on the C drive. Made a DSN to this file, called it "property". All went OK.
-Checked the DSN with excel, (MSQuery). Both tables clearly visible and opened right up and returned data. All OK.
-On my web page I called for a DRW. I created a new connection, and it found it all right and all tables, and columns showed up as expected. Did a verify and got the big green check mark. global asa and the fpdb forder appeared and look good. set up the page for a simple dump out of one of the tables.
-I go back to the browser to open the page, and instead of data, I get:
Database Results Error
[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.
I can assure you that it is NOT open and I am the only one on the PC. I also tried a very simple ADO connection, going directly to the file (DSN-less) and it hung up on opening the file. The actual .mdb opens and closes in MSAccess just fine as well.
Ideas anyone?
|
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: database resuts error - 9/1/2008 2:54:21
quote:
ORIGINAL: pd_it_guy
-Set the PC up as its own web server with IIS services
Make sure you have granted the correct permissions to the IUSR_XXXXX account.
Also, ensure the folder, that the .mdb resides in, has WRITE permissions.
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/1/2008 11:00:06
Thanks for getting back. That's the only thing it could be.
I will check both those areas, adjust as necessary, and report back.
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/1/2008 14:17:01
This is turning out to be no small task.
The folder the mdb is in, is c:\data_sources. It is setup to be a system dsn. MSQUERY works it just fine.
Regarding the permissions of that folder,
under the SHARING tab, nothing is checked.
under the WEB SHARING tab, we are sharing on the default web site
SHARE THIS FOLDER is checked
the alias of who we are sharing it with is: IUSR_SYSTEM-4RR40L5W
the read only box for the folder is unchecked.
Under IIS Administration, IUSR_SYSTEM-4RR40L5W is pretty much allowed to do everything.
Still a db error. I am still missing something here.
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/1/2008 14:33:27
And also,
Just to "simplify" things, and get the whole business of the DSN out of the equation, I dragged the .mdb into the actual website. Into the fpdb folder. Made an entire new database connection, which came up as expected.
All of that gets this:
Database Results Error
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7f4 Thread 0xa80 DBC 0x138e554 Jet'.
Each time the page is cycled the process as referenced in the error msg changes slightly, but no data.
| |
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: database resuts error - 9/2/2008 10:05:12
Can you post print-screen image of :
a) the browser showing the URL and the error msg
b) the FP folder view showing the drw page as well as the global.asa
Also, the connectionstring portion of the global.asa.
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: database resuts error - 9/2/2008 10:15:54
<$.02>
Double check for any .ldb files in the fpdb folder. Delete them if they are. Hope it helps.
</$.02>
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/2/2008 11:19:07
OK here goes:
To William Lee:
a.. Will do
b.. Will also do
c.. And will do that as well.
To rdouglass:
There were no .ldb files in the fpdb folder. In fact until I tried moving the .mdb there for testing, there was nothing in it.
Thanks
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/3/2008 1:07:01
OK let me try to provide what was asked for.
On the display page:
the URL is http://localhost/
the page display:
My data:
My asp time is: 9:49:32 PM
ID primary_key prop_exh_number (note we are calling for table results, and these are column headings)
Database Results Error
[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.
the time was just to check if active server is working right, which it is.
As to the file stack: cant get a print screen to work, but here are the folders/ files
http://localhost
_private
images
fpdb
global.asa
default.htm
default.htm is the only file in it.
as to global.asa's connction string:
Application("property_ConnectionString") = "DSN=property;DRIVER={Microsoft Access Driver (*.mdb)}"
Application("property_ConnectionTimeout") = 15
Application("property_CommandTimeout") = 30
Application("property_CursorLocation") = 3
Application("property_RuntimeUserName") = ""
Application("property_RuntimePassword") = ""
Anything else let me know. This was the 3rd reinstall of the IIS and many data connction builds later. All the same result. DSN works perfectly when accessed by Excel in MSQuery.
| |
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: database resuts error - 9/3/2008 3:12:59
quote:
ORIGINAL: pd_it_guy
http://localhost
_private
images
fpdb
global.asa
default.htm
default.htm is the only file in it.
Is there no file with .asp extensions?
If the DRW code is on default.htm, rename it to default.asp.
< Message edited by William Lee -- 9/3/2008 3:23:53 >
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/3/2008 9:38:43
Sorry gents, my bad, that was a typo.
The one and only page in the web is actually named default.asp as would be expected. there are no .htm pages there at all.
And asp is running, as I have buried an <%=time%> at the top of the page to make sure it can read and process script, which it apparently can as it returned the time. it just can't process the DSN and database to produce results.
And after my post last night, I created yet another web below http://localhost, and outfitted it with a drw. Just to make sure the root web was not the problem. While it too processed server script just fine, and created a new database connection, it got the same access error that the localhost web did.
My next effort is to make a form, and let it make the access db and connection. I want to see if it just doesn't like other people's data.
past that I will await any new ideas or instructions.
| |
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: database resuts error - 9/3/2008 11:48:28
quote:
ORIGINAL: pd_it_guy
My next effort is to make a form, and let it make the access db and connection. I want to see if it just doesn't like other people's data.
past that I will await any new ideas or instructions.
Try this to see if error is IUSR related. Tip taken from MS support website.
<Tip>
A quick way of ensuring any particular error is a permissions issue is to add the IUSR_<machinename> account to the Administrators group. If this fixes the error, then it is a matter of ensuring that the user account being used has sufficient permissions. Ensure that you remove the IUSR_<machinename> account from the Administrators group when finished testing.
</Tip>
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/3/2008 12:15:06
I will add IUSR_Machine_name and report back.
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/3/2008 21:00:20
I just tried creating a new user called IUSR_SYSTEM-(local machine name) and gave him (her??) complete administrator's privileges. Then I tried running the page. No change.
Does the global.asa look OK? Is there anything in the fp includes that is worth looking at. None of them appeared to be particularly focused on the database file itself, more on procedural matters.
I will make a form and see if it will be happy making its own data, and report back.
| |
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: database resuts error - 9/3/2008 21:18:54
Try copy the fpnwind.mdb into the fpdb, create DSN-less connection and pull some records with full DRW without diet.
go ahead and report how the FP Form, with send to database, fare.
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: database resuts error - 9/3/2008 21:29:32
quote:
ORIGINAL: pd_it_guy
I just tried creating a new user called IUSR_SYSTEM-(local machine name) and gave him (her??) complete administrator's privileges. Then I tried running the page. No change.
Does the global.asa look OK? Is there anything in the fp includes that is worth looking at. None of them appeared to be particularly focused on the database file itself, more on procedural matters.
I will make a form and see if it will be happy making its own data, and report back.
Is IUSR_SYSTEM-4RR40L5W part of the Administrator group?
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/4/2008 10:27:34
Yes, that IUSR_SYSTEM-4RR4.... number was made part of the administrators group.
I will go ahead and have the site make its own db from a form and see what happens.
| |
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: database resuts error - 9/4/2008 10:42:29
quote:
ORIGINAL: pd_it_guy
Yes, that IUSR_SYSTEM-4RR4.... number was made part of the administrators group.
That leaves us with either the folder or the mdb file causing this error.
Do you have Compact on Close turned on for the mdb file.? Turn it off and try.
Try it also again in the fpdb folder with DSN-less conn.
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/4/2008 11:21:46
This is truly a mystery.
I did not see Compact on Close as a setting. Unless it is a default, it would not be set.
I made a simple form, and let FP and the wiz make its own db file, and put it anywhere it wanted. This would be a DSN-less connection as the file was right there. That, it did. Then I made a results page to dump it out. Again, all good, everything worked normally. And then, I opened the form in the browser, and dropped in about 20 records. In each case I got the confirmation page, exactly as expected, returned to the form and repeated the process.
So then, I went to the results page, and got this:
ID the_date the_time Remote_computer_name User_name Browser_type Timestamp
Database Results Error
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xff4 Thread 0xd64 DBC 0x133c254 Jet'.
What is a registry key????? The header row was fine, but the error was basically the same one that I had gotten when I put the first file right in the db.
Then, I went to the db itself and opened it in Access, and while the structure was right, NONE of my form postings made it there. Why that did not return an error message who knows.
Am I trying to do something that can't be done, have a PC act as its own server?
| |
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: database resuts error - 9/4/2008 12:08:37
I found the following info on MS support, decide to post the content here instead of posting the link for easy search on this forum.
SYMPTOMS
When you attempt to browse to an Active Server Page (ASP) database results page created with Microsoft FrontPage, you may receive an error message similar to one of the following:
Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x3f8 Thread 0x764 DBC 0x2150064 Jet'.
-or-
Database Results Error
[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.
CAUSE
This behavior can occur if incorrect NTFS permissions are defined for your system %TEMP% folder.
RESOLUTION
To resolve this problem, correct the permissions to the folder specified in your system's %TEMP% variable.
Note The Microsoft Jet database engine uses the System %TEMP% environment variable to specify the location to place temporary files that are created during Jet operations. On Microsoft Windows NT 4.0 these environment variables are defined for users and are not system-wide settings by default.
To correct the permissions of your systems %TEMP% variable, follow these steps:
1. Locate your system's TEMP folder:
a. Follow the appropriate steps for your version of Windows:
• For Windows XP: On the Start menu, click Control Panel, click the Performance and Maintenance icon, click the System icon, click the Advanced tab, and then click the Environment Variables button.
• For Windows 2000: right-click My Computer on your desktop, click Properties on the menu that appears, click the Advanced tab, and then click the Environment Variables button.
• For Windows NT: right-click My Computer on your desktop, click Properties on the menu that appears, and then click the Environment tab.
b. Find the TEMP variable in the list of System variables and note the folder that your system is using.
Note An easier way to perform this task is to click Start , click Run, type %temp%, and then press Enter.
2. Start Windows Explorer.
3. In Folders view, expand the path to your temporary folder.
4. Right-click the folder and click Properties on the shortcut menu.
5. On the Security tab, add Everyone to the existing permissions, assign it Change permissions, and apply these new settings to all files and subfolders.
6. Click OK.
Hope this helps,
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/4/2008 20:06:03
Those are exactly the error messages I was getting. Give me a bit to make those changes to the TEMP folder (I am not where the PC is right now) and I will report back.
This just has to be it. We have eliminated all other possibilities.
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/6/2008 16:44:24
When I ran %temp% I found there is a temp folder, all right, in the Documents and Settings under my username, and it's under Local Settings\Temp. It has all sorts of remnants and even a wecerr file, all generated from the web that I have been working on. So, it looks like this must be the right place. Problem is, if you right click on the folder, or any of its subfolders, and you do not get a a security option or tab per se. It is actually Security and Sharing. Now, if you go there you can SHARE the file or give it an alias, but it is definitely not the place where you can assign permissions. I know exactly what that is and it is not here.
Sharing and Security has 4 tabs, ..;, sharing , web sharing and customize. I dont think we want to share this file so much as allow IUSR or IWAN to write to it, do we??
And there is no Performance and Maintenance icon in the control panel.
This is XP PRO SP3.
I will continue to work at this; anyone, if you see what I am missing and clearly not doing right please jump in.
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/6/2008 18:24:15
TA DAAAAAHHH!!!!!!
Alluva sudden it just started.
DAY LATER POSTSCRIPT TO ALL THIS:
Win XP SP 3 does not set permissions as described. The changes I made, that finally worked, were made in the Control Panel under Computer Maintenance. SP3 is different. It is apparently a lot more convoluted about how it allows you to set permissions for individual folders (its all about security and sharing) and it is still not clear what they mean about aliasing. However, since this operation would, under all normal circumstances, be done on a Windows Server O/S and not to a PC, were we there, it probably would be exactly as described.
And then I thought, I had better see if Mr. IUSR could write and update as well. Once again, I was blocked. Checked and rechecked global asa and the includes, nothing looked out of the ordinary. Permissions were set as loose as possible. Finally, I tried a straight ADO connection (as the pro's have been saying all along) and I deleted global.asa, and the includes completly. That I must say worked perfectly and returned records significantly faster.
< Message edited by pd_it_guy -- 9/7/2008 13:19:21 >
| |
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: database resuts error - 9/11/2008 3:49:10
quote:
ORIGINAL: pd_it_guy
When I ran %temp% I found there is a temp folder, all right, in the Documents and Settings under my username, and it's under Local Settings\Temp. It has all sorts of remnants and even a wecerr file, all generated from the web that I have been working on. So, it looks like this must be the right place. Problem is, if you right click on the folder, or any of its subfolders, and you do not get a a security option or tab per se. It is actually Security and Sharing. Now, if you go there you can SHARE the file or give it an alias, but it is definitely not the place where you can assign permissions. I know exactly what that is and it is not here.
I guess the Microsoft instructions are meant for NTFS whereas your system is more consistent with FAT32.
quote:
And there is no Performance and Maintenance icon in the control panel.
This is XP PRO SP3.
There is. If you switch your Control Panel to Category view.
quote:
I will continue to work at this; anyone, if you see what I am missing and clearly not doing right please jump in.
My pleasure.
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/11/2008 10:57:03
Good point- category view does have the performance and maintenance choice. I believe that my alternate route of Windows classic still got me to the right place, Computer Management, since that is where users get assigned to groups. Once there, there was no problem making IUSR and IWAM members of the administrator's group. Not a great way to manage security, but it worked.
SP3 certainly seems different. Its folder secuity and rights settings verbiage is all around shares and aliases, and really not so much about users and groups. SP2 and previous had a specific tab marked "security" where you could assign rights to various user groups in the manner described. There is no doubt that it can be done on a folder by folder basis, since NTFS is the basis of this, but what is unclear is precisely HOW.
It appears that setting and managing permissions is a recurring thread. I am hoping a SP3 user will right click and provide the rest of us at least a good start as to what should go in what tab.
*** PS- I just removed SP3 and now as far as I can tell it's straight XP Pro. I still get that "sharing and security" option on the folder right click I had before, so maybe it's not SP3 after all that is causing this. Possibly an earlier security patch. So SP3 is going back in. Any other SP3 users with the same security option I see?
***PPS- SP3 was reinstalled and now, NOTHING works anymore. We are right back to where we started at the beginning of the post
*** PPPS after an hour or so we are now back in business. Looks like not only do both the DB and Temp files need to be adjusted so as to be written to (as others have said) but some settings need to be made in the IIS section of the Control Panel to allow scripts to be run. The Temp folder and the DB folder appear there as virtual folders. Without script execution on the root web set the query will error out. This I think SP3 did this to me on the reinstall. Will try to document all this.
< Message edited by pd_it_guy -- 9/11/2008 16:22:44 >
| |
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: database resuts error - 9/12/2008 23:42:50
Regarding the Security tab of a folder properties on right-click, you can get to that by logging in as Administrator in Safe Mode. It is the same as you would see it on a Win2000/2003 server.
Or, in Windows Explorer, go to Tools>Folder Options>View and deselect the Simple File Sharing.
This helps any?
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
|
|
pd_it_guy
Posts: 215
Joined: 3/4/2008
Status: offline
|
RE: database resuts error - 9/13/2008 11:06:02
WL
Thanks for checking in once again, and you are absolutely correct about simple file sharing. I stumbled onto that one yesterday.
But also, you have several settings to check and change in Control Panel's Local Security, and also in CP's Internet Information Services because we of course use web pages that both routinely process scripts, and write to files. And then, whenever anything changes the FP extensions have to be recalculated or FP won't open. And even though the IUSR and IWAM are theoretically part of "Everyone" they default to being part of the Guest group, (which I had turned off by default). I am still not real comfortable with how those need to be grouped or set up. Making it more complicated, IIS sets up three additional user groups (browser, author, administrator) in addition to all others, that IUSR and IWAM had to go into.
And even that was not enough to make it work. Although the %temp% command pointed to MY temp file, I had to open up the temp folders in the default user and in Windows as well. I have no idea why all of this was required but it simply would not work without it.
Fortunately, all of this only happens if you want your local machine to be a development platform.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
