Solved

Does anyone have QODBC experience on Windows 7 64bit?

Posted on 2010-11-17
5
1,042 Views
Last Modified: 2012-05-10
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
Comment
Question by:mmurdy1196
  • 2
5 Comments
 
LVL 11

Assisted Solution

by:stlinae
stlinae earned 500 total points
ID: 34165880
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
 

Accepted Solution

by:
mmurdy1196 earned 0 total points
ID: 34268256
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
 
LVL 11

Expert Comment

by:stlinae
ID: 34268444
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
 

Expert Comment

by:_alias99
ID: 34308392
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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question