Posting data to my new database

Discussion in 'Databases' started by branchwebin, Nov 6, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. 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_userConnetionString' 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.
     
  2. I've made the updates and no luck. Still not posting.


    I'm stuck.I'm ready to pull out my hair. [​IMG]
     
  3. 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:

     
  4. 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.
     
  5. 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. [​IMG]
    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/)
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page