PDA

View Full Version : Posting data to my new database


branchwebin
11-06-2008, 06:58 AM
Hello Everyone,

Need some help.
I?ve created a simple web page using VB developer 2005 express edition. I have uploaded all my files and database.
Everything is working fine except when a user is submitting a form that is submitting info onto the database.
When the user hits submit nothing is posting into the tables of the database.
I?ve updated my web.config file to point to my new web site as follows :
<connectionStrings>

<clear />
<add name='LocalSqlServer' connectionString='Data Source=tcp:sql2k515.discountasp.net;Initial Catalog=SQL2005_564361_mydatabase;User ID=SQL2005_564361_mydatabase_user;Password= *** my password here ***'
providerName='System.Data.SqlClient' />
<add name='SQL2005_564361_mydatabase_userConnetionStrin g' connectionString='Data Source=tcp:sql2k515.discountasp.net;Initial Catalog=SQL2005_564361_mydatabase;User ID=SQL2005_564361_mydatabase_user;Password=*** my password here ***'
providerName='System.Data.SqlClient' />



</connectionStrings>

I?ve also attached the database using the attach database file tool in SQL Server 2005.
I?m I missing something?
Please help.

branchwebin
11-06-2008, 11:37 AM
I've made the updates and no luck. Still not posting.


I'm stuck.I'm ready to pull out my hair. http://community.discountasp.net/emoticons/smhair.gif

wisemx
11-06-2008, 12:10 PM
Hi,
This can get very deep. Technically.

Even if you have done everything properly with your DB conn and objects the Submit may not function.
There are many reasons, both from the web.config settings to your pages code.

One suggestion, just guessing, would be to add these settings to the top of your code page:

[quote]

<%@ Page EnableSessionState="True" Explicit="True" Language="VB" Debug="False" validateRequest="false" %></CODE>Change the Language="" to whichever page level code language you are using but add the other settings.
Salute,
Mark



Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

(Microsoft IT Usability http://msitusability.multiply.com/)

branchwebin
11-07-2008, 02:42 AM
Oh that would be very helpful.
Can I email you my code? Its a very simple web page form. I'm just not seeing what I'm doing wrong.

Thanks again for your help.

wisemx
11-07-2008, 02:58 AM
Hi,
Sure... wisemx@msftwise.com


*That's one of the servers DASP provides for me and it so far handles spam perfectly.
Salute,
Mark




Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

(Microsoft IT Usability http://msitusability.multiply.com/)

wisemx
11-07-2008, 12:47 PM
Hi,
If you want me to descretly take a look at your code pages there's no problem.
Just let me know. I don't want to see anyone loose hair over things like this.
As you may notice I try to help everyone but also do my best to keep it enjoyable.
When these sort of things get stressful its bad for everyone. http://community.discountasp.net/emoticons/wink.gif
Salute,
Mark



Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

(Microsoft IT Usability http://msitusability.multiply.com/)