ASP / Access Help Request
Lou Zucaro
I'm having this weird problem...not sure what it might be related to
(server problem?) but here it is:
I have a simple ASP script that writes some info to a table in an Access
database. I can read from the table just fine in other scripts, but even
if I just try to open the database for writing, the ASP page generates a
500 error.
What's more, if I make this the default web, I get the more detailed info
from the 500-100.asp file in IIS5 that says that the line in which I try
to open the database is causing the error. Normally this is not the
default web on the server (server's in my office), so I mapped the
500.100 error to the 500-100.asp file and it still doesn't give me
detailed info when not on the default web. Hmm.
Anyway, here is the very simple bit of code that's causing the error, as
well as the error itself. More notes afterwards:
<Begin Code snippet:>
<Line 80> rString = "SELECT * FROM UData WHERE CustID=" & tCustID
<Line 81> rs.Open rString, oconn, adOpenDynamic, adLockPessimistic
<End Code Snippet>
By the way, in this case, tCustID is set to 1 and there *is* a record
with that value. What's triggering the error is that I'm trying to open
the database to be able to write to it. If I open it read-only
(adOpenStatic) I don't have any trouble.
<Begin Error:>
Technical Information (for support personnel)
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/password-change.asp, line 81
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Page:
POST 63 bytes to /password-change.asp
POST Data:
Password=160288&NewPassword1=lou&NewPassword2=lou&I1.x=0&I1.y=0
Time:
Wednesday, January 03, 2001, 10:08:44 AM
<End Error>
A few other things: The database is not read-only. The directoy's
permissions appear to be correct (the database was added w/in
FrontPage2000 and published ok)...Everyone has read/write etc.
permissions.
I'm stumped...any thoughts on why this might be happening?
LZ
DaveL
"Lou Zucaro" <l...@netspecialists.com> wrote in message
news:MPG.14bd17335...@news1.ync.net...
Lou Zucaro
No, I didn't...I wasn't supposed to...but I *was* supposed to add a line
into global.asa that points to the .dll instead.
Boy do I feel stupid...thanks so much for pointing out my silly error.
Happy New Year!
LZ
In article <iaK46.9860$I5.184823@stones>, dl...@w3co.net says...