Forums
This topic is locked
database connectivity
Posted 27 Nov 2002 22:38:20
1
has voted
27 Nov 2002 22:38:20 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 28 Nov 2002 09:01:13
28 Nov 2002 09:01:13 Vince Baker replied:
Have you attached the insert record behaviour to the form?
i.e. Selected Insert Record option from the Server Behaviours menu
Regards
Vince
Response.write("The best line of code you can ever use"
VBScript | ASP | HTML | SQL | Oracle | Hosting
i.e. Selected Insert Record option from the Server Behaviours menu
Regards
Vince
Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting
Replied 28 Nov 2002 19:46:41
28 Nov 2002 19:46:41 Mudit Bhushan replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Have you attached the insert record behaviour to the form?
i.e. Selected Insert Record option from the Server Behaviours menu
Regards
Vince
Response.write("The best line of code you can ever use"
VBScript | ASP | HTML | SQL | Oracle | Hosting
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Have you attached the insert record behaviour to the form?
i.e. Selected Insert Record option from the Server Behaviours menu
Regards
Vince
Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 28 Nov 2002 19:49:35
28 Nov 2002 19:49:35 Mudit Bhushan replied:
Dear Vince,
Yes, I have done "Insert Record" in Server Behaviors. What is the next step after this??
Also, if you get time, please go to my website www.bus.utk.edu/mudit/default.asp and check the source code....if u detect something I missed out, please let me know.
I appreciate your help my friend,
Mudit
Yes, I have done "Insert Record" in Server Behaviors. What is the next step after this??
Also, if you get time, please go to my website www.bus.utk.edu/mudit/default.asp and check the source code....if u detect something I missed out, please let me know.
I appreciate your help my friend,
Mudit