Manufacturing Information Solutions Forum Index Manufacturing Information Solutions
Your Place for Support and Discussions
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

ODBC and Pass-through queries

 
Post new topic   Reply to topic    Manufacturing Information Solutions Forum Index -> QuickBooks
View previous topic :: View next topic  
Author Message
mistux
Site Admin


Joined: 25 Jun 2004
Posts: 1042
Location: South Bend, Indiana USA

PostPosted: Mon Aug 25, 2008 10:30 am    Post subject: ODBC and Pass-through queries Reply with quote

I've read on QODBC forums, that you can't really use regular queries on linked tables in MS Access because it is way to slow (due to the way access works with the data)

I have learned that this product works great with MS Access as long as you use SQL pass-through queries on large tables such as invoices, invoiceLine, Bill BillLine etc. SQL

Using Pass-through and the QODBC optimizer enable this product to be very fast and make it usable with MS Access.

You shouldn't need to use temporary "make table queries" if you use a pass-through query instead. (this should save you a step). Create your select query by using a pass-through query as your data source instead of using a "made-table" as your data source.

There are plenty of examples of how to create a pass-through query on the QODBC Forums. Pass through queries can only be written in SQL language but the "select statements" can be easily copied, pasted and modified from other sources and examples.

To create a pass-through query to use as your data source you will need to access the linked tables with an SQL specific query. (right click on on the query in design view to change query to SQL specific).

You will also need to enter:
ODBC;DSN=QuickBooks Data;SERVER=QODBC
in the ODBC Connect Str Field, which can be found by right clicking the top bar of the pass-through query in design view and editing the properties of the pass-through query.
Back to top
View user's profile Send private message Send e-mail
mistux
Site Admin


Joined: 25 Jun 2004
Posts: 1042
Location: South Bend, Indiana USA

PostPosted: Mon Aug 25, 2008 10:38 am    Post subject: Reply with quote

Q:
Should I have a file DSN as shown in the Access instructions?


A:
No you should always use a QODBC SYSTEM DSN which in MS Access is shown as a MACHINE DATA SOURCE Type: SYSTEM.

I do suggest you turn off the driver status box
Back to top
View user's profile Send private message Send e-mail
mistux
Site Admin


Joined: 25 Jun 2004
Posts: 1042
Location: South Bend, Indiana USA

PostPosted: Thu Sep 18, 2008 9:56 am    Post subject: Reply with quote

You will want to use SQL pass-through queries when using MS Access on large tables. (invoices, invoiceLine, Bill BillLine etc)

There are plenty of examples of pass-through queries on the QODBC Forums.

You don't want to use regular queries to access linked tables in MS Access. The process is way to slow due to the way access works with the data. SQL Pass-through and the QODBC optimizer make this product worth using with MS Access.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Manufacturing Information Solutions Forum Index -> QuickBooks All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group