DREAMWEAVER CS3
User Guide
528
•
PRB: Error “Cannot Open File Unknown” Using Access at
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q166029
.
[Reference]80004005—Logon Failed()
This error occurs when you use Microsoft SQL Server and attempt to view a dynamic page in a web browser or in
Live Data mode.
This error is generated by SQL Server if it doesn’t accept or recognize the logon account or password being submitted
(if you’re using standard security), or if a Windows account does not map to a SQL account (if you’re using integrated
security).
Here are possible solutions:
•
If you use standard security, the account name and password might be incorrect. Try the system Admin account
and password (UID= “sa” and no password), which must be defined in the connection string line. (DSNs do not
store user names and passwords.)
•
If you use integrated security, check the Windows account calling the page and find its mapped SQL account (if any).
•
SQL Server does not allow an underscore in SQL account names. If someone manually maps the Windows
IUSR_machinename account to a SQL account of the same name, it will fail. Map any account that uses an under-
score to an account name on SQL that does not use an underscore.
[Reference]80004005—
O
peration must use an updateable query
This error occurs when an event is updating a recordset or inserting data in a recordset.
Here are possible causes and solutions:
•
The permissions set on the folder containing the database are too restrictive. IUSR privileges must be set to
read/write.
•
The permissions on the database file itself does not have full read/write privileges in effect.
•
The database might be located outside the Inetpub/wwwroot directory. Though you can view and search the data,
you might not be able to update it unless the database is located in the wwwroot directory.
•
The recordset is based on a non-updateable query. Joins are good examples of non-updateable queries within a
database. Restructure your queries so they are updateable.
For more information on this error, see “PRB: ASP ‘Error The Query Is Not Updateable’ When You Update Table
Record,” in the Microsoft Knowledge Base at
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q174640
.
[Reference]80040e07—Data type mismatch in criteria expression
This error occurs when the server tries to process a page containing an Insert Record or Update Record server
behavior, and the server behavior attempts to set the value of a Date/Time column in a Microsoft Access database to
an empty string ("").
Microsoft Access has strong data typing; it imposes a rigorous set of rules on given column values. The empty string
value in the SQL query cannot be stored in an Access Date/Time column. Currently, the only known workaround is
to avoid inserting or updating Date/Time columns in Access with empty strings ("") or with any other value that does
not correspond to the range of values specified for the data type.
[Reference]80040e10—Too few parameters
This error occurs when a column specified in your SQL query does not exist in the database table. Check the column
names in your database table against the SQL query. The cause of this error is often a typographical error.
September 4, 2007
