Alpha Video Training
Results 1 to 3 of 3

Thread: Using Active-Link tables error: Unable to connet to backend database while opening local cache

  1. #1
    Member
    Real Name
    javier
    Join Date
    Jul 2012
    Location
    Madrid
    Posts
    147

    Default Using Active-Link tables error: Unable to connet to backend database while opening local cache

    Hello,

    I´m seriously considering the migration from dbf to SQL and as a first step I´m using the upsize genie to create active-link tables and convert my dbf files.

    To do so, I was required to make small changes to my dbf files and then it all worked beautifully well.

    Then I copied all the UX and grid components of the previous workspace to the new workspace and later I publish the entire web project.

    The only issue that I have come accross so far is:

    When I launch the browser to test it, it runs smoothly until after I open some 10 different grids, and then is when I get the following error message:

    Error opening grid table view: Unable to connet to backend database while opening local cache.


    Please have a look at the attached image for full details of the error message.

    Captura.JPG




    And my question is: How can I avoid this?

    Please help!

    Many thanks in advanced.

    Cheers,
    Javier

  2. #2
    Member
    Real Name
    javier
    Join Date
    Jul 2012
    Location
    Madrid
    Posts
    147

    Default Re: Using Active-Link tables error: Unable to connet to backend database while opening local cache

    Hello,
    I changed the backend from Access to MS SQL Server 2012 Express and the problem is gone.
    Javier

  3. #3
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,595

    Default Re: Using Active-Link tables error: Unable to connet to backend database while opening local cache

    Javier

    Thanks for providing the question and the answer.

    Pleasant journeys.
    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.

Similar Threads

  1. Report error - could not create local cache
    By djvdm in forum Application Server Version 10 - Web/Browser Applications
    Replies: 7
    Last Post: 05-28-2014, 08:33 AM
  2. Error Message when adding User to Group with SQL Active Link Tables for Security
    By Turnbullca in forum Application Server Version 11 - Web/Browser Applications
    Replies: 1
    Last Post: 07-24-2012, 01:38 PM
  3. Error creating set with two active link tables
    By Scott Kurimski in forum Alpha Five Version 10 - Desktop Applications
    Replies: 0
    Last Post: 03-17-2011, 11:34 AM
  4. Alpha Web Server: Still unable to access database: Error opening Grid table/view: H
    By coyotemrh in forum Application Server Version 10 - Web/Browser Applications
    Replies: 12
    Last Post: 07-20-2010, 10:44 AM
  5. data persistance to backend active SQL tables issue
    By saljamea in forum Application Server Version 9 - Web/Browser Applications
    Replies: 0
    Last Post: 04-27-2009, 09:34 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
  •