This topic is locked

Unable to add or update records

12/22/2005 11:05:13 PM
ASPRunnerPro General questions
dbeckers author

I'm unable to update or add records into my databases.

I've setup pages on a remote server (NOT FTP server, but used as an internal INTRANET server)

Server has installed APACHE and IIS with severall ASP interpreters
I can connect to my db, I can view my queries,

but when I try to update or add a record, I get following error :

Microsoft VBScript runtime

error '800a0009'

Subscript out of range:

'[number: 0]'

include/linenumbers_aspfunctions.asp, line 1563

How I set-up the connection

from the database:

\\servername\folder\Output\db\accessdatabase.mdb

(the use Server.MapPath, I left standard flagged on 'db' )

How I have set-up the output directory:

\\servername\folder\Output>

Website URL

http://servername/folder/output/index.htm
Strange is when I setup this on my local pc (also installed IIS on my pc) it works, no problem with adding or updating records.
This is how it's setup locally:

c:\folder\Output\db\accessdatabase.mdb

(the use Server.MapPath, I left standard flagged on 'db' )

How I have set-up the output directory:

\\servername\folder\Output>

Website URL

http://pcname/folder/output/index.htm

Also I asked my collegeau to try and update a records access the db on my pc, it works.
It looks to me an access problem (like I've right to view the records, but not to update them),

however I've granted everybody full access on the db and still it isn't working.
Could be that it's caused due to the way ASPRunner is talking to the db.

Anybody an idea ?

Much appreciated

Didier

Sergey Kornilov admin 12/23/2005

Answered to your personal email.