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 : Timesheet DataSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v7 Forum

 New Topic 
 
 Post Reply 
[1]  
 Timesheet Data 
 Author   Message 
  BREED 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-06-08 
 Profile
 Posted : 2007-06-08 00:48:18

If I am in the wrong forum, then please point me to the correct one.

What table has the Timesheet data in it?  I can see the data in QB without a problem.  When I use QODBC and Crystal, I see the TimeTracking database, but it is empty.  Any ideas?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-08 09:52:24
Try looking at: No rows returned from TimeTracking  

  Top 
  BREED 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-06-08 
 Profile
 Posted : 2007-06-09 06:46:55

I had seen that thread already and tried those steps.

How do I confirm the version of QODBC that I have?  I used the the link in that thread to download the latest version, but I just want to confirm that is what it is using.

I also used the Rebuild utility and Verified the Data.  Neither chanegd anything.  If I point to the sample database, I CAN query the TimeTracking tbale without a problem.

Any other thoughts?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-09 10:21:53
Please make sure you ar running QODBC v7.00.00.214 (see: How can I get the latest version of QODBC? ). If you look at the QODBC Setup Screen "About" tab you will see what version you are running and the status of your QODBC license. 

  Top 
  BREED 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-06-08 
 Profile
 Posted : 2007-06-09 12:18:32
I verified that I am running QODBC v7.00.00.214 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-09 14:54:47

Open one of the sample files to see that you can see TimeTracking data. 

Try running:

SELECT * FROM TimeTracking UNOPTIMIZED

using VB Demo against the sample company file and then your company file. You must also use the QuickBooks admin account and have access to personal data.

 

 

  Top 
  BREED 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-06-08 
 Profile
 Posted : 2007-06-13 23:20:06

Where do you get to the properties screen you showed in your last post?

I have been able to run and return data from the TimeTracking table when I use the Sample db, just run into an issue with the Client db.

I used the Rebuild utility and I verified the data, and then reran the query with the same results.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-14 01:45:15
See: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? for where the access to personal data is setup in both QODBC and QuickBooks. 

  Top 
  BREED 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-06-08 
 Profile
 Posted : 2007-06-14 02:22:03
I followed that document and everything was setup that way already.  Any other ideas? 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-14 03:04:38
Yes, get another copy of the client's company file. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to