 Theme
|
|
|
|
 Search
|
|
|
|
 Poll Booth |
| Do you prefer Portals over Regular Web Pages?
|
|
 2eZ ASP Portal |
|
|
|
|
| Schools
in Sarasota County |
|
|
|
| K-12
Public Schools | PK-12 Private Schools | Sarasota Colleges |
Florida Colleges and Universities | Sarasota Schools |
|
<![CDATA[
<B>What does "Operation must use an updateable query" mean?, and how do I fix it?</b>
<BR><BR>
This error is typically encountered when your ASP script attempts to perform an UPDATE or some other action
that alters the information in the database. This error occurs because ADO is unable to write to the
database for one of the following reasons:
<BR><BR>
The most common reason is that the Internet Guest account (IUSR_MACHINE) does not have Write permissions
on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties
for this file so that the Internet Guest account has the correct permissions.
NOTE: When using Microsoft Access databases with ADO, it is also necessary to give the
Internet Guest account Write permissions on the directory containing the .mdb file.
This is because Jet creates an .ldb file to handle database locking.
<BR><BR>
If you get this error and your site is hosted by someone else like an ISP ask them to set the permissions or
you can fix it yourself in some situations. First try to find a CGI-BIN directory and place the dbase folder in their.
ISP's normally give the CGI-BIN folder read/write access rights and you can use these so that
your database is able to write.
<BR><BR><BR>
So how do you setup your ADO conenction string to work in the CGI-BIN folder?<BR><BR>
<BR>
Open settings/setting.asp and admin/inc.asp and change <br>
dnsname= "Data Source=" & Server.Mappath("dbase/portal.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"
<BR>
to
<BR>
dnsname= "Data Source=" & Server.Mappath("/cgi-bin/dbase/portal.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"
<BR><BR><BR>
<B>I get a server.execute not supported when running ASP Portal?</b>
<BR><BR>
You version of IIS is less than version 5. The latest version of ASP Portal was rewritten to work on IIS 5.
<BR><BR>
<BR>
<b>Disallowed Parent Path</b>
<BR><BR>
If you run your own server do the following or ask your host to.<BR><BR>
<ul>
<li>Open the Internet Services Manager in the Microsoft Management Console (MMC).
<li>Right-click on your Default Web Site and select Properties.
<li>Click the Home Directory tab.
<li>Click the Configuration button.
<li>Click the App Options tab.
<li>Click to select the Enable Parent Paths checkbox.
<li>Click the OK button until you return to the MMC.
<BR><BR>
If your host wont do so the you need to edit all your ASP files. The easiest way to do this is to:-
<BR><BR>
<li>Download and install notetab from notetab.com.
<li>Right click on the start button and select Search.
<li>Search for all *.asp files in the portal directory.
<li>Select all the fies and drag them onto your Notetab desktop icon. (This will open all the asp files)
<li>In Noteab, select Search and select Replace.
<li>Change Scope to All Documents.
<li>Enter include file ="../ in the Find What field.
<li>In the Replace With box Enter virtual = "/portal/ (this assumes you have put the protal into a directory called portal)
<li>Select File and Save All and the close notebab. Refresh your browser.<BR><BR>]]>
© 2008 15web.com
Private and Public Schools
|
|
|
Register Here
• Or you may log in above. • Recover Password
Quick Links
Members Online
External Links