|
 |
asp_databases thread: Help with ASP & ACCESS (Please I am going nuts!)
Message #1 by "Arti" <wookie36@h...> on Tue, 16 Jan 2001 21:27:48 -0000
|
|
I am relatively new to ASP & would appreciate any help from this group. I
am using Access as the back end. The aim is to register a new user to the
site.
Once the user fills in all details (name, address etc) the data has to be
stored into the database & a new page is displayed.
Now while doing this at home (Using PWS ) everything is working fine, but
the moment i tried to upload the files on the server, it shows me this
message
"
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
"
I have tried everything, from usign a FILEDSN, to a DSNless connection to
oledb now - but they all give me this error!
The sql statement is perfectly ok...
Here it is..
<%
Dim myConn, mySql
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Provider = "Microsoft.Jet.OLEDB.4.0"
myConn.Open "d:\coorg\website\nypep\Offlist.mdb"
mySql = "Insert into volunteer
(FirstName,LastName,Email,sAdd,City,State,Zip,Phone) Values("
mySql= mySql&"'"&Request.form("fName")&"'"&","
mySql= mySql&"'"&Request.form("lName")&"'"&","
mySql= mySql&"'"&Request.form("email")&"'"&","
mySql= mySql&"'"&Request.form("sAdd")&"'"&","
mySql= mySql&"'"&Request.form("city")&"'"&","
mySql= mySql&"'"&Request.form("state")&"'"&","
mySql= mySql&"'"&Request.form("zip")&"'"&","
mySql= mySql&"'"&Request.form("phone")&"');"
myConn.Execute mySql
myConn.close
END IF
%>
Somebody, Anybody! PLEASE HELP!!!
I would really aprreciate any advice on this.
Thanx
Message #2 by shrij@v... on Wed, 17 Jan 2001 15:02:11 +0530 (IST)
|
|
Hi Aarti,
the moment i tried to upload the files on the server, it shows me this
message
"
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
"
I have tried everything, from usign a FILEDSN, to a DSNless connection to
oledb now - but they all give me this error!
-- u do not have proper permission on the directory where the database has been uploaded and/or u do not have the proper permission
for the database.
--check with web server administrator
Regds
Shreekar Joshi
Message #3 by "Wally Burfine" <oopconsultant@h...> on Wed, 17 Jan 2001 02:10:35 -0000
|
|
Check out your connect string. Since IIS using a virtual directory system,
you have to make sure that the one you are using is correct.
>From: "Arti" <wookie36@h...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] Help with ASP & ACCESS (Please I am going nuts!)
>Date: Tue, 16 Jan 2001 21:27:48 -0000
>
>I am relatively new to ASP & would appreciate any help from this group. I
>am using Access as the back end. The aim is to register a new user to the
>site.
>Once the user fills in all details (name, address etc) the data has to be
>stored into the database & a new page is displayed.
>Now while doing this at home (Using PWS ) everything is working fine, but
>the moment i tried to upload the files on the server, it shows me this
>message
>"
>Microsoft JET Database Engine error '80004005'
>
>Operation must use an updateable query.
>"
>
>I have tried everything, from usign a FILEDSN, to a DSNless connection to
>oledb now - but they all give me this error!
>
>The sql statement is perfectly ok...
>Here it is..
>
><%
>Dim myConn, mySql
>Set myConn = Server.CreateObject("ADODB.Connection")
>myConn.Provider = "Microsoft.Jet.OLEDB.4.0"
>myConn.Open "d:\coorg\website\nypep\Offlist.mdb"
>
>mySql = "Insert into volunteer
>(FirstName,LastName,Email,sAdd,City,State,Zip,Phone) Values("
>mySql= mySql&"'"&Request.form("fName")&"'"&","
>mySql= mySql&"'"&Request.form("lName")&"'"&","
>mySql= mySql&"'"&Request.form("email")&"'"&","
>mySql= mySql&"'"&Request.form("sAdd")&"'"&","
>mySql= mySql&"'"&Request.form("city")&"'"&","
>mySql= mySql&"'"&Request.form("state")&"'"&","
>mySql= mySql&"'"&Request.form("zip")&"'"&","
>mySql= mySql&"'"&Request.form("phone")&"');"
>
>
>myConn.Execute mySql
>
>
>myConn.close
>
>END IF
>%>
>
>
>Somebody, Anybody! PLEASE HELP!!!
>
>I would really aprreciate any advice on this.
>Thanx
>
Message #4 by Vijay Saste <vijay_saste@y...> on Tue, 16 Jan 2001 22:46:59 -0800 (PST)
|
|
Hi Arti,
ust try this code
instead of hardcoding the path use the following like
of code
conn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data
Source=" & server.MapPath ("/name of directory/") &
"\name of mdb file.mdb;"
i think this should work
bfn
vijay
Message #5 by Gregory_Griffiths@c... on Wed, 17 Jan 2001 08:47:27 +0000
|
|
This seems to be a problem with your ASP, please post the code.
> -----Original Message-----
> From: wookie36@h... [mailto:wookie36@h...]
> Sent: 16 January 2001 21:28
> To: asp_databases@p...
> Subject: [asp_databases] Help with ASP & ACCESS (Please I am going
> nuts!)
>
>
> I am relatively new to ASP & would appreciate any help from
> this group. I
> am using Access as the back end. The aim is to register a new
> user to the
> site.
> Once the user fills in all details (name, address etc) the
> data has to be
> stored into the database & a new page is displayed.
> Now while doing this at home (Using PWS ) everything is
> working fine, but
> the moment i tried to upload the files on the server, it shows me this
> message
> "
> Microsoft JET Database Engine error '80004005'
>
> Operation must use an updateable query.
> "
>
> I have tried everything, from usign a FILEDSN, to a DSNless
> connection to
> oledb now - but they all give me this error!
>
> The sql statement is perfectly ok...
> Here it is..
>
> <%
> Dim myConn, mySql
> Set myConn = Server.CreateObject("ADODB.Connection")
> myConn.Provider = "Microsoft.Jet.OLEDB.4.0"
> myConn.Open "d:\coorg\website\nypep\Offlist.mdb"
>
> mySql = "Insert into volunteer
> (FirstName,LastName,Email,sAdd,City,State,Zip,Phone) Values("
> mySql= mySql&"'"&Request.form("fName")&"'"&","
> mySql= mySql&"'"&Request.form("lName")&"'"&","
> mySql= mySql&"'"&Request.form("email")&"'"&","
> mySql= mySql&"'"&Request.form("sAdd")&"'"&","
> mySql= mySql&"'"&Request.form("city")&"'"&","
> mySql= mySql&"'"&Request.form("state")&"'"&","
> mySql= mySql&"'"&Request.form("zip")&"'"&","
> mySql= mySql&"'"&Request.form("phone")&"');"
>
>
> myConn.Execute mySql
>
>
> myConn.close
>
> END IF
> %>
>
>
> Somebody, Anybody! PLEASE HELP!!!
>
> I would really aprreciate any advice on this.
> Thanx
>
Message #6 by =?iso-8859-1?Q?H=E5kan_Frennesson?= <hakan@c...> on Wed, 17 Jan 2001 11:21:37 +0100
|
|
Hi!
This is typically related to file/folder permissions on a NTFS file system.
You need to give the IUSR-account read and write access on the database and
read, write and delete rights on the folder where the database resides. Hope
you understand my clumsy English. :) You are probably using Win98 at home
and are uploading to a WinNT or Win2000 server. On a Win98 machine there is
no security at all, so you donīt see the problem until you try on NTFS file
system.
Hth
Hakan
-----Original Message-----
From: Arti [mailto:wookie36@h...]
Sent: den 16 januari 2001 22:28
To: ASP Databases
Subject: [asp_databases] Help with ASP & ACCESS (Please I am going nuts!)
I am relatively new to ASP & would appreciate any help from this group. I
am using Access as the back end. The aim is to register a new user to the
site.
Once the user fills in all details (name, address etc) the data has to be
stored into the database & a new page is displayed.
Now while doing this at home (Using PWS ) everything is working fine, but
the moment i tried to upload the files on the server, it shows me this
message
"
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
"
I have tried everything, from usign a FILEDSN, to a DSNless connection to
oledb now - but they all give me this error!
The sql statement is perfectly ok...
Here it is..
<%
Dim myConn, mySql
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Provider = "Microsoft.Jet.OLEDB.4.0"
myConn.Open "d:\coorg\website\nypep\Offlist.mdb"
mySql = "Insert into volunteer
(FirstName,LastName,Email,sAdd,City,State,Zip,Phone) Values("
mySql= mySql&"'"&Request.form("fName")&"'"&","
mySql= mySql&"'"&Request.form("lName")&"'"&","
mySql= mySql&"'"&Request.form("email")&"'"&","
mySql= mySql&"'"&Request.form("sAdd")&"'"&","
mySql= mySql&"'"&Request.form("city")&"'"&","
mySql= mySql&"'"&Request.form("state")&"'"&","
mySql= mySql&"'"&Request.form("zip")&"'"&","
mySql= mySql&"'"&Request.form("phone")&"');"
myConn.Execute mySql
myConn.close
END IF
%>
Somebody, Anybody! PLEASE HELP!!!
I would really aprreciate any advice on this.
Thanx
|
|
|
View Cart
