Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1664
  • Last Modified:

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

0
nordine5
Asked:
nordine5
3 Solutions
 
edwardiiiCommented:
Hi, nordine5.

I'm wondering if it's a pathing issue.  I know MS Access can only be interacted with when the .mdb file is mapped.  For example, if the pathing to your Access db is anything other than "C:\", "H:\", etc., followed by "yourDbName.mdb", the db won't be accessible.
0
 
JQuartermaineCommented:
It could also be that you did not set permission for IUSR_MACHINENAME to have write access to the database or folder containing the database.  Are you using windows XP SP2 as well Nordine 5?  THere are some scripts that need to be updated in dreamweaver for some database connectivity to work properly after install of windows XP SP2.   Let me know the answers to these and if they are possibly the issue, i will post complete walkthroughs to their solutions.

-JQ
0
 
nordine5Author Commented:
the problem is that even though the connection to the database was successful when I

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.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
JQuartermaineCommented:
Did you set permissions on your folder containing the database?  That could totally cause what you describe.  Look here for more info.

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19067

http://www.webwizguide.info/asp/faq/server_permissions.asp

and on the 2nd link pay special attention to the warning at the bottom for Windows XP users.

Cheers.
0
 
avgavgCommented:
- 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!
0
 
pborreggCommented:
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.


0
 
pborreggCommented:
Here's the correct link.

memaportal.mema.state.md.us/NIMS/nims_online_training_registration_form_insert.asp
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now