Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook
Devcon 2020 Goes Virtual! LEARN MORE >

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Alpha Web Server: Still unable to access database: Error opening Grid table/view: H

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    Alpha Web Server: Still unable to access database: Error opening Grid table/view: H

    I have been fighting this problem for three days and the prior thread is to long so here is the problem simplified:

    1) The Error:
    Error opening Grid table/view: Host/Server not found

    2) On the Alpha Five Ver 10.5 database platform it works fine. I can publish and launch the browser. It connects to the sql database and shows me the data.

    3) On another workstation running the App Web Server on the Lan (Vista),when I access the the website either form the Main Internet or from our local Lan I receive the error opening grid. The correct A5W page comes up, but the it is unable to access the table.

    4) The App Web Server is running on Port 8080. I am using NO-IP to tell the DNS the ip address of the Vista station. That seems to work fine.

    5) I am using a named connection string (digitalstreak_sql), which reference is found on the app web server in:
    a5_application.a5i and my grid componet called grd_add_emails.a5wcmp

    This is the actual connection string (Alpha Five Hides the password:)

    {A5API='SQLServer',A5DBVersion=2008,Server='216.243.10.125',database='digitalhahn',A5ANSINullPadWarn=Default,UserName='digitalhahn',Password='��������'}


    The actual connection string literal is found in the following files on the Alpha Web Server Vista Machine:
    a5_application.a5i under the pathalias.adb_path reference.

    In a file called quickpublish.settings is the name of the profile I used to publish the project.

    There is only one form and one component grid in the project.

    I am able to use access 2000 or the control panel odbc and connect to the remote sql server on the vista alpha web app server machine without a problem.

    I am really stuck.

    Any ideas?

    Thanks,

    Michael (mrh)
    Last edited by coyotemrh; 07-16-2010, 12:06 PM. Reason: add connection string
    Tags: None
    #2
    Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

    Here is the old thread
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.
    "Make it as simple as possible, but not simpler."
    Albert Einstein

    http://www.iadn.com/images/media/iadn_member.png

    Comment

      #3
      Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

      Michael, Selwyn Rabins himself tried to help you. He's co-chairman and CTO of the company. You're not going to find anyone more competent.

      It sounds like you have an installation or publication issue. You'll need to get someone to mentor or support you who can get on your development box and server and run diagnostics. Assuming that you've actually checked that all the installed versions are consistent and that everything has been republished properly, it's not an issue where peer support is likely to be useful.

      If this can be narrowed down to an Alpha bug and reported in a way that can be reproduced here, we'll fix it promptly, but you're far from narrowing it down.

      Comment

        #4
        Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

        I appreciate the help. But Mr. Rabins was going to send me a test form. The test form he sent was incomplete (missing components). I would like to have run his test form.

        I would like to send my small zipped project. I already had somebody else open it and run it fine on the alpha development machine.(which I can also do) Now we need to publish it using a differnet web app server from mine (he is buying the webb app server this weekend).

        Could I send it to somebody? It is small and easy. If it publishes w/o changs in your environment (excpet publishing path), that says the publishing part is correct and there is a problem with either the web app server or the macine it is running on.

        there seem to be some oddites. Such as the error log. Even though I had the error generated (unable to open grid) this is all the error log said:

        [Fri Jul 16 13:02:37 2010] [startup] Server is starting.
        [Fri Jul 16 13:52:19 2010] [shutdown] Server is shutting down.

        The most obvious question is: Does the app web server run on VISTA?

        Should I move it to a different machine?

        Thanks,

        michael

        Comment

          #5
          Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

          What is the EXACT url from Alpha WAS you want to see on that port 8080?
          What port is the WAS using default 80 ? If so is there an IIS server running on that port?
          I see you application Moving company on port 8080 correct?
          is that the Alpha WAS I don't think so because there no a5w suffix.

          I think there is a confict on 8080 move suggestion move the was to a other port like 8000
          But before that I need the full url.
          Lets see or we can solve the problem... just one other try .......
          Last edited by bea2701; 07-16-2010, 03:26 PM.

          Comment

            #6
            Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

            Thanks Eric,

            The web site name is www.digitalstreak.net which has a related back end sql database that is remote.

            Yes, I am using port 8080 which I have opened up through our firewall. That seems to work. You can access the alpha app web server remotely and it gets through our firewall ok.

            I am right now moving it off the vista machine to an xp machine. Give me a few minutes and I will give you an update if the error is still there.

            when you say is there an "IIS server running on that port?" i am not sure what you mean, but this is a simple set up and the only things monitoring that reprot are the alpha web server and our firewall which routes traffic to the alpha web server ... and that works.

            thanks,

            Comment

              #7
              Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

              Ok, IT WORKS! I moved it from the Vista workstation to a XP Workstation and it now works. Still running on port 8080.

              Not sure what the problem was? Maybe some other program on the vista machine? The vista machine also had McAfee but I had turned that off ...

              But, simply by installing it on the new machine it worked.

              Thanks everybody!

              Michael.

              Comment

                #8
                Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

                http://12.184.202.203:8080/ is the url from no-ip

                I think your up I see an alpha grid

                I made a test record "Test Eric " in the grid
                check that I think your up and running.

                Eric

                Comment

                  #9
                  Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

                  Yes Eric, Thanks. Checked the datat and it is there ... i just threw up that form as a test ... and great news that it is working. Finally. Alpha folks were very good trying to help me. I probably should have yanked it off the vista machine yesterday and tried it on an xp machine.

                  In the next few days I am going to strip down the vista machine of all it's background processes and move the app server back to that machine ... and hopefully figure out what the real problem was on the vista machine!

                  thanks for your help.

                  michael

                  Comment

                    #10
                    Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

                    Before you strip the vista machine:
                    Try an other Virusscanner Macafee is known of "eating" every page instance realtime maybe that is the cause. Try AVG or F-prot ( what i use myself) last is cheap 5 machines 25 Euro works like a charme.

                    Comment

                      #11
                      Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

                      McAfee has been on both machines I have had a problem with ... maybe monday I will switch to trend or ?. Thanks bea2701.

                      mrh

                      Comment

                        #12
                        Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

                        It could be the UAC settings on the Vista machine.

                        Comment

                          #13
                          Re: Alpha Web Server: Still unable to access database: Error opening Grid table/vie

                          Thanks Martin,

                          But the UAC settings are turned off. I am going to load windows 7 on that vista machine to see if that takes care of the problem (fresh install).

                          Comment

                          Previous template Next
                          Working...
                          X