[mattjclark]

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

[trvishi]

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

[mattjclark]

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

[trvishi]

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