|
|
|
Frequently asked questions
|
|
Below you can find an overview of the faqs. If you have a question you would like to suggest for the section
... send it to info@aspnl.com.
You can also ask questions on one of the mailinglists.
There are faqs in the following sections:
General
Databases
|
|
GENERAL
|
What is ASP?
ASP is a technology with which dynamic websites can be built.
More information can be found
here.
|
What do I need for ASP and how do I install it?
What you need can be found here.
How to install ASP can be found here
|
|
DATABASES
|
I get the next error message when I try to update or add a record:
[Microsoft][ODBC Microsoft Access Driver] Operation must use updateable query
You may have opened the recordset in read-only mode, which is the default if
you do not specify anything. When you try to add ir update a record in such
a recordset, you get this error, so you need to change the mode in which you
open the recordset from adLockReadOnly to adLockPessimistic.
ASP also needs to have appropriate access rights to open the database for
writing. Check if the IUSR account (the user under which ASP operates) has
rights to write into the folder in which the database is situated and to the
database itself.
More about this problem can be found
here.
|
I have got special characters in my query/update/insert, waardoor die niet goed werkt.
Especially ' characters give problems. You can replace them, but then you can't search on them.
You can also replace them by placing the characters two times behind one anothers, so the database knows
it's a '.
The database will put only one ' in the database. Other solutions are using the
the recordset object (slow), parameter queries or stored procedures.
|
|
|
