[QODBC Desktop ] How do I determine which database it is using to set up the connection with QuickBooks
Posted by Ricky - QODBC Support on 10 October 2019 12:36 PM

[QODBC Desktop] How do I determine which database it is using to set up the connection with QuickBooks?

Problem Description:

How do I determine which database it is using to set up the connection with QuickBooks?

Solutions: 

To determine which database you are connected to, you may run the following command.

sp_qbfilename

This will return the database (QuickBooks company file) path with which you are connected.

 

You may verify the database (QuickBooks company file) path using the QuickBooks application.

You can find the QuickBooks company file path via QuickBooks UI, press the F2 key (Function Key 2) you will see the file information.

 

You may verify the QuickBooks company you are connected to.

To verify, please execute the SQL Statement using your application.

Select * from Company

 

Tags: QuickBooks company file name, company file path, database, database connection

(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).