[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: 

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

sp_qbfilename

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

Using the QuickBooks application, you may verify the database (QuickBooks company file) path.

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