nordine5
asked on
Connecting a Dreamweaver input form to Access
Hello all,
I have created a an input from for my Dreamweaver website; I would like people to fill out the form with their name, email etc and click a submit button; the problem is that I can't get it to connect to my Access database even though I have set up my DSN connection.
Here is what I did so far.
1) I created a connection using Data Source name from the databases under the Applications menu. I used the option of DSN on testing server; I tested it and it connected successfully
2) I created a Recordset from the Bindings menu. it showed my connection and table. Again I tested the connection and it was successful.
3) I created an Insert Record and chose the table in my database.
4) I saved everything and and uploaded the form.
However, when I put information and click submit, I get an error message and no info show up in the database. I tried this several times. I am not sure if I am missing something.
If any one can tell me what I did wrong, I would appreciate it
Thanks
I have created a an input from for my Dreamweaver website; I would like people to fill out the form with their name, email etc and click a submit button; the problem is that I can't get it to connect to my Access database even though I have set up my DSN connection.
Here is what I did so far.
1) I created a connection using Data Source name from the databases under the Applications menu. I used the option of DSN on testing server; I tested it and it connected successfully
2) I created a Recordset from the Bindings menu. it showed my connection and table. Again I tested the connection and it was successful.
3) I created an Insert Record and chose the table in my database.
4) I saved everything and and uploaded the form.
However, when I put information and click submit, I get an error message and no info show up in the database. I tried this several times. I am not sure if I am missing something.
If any one can tell me what I did wrong, I would appreciate it
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
- What type of Server Technology have you specified while creating the site in Dreamweaver? Is it JSP or ASP or PHP?
- Since your connection to the Access database was successful, enter some test data in you Access database and then create a simple query in Dreamweaver to see if you are able to read data from your access database.
- Post your result and we will take it from there.
Good luck!
- Since your connection to the Access database was successful, enter some test data in you Access database and then create a simple query in Dreamweaver to see if you are able to read data from your access database.
- Post your result and we will take it from there.
Good luck!
Hi there... I'm having a similar Problem...
I can use dreamweaver and test a form on the web.
Here's the link.
www.memaportal.mema.state.md.us/NIMS/nims_online_training_registration_form_insert.asp <-- This is not accessible yet on the website below.
The website that this actually refers to is: www.marylandics.org
If you notice several of the drop down boxes DO NOT contain data but rather > or %> signs. WHY? I haven't a clue. I've set perms accordingly and yet this form works on the development server.
The database is in a folder away from the ROOT of the website and the ODBC connection mimics that of the local version on the development environment. I do not know what to do short of taking the computer and using it for Anchor Test material. Seriously... can anyone offer assistance.
I can use dreamweaver and test a form on the web.
Here's the link.
www.memaportal.mema.state.md.us/NIMS/nims_online_training_registration_form_insert.asp <-- This is not accessible yet on the website below.
The website that this actually refers to is: www.marylandics.org
If you notice several of the drop down boxes DO NOT contain data but rather > or %> signs. WHY? I haven't a clue. I've set perms accordingly and yet this form works on the development server.
The database is in a folder away from the ROOT of the website and the ODBC connection mimics that of the local version on the development environment. I do not know what to do short of taking the computer and using it for Anchor Test material. Seriously... can anyone offer assistance.
Here's the correct link.
memaportal.mema.state.md.u
memaportal.mema.state.md.u
ASKER
test it under the Custom Connection String, I can't get the information to show up in my database.
Instead I get an error message "Page cannot be displayed" when I click submit.