Knowledgebase: TroubleShooting
[QODBC-Desktop] How to use MS Access as Middleware with QODBC
Posted by Jack - QODBC Support on 05 August 2014 12:51 PM

How to use MS Access as Middleware with QODBC

Problem Description:

When using Prepared Statements with QRemote driver then it throws an error called ODBC driver not supported. How can I use Prepared Statements with QODBC/QRemote?

Solutions:

You may be using a function/feature which is not supported by ODBC driver. You can use MS-Access as middleware, ie. Create linked tables in MS-Access, connect your application to MS-Access, MS-Access has linked table connecting to QRemote or QODBC.

First of all you need to create linked table in MS Access. Please refer below mentioned article for creating linked table in MS Access.

For 32-Bit MS Access: How to Configure QODBC to Work With 32-bit MS Access

For 64-Bit MS Access: How to Configure QODBC to Work With 64-bit MS Access

Please Note 64-Bit MS Access article contains information about Import table, Please choose "Link to the data source by creating a linked table" option for creating linked table.

Now we are creating MS Access DSN that is pointing to Access database file which we created in the above steps. Please follow below steps for creating MS Access DSN.

1) Please create new MS Access DSN from:
Start>>All Programs>> QODBC Driver for use with QuickBooks>> Configure QODBC Data Source>>Go To "System DSN" Tab>>Click on "Add"

http://support.flexquarters.com/esupport/newimages/MSAccessMiddleware/Step1.png 

2) Choose "Microsoft Access Driver (*.mdb, *.accdb)" & click on "Finish" button. 

http://support.flexquarters.com/esupport/newimages/MSAccessMiddleware/Step2.png

 

3) Enter DSN name & description & click on select.

http://support.flexquarters.com/esupport/newimages/MSAccessMiddleware/Step3.png

4) Provide MS Access database file location which we created earlier & click on "OK". 

http://support.flexquarters.com/esupport/newimages/MSAccessMiddleware/Step4.png

 

5) Click on "OK" to save DSN.

http://support.flexquarters.com/esupport/newimages/MSAccessMiddleware/Step5.png

6) Newly created DSN is available in DSN list.

http://support.flexquarters.com/esupport/newimages/MSAccessMiddleware/Step6.png

7) Now we will use this DSN as a Middle ware. We are testing this DSN with our VB Demo application. Please open VB Demo from:
Start>>All Programs>> QODBC Driver for use with QuickBooks>>VB Demo
Please click on Connection>>Add New Connection: 

http://support.flexquarters.com/esupport/newimages/MSAccessMiddleware/Step7.png

8) Please select newly created DSN from Machine Data Source & click on "OK".

http://support.flexquarters.com/esupport/newimages/MSAccessMiddleware/Step8.png

9) You can see we are able to connect to MS Access DSN from VB Demo application. Please write your SQL statement & click on "Query".

http://support.flexquarters.com/esupport/newimages/MSAccessMiddleware/Step9.png

You can see we are able to fetch data with MS Access DSN from VB Demo application.

http://support.flexquarters.com/esupport/newimages/MSAccessMiddleware/Step10.png

You can use this MS Access DSN with any of your applications.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).