DSN less Connection

csdunn1us

New Member
Joined
Feb 25, 2016
Messages
16
With Excel 2016 64 Bit, I am attempting to create a DSN less connection in PowerQuery to a Quickbooks (version 14) company file. The driver for this is the QODBC driver.

Per QODBC documentation, I should be able to follow the following example syntax to make this connection:

sConnectString = "Driver={QODBC Driver for QuickBooks};DFQ=C:Program FilesQODBC Driver for QuickBookssample04.qbw;OpenMode=M;OLE DB Services=-2;"

So I've tried that in PowerQuery by going to the 'Data' tab > New Query > From Other Sources > From ODBC.

The connection string I use is: {QODBC_Test};DFQ=C:\Users\Public\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions 14.0\Sample_Retailer_who_Tracks_individual_sales.QBW;OpenMode=M;OLE DB Services=-2

There is a table named 'Account' in this file, so I also add the following sql statement: Select * from Account

When I click 'ok', I get the following message:
'Unable to Connect
We encountered an error while trying to connect
Details: "ODBC: ERROR [iM002] [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified.

Should I try to configure this as a connection from a Blank Query? Are DSN-less connections not an option for Power Query?

Thank you for your help.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Last edited:
Upvote 0
Hi
Maybe your problem is because you use Excel 64bit but QuickBooks is a 32 bit application. 64 Bit Driver Setup, How to Configure QODBC to Work With 64-bit MS Excel - Powered by Kayako Help Desk Software. After you have builded a connection and got a table data onto sheet win MS Query see the connection property for getting connection string text for using it in power query connection.
Regards,

Thank you for the feedback. I have previously gone through the steps outlined from the links you provided, and have achieved connectivity. The aim of using a DSN less connection is to access tables in the Quickbooks file without the file being open in an instance of Quickbooks. The Auto-Login feature is supposed to support that, but has not to this point. I've checked several resources on the FlexQuarters site with regards to this as well.
 
Upvote 0

Forum statistics

Threads
1,224,157
Messages
6,176,744
Members
452,741
Latest member
Muhammad Nasir Mahmood

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top