Knowledgebase: Tutorials
[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 the QB file is open OR closed (desired behavior).

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

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

I need this to be running on some computers in the office. Some 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 the 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 the 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).