Knowledgebase: Connection
[QODBC-Desktop] Troubleshooting - DSN Connection Not Consistent across multiple computers
Posted by Jack - QODBC Support on 23 May 2016 02:28 PM

Troubleshooting - DSN Connection Not Consistent across multiple computers

Problem Description:

I have a pass-through query for access:

Select * from Item

The connection string is as follows:

ODBC;DRIVER={QODBC Driver for QuickBooks};SERVER=QODBC;DFQ=x:\qb\MyQBcompanyfile.qbw;OpenMode=F;OLE DB Services=-2;OptimizerOn=No;

This works on pc #1 if QB file is open OR closed (desired behavior).

This ONLY works on pc #2 if QB File is Closed.

Why is it operating different?? I am using the same access file on both pc.

I need this to be running on some computers in the office. Some of the computers are allowed to use QuickBooks, and some are not, so I need a flexible DSN connection string that will work for both circumstances. 
 

Solution:

Please verify company file path from the non-working machine. The other computer might be accessing the company file mapped via network name i.e. \\servername\folder\ (e.g. \\qbfileserver\qb\MyQBcompanyfile.qbw ) when the connection string is using a mapped drive i.e. x:\

Please Start QuickBooks from the non-working machine, log in to the company file, press f2 and verify if the file path is the same in connection string & test again.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).