asp error message

[baby asp-er]

Hello all!

I'm brand new to asp and am trying to do a simple database entry script...

I haven't even gotten as far as writing my own script as sample scripts I'm trying won't even work! grrr....

anyway... my problem is this...
I'm using MS;s PWS and when I hit the submit button I get an error saying:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

/webpub/addrecordado2.asp, line 18
I've checked through the properties... and non of the files are read only... help?

Thanks in advance!

[baby asp-er]

ooh... one more thing... is asp the best way to do this? I eventually want to be able to have people insert thier info and have people be able to search the database.

[vass0922]

ASP is an easy way to achieve this.

How are you connecting to the DB, is it through an ODBC System DSN, File DSN ... or just using ADO connection?

I've seen that error before, but can't remember what it was that was wrong... quite irritating though I know that.

[baby asp-er]

there is another file with it that is conn.inc

I imagine it is using that... within that file is simply this:

<% strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("adoandsqladd_update.mdb") %>

I'm guessing that is just an ADO connection... but I honestly don't know even that much.

hehe, I'm trying not to sound to clueless... as it all seems relatively straight forward, and yet does not seem to want to work

[baby asp-er]

okay...

so now what i've done is place the line from conn.inc
<% strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("adoandsqladd_update.mdb") %>


right within my asp response page and tried to do away with the .inc file... to see if it would help... it didn't...

it gives me this error
Variable is undefined: 'strconn'

I've tried muddling, but to no avail.

[vass0922]

You'll have to define strconn if I'm not mistaken.. I'm more familiar with vbscript/vb then asp (nearly the same thing, but its in the html)

try putting

<%

Dim strConn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("C:\pathto database\adoandsqladd_update.mdb")

%>

[baby asp-er]

I really appreciate the help...thanks again

I tried it and it gave me this...

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/webpub/addrecordado2.asp, line 5

Dim strConn =
----------------^

[baby asp-er]

woohoo!

Okay... I tried a different example... and had success... so... thanks... I'm giving up on this one!

sweet relieve from frustration!!!

Thanks again!

[vass0922]

<%

Dim strConn
strConn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("C:\pathto database\adoandsqladd_update.mdb")

%>
Would probably have worked thats what I meant to do in the first place but a typo
Forgot you can't do that in asp

Congrats, you're on you're way

[baby asp-er]

thanks vass,

tried it just to see... still no go... let's trash it shall we?