filling an access table with data put in a form

Report · Nov 04, 2006

Hello everybody and in particular to Jeffrey Bardzell, if he's there...
I'm reading the guide "Dreamweaver MX 2004 with ASP, COLDFUSION and PHP written by J.Bardzell" aiming at learning how to create asp dynamic pages. Thanks to J.Bardzell for his very good book. BUT I'M HAVING PROBLEMS!

I'm using Dreamweaver 8.
I'm trying to create an application for users' registration. In simple words this is what I want to happen:
1)the user fills a form with his personal data,including email and password and then he presses the submit button - this implies:
a)the data go into the data base within a table prepared in advance to store them and so he's REGISTERED;
b)the browser shows the page I made for login. There's a second form where he has to insert his email address and password to be recognised as a registered user.
In order to get this result I set the connection to the database and appearently all seems well done .
But unfortunately:
when I try pressing "submit" either nothing happens or there's an error page saying:

type of error:
Microsoft OLE DB Provider for ODBC Drivers (0X80004005)
[Microsoft][Driver ODBC Microsoft Access]
An updatable query is required for the operation
/newland/register.asp, line 141

(the last line is referred to the ficticious site used by the Bardzell book.)

Bardzell says that when defining the connection to the database (in the "data source name" window) it must be specified that Dreamweaver should connect "using dsn on testing server". When I do so the data base appears not to be on the testing server. Instead it shows if I use the local dsn. But still data are not sent to the data base table.

Please help, I'm desperate, I need to solve this!
Thank you,
Giuseppe, Rome.

Report · Nov 05, 2006

The error is related to permissions setting on the database. Have a look at
the article on www.charon.co.uk on how to set the permissions.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"giuseppe craparotta" <webforumsuser@macromedia.com> wrote in message
news:eiii9b$ch3$1@forums.macromedia.com...
> Hello everybody and in particular to Jeffrey Bardzell, if he's there...
> I'm reading the guide "Dreamweaver MX 2004 with ASP, COLDFUSION and PHP
> written by J.Bardzell" aiming at learning how to create asp dynamic pages.
> Thanks to J.Bardzell for his very good book. BUT I'M HAVING PROBLEMS!
>
> I'm using Dreamweaver 8.
> I'm trying to create an application for users' registration. In simple
> words
> this is what I want to happen:
> 1)the user fills a form with his personal data,including email and
> password
> and then he presses the submit button - this implies:
> a)the data go into the data base within a table prepared in advance to
> store
> them and so he's REGISTERED;
> b)the browser shows the page I made for login. There's a second form
> where he
> has to insert his email address and password to be recognised as a
> registered
> user.
> In order to get this result I set the connection to the database and
> appearently all seems well done .
> But unfortunately:
> when I try pressing "submit" either nothing happens or there's an error
> page
> saying:
>
> type of error:
> Microsoft OLE DB Provider for ODBC Drivers (0X80004005)
> [Microsoft][Driver ODBC Microsoft Access]
> An updatable query is required for the operation
> /newland/register.asp, line 141
>
> (the last line is referred to the ficticious site used by the Bardzell
> book.)
>
> Bardzell says that when defining the connection to the database (in the
> "data
> source name" window) it must be specified that Dreamweaver should connect
> "using dsn on testing server". When I do so the data base appears not to
> be on
> the testing server. Instead it shows if I use the local dsn. But still
> data are
> not sent to the data base table.
>
> Please help, I'm desperate, I need to solve this!
> Thank you,
> Giuseppe, Rome.
>