Troubleshooting - How do I check which region of QuickBooks is installed

Problem Description:

How do I check which region of QuickBooks is installed?

Solution:

You can query the Host table using QODBC Test Tool & get detail about your QuickBooks version.

For Example, SELECT Country FROM Host

 Note:  QODBC Support Wizard is used only to test QODBC SQL queries and is not a development tool.

The above query will return details of your QuickBooks region.

If you are using QuickBooks USA, then the query will return to the US as a result.

If you use QuickBooks UK, the query will return to the UK.

If you are using QuickBooks Canada, the query will return the CA result.

If you use Reckon Account (i.e., QuickBooks Australia), the query will return AU.

Also, You can verify the QuickBooks region from the installation directory:

For 32-bit OS:

C:\Program Files\Intuit\QuickBooks <<YEAR>>\

For 64-bit OS:

C:\Program Files (x86)\Intuit\QuickBooks <<YEAR>>\

For Example: If you have QuickBooks 2014 version:

C:\Program Files (x86)\Intuit\QuickBooks 2014\

If you have the QuickBooks UK version, you will find the en-GB folder under the QuickBooks folder.   

Please refer to the mentioned link for more details: How do I check which version and release of QuickBooks are installed?

You will find the en-CA folder under the QuickBooks folder if you have the QuickBooks CA version.