error '80004005'

Could you tell me what database do you use and what is in the line 1006 of maintenance_edit.asp?

rs.Update is at line 1006 and I use MYSQL

I see what you saying.
I have seen similar error on some versions of MySQL drivers before.

When you connect to MySQL database there are two options in MySQL ODBC driver settings that need to be checked off: "Don't Optimize Column Width" and "Return Matching Rows".
ASPRunner takes care of this adding these options automatically if they weren't selected. Here is the sample connection string build by ASPRunner for MySQL:

strConnection = "DRIVER={MySQL ODBC 3.51 Driver};DESC=;DATABASE=test;SERVER=;UID=;PASSWORD=;PORT=;SOCKET=;OPTION=3;STMT=;"

OPTION=3 means both above options were selected.
Please post your connection string here for investigation. Connection string can be found in include/dbconnection.asp file.

Hi, I checked don't optimize column width, the other was checked. The connection was 0 so I changed it to 3, and the string was really weird.
It was repeating, the same thing over

<%

strConnection = "DSN=MyServices;UID=root;PWD=passwordDATABASE=mysql;DSN=MyServices;OPTION=3;

PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=passwor

d;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=3306

;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=rootDA

TABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=rootDATABASE=mysq

l;DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=MySer

vices;OPTION=3;PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTIO

N=3;PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=pas

sword;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=

3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=ro

otDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=rootDATABASE=

mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=M

yServices;OPTION=3;PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;O

PTION=3;PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD

=password;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;P

ORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UI

D=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=rootDATAB

ASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=rootDATABASE=mysql;D

SN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServic

es;OPTION=3;PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3

;PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=passwo

rd;PORT=3306;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=330

6;UID=rootDATABASE=mysql;DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=root"

%>
so I changed it to
<%

strConnection = "DSN=MyServices;OPTION=3;PWD=password;PORT=3306;UID=rootDATABASE=mysql;DSN=M

yServices;OPTION=3;PWD=password;PORT=3306;UID=root"

%>
It fixed the problem but created another. It forces me to have at least one character. If I clear the text box and save, it shows record saved, but puts the text back in the box. If I delete the contents and press the space bar it saves the box blank.
I need to be able to clear the boxes, because if a unit is not due for service it clears the box

Hi Sergey, anything to fix the new problem?

It fixed the original problem but created another. It forces me to have at least one character. If I clear the text box and save, it shows record saved, but puts the text back in the box. If I delete the contents and press the space bar it saves the box blank.
I need to be able to clear the boxes, because if a unit is not due for service it clears the box. thx

There must be some incompatibility between MySQL Server and MySQL ODBC driver versions. Could you tell me what are versions of those two products?