Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Does anyone have QODBC experience on Windows 7 64bit?

Posted on 2010-11-17
5
Medium Priority
?
1,068 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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

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…
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses
Course of the Month12 days, 22 hours left to enroll

971 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