Solved

Does anyone have QODBC experience on Windows 7 64bit?

Posted on 2010-11-17
5
1,044 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
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…

726 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