Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    5

    Unanswered: How do private Apps connect with their database?

    Newbie here, the real question is:

    QuickBooks uses iAnywhere databases as the db of choice for their app. My question is how does the app communicate with iAnywhere?

    How is this connection hidden from a local user on a local machine?

    If anyone could explain this to me, it would be greatly appreciated.

    Thanks,
    Matt

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Hmm.. I wish there were separate forums for all the sybase products... ASE, IQ, Anywhere etc are totally different products...

    But anyways... I donno about QuickBook.

    Does it automatcially take care of users, updating db etc...?

    If so, this is my guess...

    a) It maintains a single user for all its operations which is not visible to users.
    b) If there are users in Quickbook with passwords, it maintains it in separately owned non-system table ( app based ) and maintains permissions OR creates logins in ASA based on what you provide in the front-end which I doubt...

  3. #3
    Join Date
    Nov 2007
    Posts
    5
    Thank You for your thoughts trivishi,

    QuickBooks does have users and passwords and it does maintain some fairly strict user permissions (at least at the QuickBooks Enterprise level it does).

    I'm trying to find a way to communicate with the core iAnywhere database (it's a long story, why I can't use the QuickBooks SDK), and I'm just looking for other possibilities.

    If I could somehow replicate the connection of the app to the database, I might be able to pull it off. As of yet however, I haven't got a clue how to do that.

    I appreciate your thoughts,
    Matt

  4. #4
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Ok.. I worked on PowerBuilder about 8 years ago.. and it comes with an internal ASA database I think... My guess is Quickbooks is written in Powerbuilder... I will search around to see if I can be more useful than this

Posting Permissions

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