Alpha DevCon 2018
Results 1 to 5 of 5

Thread: QB Enterprise 11 - Multiple Sites

  1. #1
    Member
    Real Name
    Wayne
    Join Date
    Nov 2009
    Posts
    20

    Default QB Enterprise 11 - Multiple Sites

    Hi, I am trying to set-up a new project using a QB Enterprise 11 file with multiple inventory locations.

    I have no problem connecting to the QB, but I cannot see the tables that relate to the multiple inventory, for example the 'ItemSites' table?

    These tables do not show up?

    I am sure I am missing something simple, please help.

    Thanks.

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: QB Enterprise 11 - Multiple Sites

    I'm thinking that multiple inventory location support via QODBC starts with QODBC 2012..

    Check QODBC.COM
    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.

  3. #3
    Member
    Real Name
    Wayne
    Join Date
    Nov 2009
    Posts
    20

    Default Re: QB Enterprise 11 - Multiple Sites

    Hi, ok I've now got QODBC 2012 (12.00.00.288) installed with QReportbuilder 2009 (Version 9 Build 2193) but I still have a problem.

    I cannot immediately see the additional tables for multi site, but then I performed Link/Import External Data and Create Passive Link Tables, on the Select Tables screen I can see all of the tables like InventorySite and ItemSites.

    I can create the link for InventorySite but I get the following error when I try to create the link for ItemSites:

    Database API specific error

    Your database has returned the following error code and description to Alpha Five.
    Consult your database documentation for further information.

    10057 - '[QODBC] Error: 1030 - This request is not supported by this implementation.
    SQL State is: 00000 while converting ResultSet to DBF table'

    What am I doing wrong?

    Thanks...


    I

  4. #4
    Member
    Real Name
    Wayne
    Join Date
    Nov 2009
    Posts
    20

    Default Re: QB Enterprise 11 - Multiple Sites

    Ok, I think I have it working now. In QB I went to the Integrated Applications under Preferences and there were several Flexquarters QODBC so I removed them and re-linked throught QReportBuilder, I think it is working now....

  5. #5
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: QB Enterprise 11 - Multiple Sites

    Check if you can see the tables with the vbdemo that comes with QODBC.
    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. How to run multiple web sites
    By JH10 in forum Application Server Version 10 - Web/Browser Applications
    Replies: 101
    Last Post: 09-22-2011, 02:41 AM
  2. Multiple Web Sites on one A5 WAS
    By MichaelCarroll in forum Application Server Version 10 - Web/Browser Applications
    Replies: 31
    Last Post: 04-08-2011, 01:26 AM
  3. Multiple Published Sites - Clarification
    By MichaelCarroll in forum Application Server Version 10 - Web/Browser Applications
    Replies: 6
    Last Post: 01-20-2011, 06:24 PM
  4. Does the server work for multiple web sites?
    By Corinthian in forum Application Server Version 10 - Web/Browser Applications
    Replies: 7
    Last Post: 11-19-2010, 07:44 AM
  5. Publishing multiple Sites on same server
    By dkeenen in forum Application Server Version 8
    Replies: 5
    Last Post: 02-25-2008, 10:19 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
  •