Forums
This topic is locked
Database connectivity using DMX and MS Access
Posted 27 Nov 2002 22:56:18
1
has voted
27 Nov 2002 22:56:18 Mudit Bhushan posted:
Hi everybody,I have a small problem and would welcome your kind help.
I have an asp page. You could view it using the link www.bus.utk.edu/mudit/default.asp
The problem that I am facing is that when I click the button " Add to Database", the data transfer from my form(asp page) to the database(MS Access) is not happening. The Access database always displays empty rows. What could be the errors.
I did all the stuff pertaining to
1) Creating the DSN
2) Linking the DSN to my Access database
3) Adding the database to my Dreamweaver MX application
4) Binding it
5) Creating the recordset
6) Creating the query to insert records.
Do we need to link the database to the "add to database" button on the asp page?? If yes?? How do we do it??
Programming experts may kindly look at the source code on the asp page and suggest.
Please help. I badly need it.
Thanks,
Mudit
Replies
Replied 30 Nov 2002 07:04:11
30 Nov 2002 07:04:11 No more Newsletter replied:
Did you use the server behavior 'Insert Record'? It sounds like you just haven't defined the form fields in the Insert Record behavior.
If your form fields do not have exactly the same names as the database fields, it will not automatically them. Aaagh. I hope I'm not making this seem more difficult than it really is. Send me an email directly if you'd like more help.
If your form fields do not have exactly the same names as the database fields, it will not automatically them. Aaagh. I hope I'm not making this seem more difficult than it really is. Send me an email directly if you'd like more help.