Alpha Video Training
Results 1 to 3 of 3

Thread: Data is not retrieving from MySql database when we host our web app into server?

  1. #1
    Member
    Real Name
    Satyanarayana Lella
    Join Date
    Dec 2011
    Location
    Hyderabad
    Posts
    164

    Default Data is not retrieving from MySql database when we host our web app into server?

    Hi,

    We got an error while retrieving data from MySql database when we host our web app into server?
    Its running fine in localsystem ....

    I got following error


    error1.png

  2. #2
    Member totallycovered's Avatar
    Real Name
    Derek Schaefer
    Join Date
    Jun 2010
    Location
    Orlando, FL
    Posts
    121

    Default Re: Data is not retrieving from MySql database when we host our web app into server?

    Are you sure that's directly related to the actual retrieval of data from the mysql server? Could it be page security? I'm not an expert. But if it's working locally, and your MySql database is not on your development machine, this is the only thing I can think of that would make your app unable to access the database after publishing:

    Check that your AlphaDAO connection string is set up right in the Profile you're publishing with. That's here:
    Web Project Control Panel tab> click Publish button> select the Profile you use and click Add/Edit profile button (tiny button to right of profile name in dropdown list)> In General section, make sure Named AlphaDAO Connection Strings is referencing the correct connection string.

    Then, when you publish, make sure you publish using that Profile.

    Just to clarify, there probably are other reasons the sql could not connect, but that's all I can think of right now. Of course, there are many variables. You can publish an .a5w page with no data grid or data reference on it and it shows up fine? My experience with those errors has always been something other than an sql issue, but you obviously have more experience with your app than me!

  3. #3
    Member
    Real Name
    Satyanarayana Lella
    Join Date
    Dec 2011
    Location
    Hyderabad
    Posts
    164

    Default Re: Data is not retrieving from MySql database when we host our web app into server?

    Thanks for giving reply..

Similar Threads

  1. How to host the alpha five v11 web application in server?
    By jyothi28.g in forum Application Server Version 11 - Web/Browser Applications
    Replies: 3
    Last Post: 01-19-2012, 05:00 AM
  2. App Server Using Incorrect LIMIT Syntax in MySQL
    By rsibrent in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 09-19-2010, 10:42 AM
  3. Can an A5 desktop app integrate with the A5 web app server?
    By Synlap in forum Application Server Version 10 - Web/Browser Applications
    Replies: 9
    Last Post: 09-02-2010, 11:07 PM
  4. data shows fine on local host, but, not on web
    By willobeth in forum Application Server Version 9 - Web/Browser Applications
    Replies: 5
    Last Post: 06-10-2009, 12:14 PM
  5. Run Vista as server to host a5w web app
    By jritchie777 in forum Application Server Version 8
    Replies: 6
    Last Post: 04-21-2009, 12:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •