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