Solved

Does anyone have QODBC experience on Windows 7 64bit?

Posted on 2010-11-17
5
1,032 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
adobe acrobat scaning 9 51
issue installing SQL SERVER 2012 express on windows 7 9 42
Windows 7 x64 won't update 8 81
Error in script 11 48
First some basics on Windows 7 Backup.  It has 2 components one is a file based backup which is stored in .zip files each zip is split at around 200 Megabytes and there is the Image Backup which is as the name implies a total image of the partition …
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
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). …
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now