Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1071
  • Last Modified:

Does anyone have QODBC experience on Windows 7 64bit?

I'm needing to get QODBC working on windows 7 64 bit. I am able to call win 7 32 bit odbc, but can't establish QODBC driver. QODBC is 3rd party ODBC driver for quickbooks dev kit api. I'm using Informatica secure agent to connect to win 7 64 bit system. The QODBC people say it works and I know one other person who says it works for them. I can get the QODBC test vb app that simply tests the driver to work, but when called from informatica agent securely as windows service, it doesn't get the driver to produce any debug output meaning that the QODBC driver isn't getting any information when accessed via the service.

I apologize if this is hard to follow - I'm a bit unclear on the problem source exactly. I've reinstalled quickbooks and upgraded to QB 2011 Pro. I've added a user account to windows for the informatica agent service & added user inside quickbooks for that account, too. I've gone thru the services in windows and tried using user/pass or logging on the service with the default user credentials. nothing is working.

Tried credentials & default user credentials on these 4 windows services:
FLEXNET LICENSING SERVICE
INFORMATICA SECURE AGENT
QBCFMONITORSERVICE quickbooks company file monitoring svc
QUICKBOOKSDB18** last one quickbooks db svc

Thanks for any light you can shed,

msm
0
mmurdy1196
Asked:
mmurdy1196
  • 2
2 Solutions
 
stlinaeCommented:
I may be totally off base as I honestly have no idea what informatica is.

-You said you upgraded to QB 2011, did you also upgrade the qODBC driver? (11.00.00.275 is the current one I believe.)
-If you're using QB 2011 the QuickBooksDB should be 21 not 18.
-Have you check this link:   http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=41&post_id=1373 (I know you said Windows 7 but FLEX will refer you back to the Vista install.)
-When you say the "test vb app that simply tests the driver..." are you referring to the "test QuickBooks connection" in the setup or the VBDemo tool? You should be getting data back in  VBDemo, are you?
0
 
mmurdy1196Author Commented:
QODBC replied to my ticket with:

    First, our 32 bit QODBC could not access any 64 bit applications. And please see the link below for more about using QODBC in a Windows 7 64 bit system:
    <a href="http://support.flexquarters.com/esupport/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=10662&nav=0,58,90">Vista/Windows 7 and 64 bit and QODBC</a>

From Juliet <support@qodbc.com>
0
 
stlinaeCommented:
I disagree with the with the author's statement "...No other member in this exchange had as accurate an answer." While it is a different link, the one I provided contains the Same information as the "official" one he received. Yes, mine contained more, but if he had read to the bottom section of the post, as it stated to do so at the top, he would have found the same information.

Close the post without points, fine (even though I disagree)...but the author does not deserve a refund as an answer was given.
0
 
_alias99Commented:
All,
 
Following an 'Objection' by stlinae (at http://www.experts-exchange.com/Q_26656251.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed accepting the Author's answer and awarding points to the Expert for an 'assisted' answer.
 
At this point I am going to re-start the auto-close procedure.
 
Thank you,
 
_alias99
Community Support Moderator
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now