Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : SQL Server 2005 Express, query never returns anythingSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Installation Support Forum

 New Topic 
 
 Post Reply 
[1]  
 SQL Server 2005 Express, query never returns anything 
 Author   Message 
  declouet 
  
 Group: Members 
 Posts: 29 
 Joined: 2007-06-27 
 Profile
 Posted : 2007-06-28 00:51:12

The DCOM config test worked properly. The linked server QODBC shows up in Management Studio. When I run a query, I here the "Windows beep"  and the query  "SELECT ListID FROM QODBC...Customer" never finishes executing.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-28 12:49:14
See: SQL 2005 EXPRESS & QODBC  

  Top 
  declouet 
  
 Group: Members 
 Posts: 29 
 Joined: 2007-06-27 
 Profile
 Posted : 2007-06-28 13:14:04

The queries do finish executing, but they never return any rows. I have gone through the entire setup process as described in the link you posted. Everything seems fine. In the VB Demo, the queries work fine. In SQL Server 2005 Express, the query executes successfully, but 0 rows are returned. I've tried many types of queries, but I always get 0 rows returned.

 

  Top 
  declouet 
  
 Group: Members 
 Posts: 29 
 Joined: 2007-06-27 
 Profile
 Posted : 2007-06-28 13:44:08

To be clear, the table header information shows up in Managment Stuio Express when I execute a query, but zero rows get returned.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-28 13:46:06

Most likely you are using VB Demo and Management Studio at the same time. The QODBC optimizer is single user only so you need to setup a different optimizer file for the SQL Server to use than the other disktops applications. To do this step up a seperate System DSN (see: How do I create or configure a QODBC DSN? ) and specify a fixed location of the optimizer database folder for SQL Server to use instead of the default UserProfile method.

Also, please try running:

SELECT * FROM QODBC...HOST

as it's a one rowset table.

 

  Top 
  declouet 
  
 Group: Members 
 Posts: 29 
 Joined: 2007-06-27 
 Profile
 Posted : 2007-06-28 22:43:50

I was not using the VB Demo and Managment Studio at the same time. However, I have completed the steps that you suggested. I reloaded all data, but when I run the query

SELECT * FROM OPENQUERY(QODBC,'SELECT * FROM HOST')

I here the "Windows beep" and it says "Executing query..." ,  but nothing else happens. I no longer get the table headers returned without rows.  

 

  Top 
  declouet 
  
 Group: Members 
 Posts: 29 
 Joined: 2007-06-27 
 Profile
 Posted : 2007-06-29 03:20:31

I have set up a separate DSN and optimizer file location. Am I NOT supposed to "Rebuild All Data" for this separate SQL Server optimizer file?

The table's column headers show up, but still zero rows are returned. I am using this query

Select * from QODBC...HOST

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-29 08:06:18

Please review the instructions shown at: Does QODBC work with MS SQL Server 2005 Linked Tables?  Try checking the "Run 2.1 ODBC Compatibility" off if it's already checked, or check it if it's currrntly unchecked.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to