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 : QODBC Scheduled TaskSearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 QODBC Scheduled Task 
 Author   Message 
  MikeF 
  
 Group: Members 
 Posts: 4 
 Joined: 2006-05-24 
 Profile
 Posted : 2007-08-23 19:56:22

I have a scheduled task running on our Windows 2003 server which copies data from QB to a database every night.  The scheduled task calls a Visual Foxpro program.  This task runs fine, as scheduled, if the user is logged into the terminal server account.

But, when the user is not logged in to terminal server, the scheduled task hangs.  I get an error that says,  "This application is not allowed to change its authentication preferences unless QuickBooks is running with the Administrator logged in." 

This was working fine on our previous 2k3 server.  This was working fine while we were testing the new 2k3 server (using the evaluation version of QODBC.)  It apears to have stopped working once I deactivated/activated the QODBC license to move it to the new server.  Could it be related or am i missing something?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-08-23 20:06:05
Scheduled tasks run as a Windows Service and requires the QODBC Server Edition (which the QODBC Evaluation is). Scheduled tasks must be run on the server console as a local session. Try looking at: ERROR: This application is not allowed to change its authentication preferences  

  Top 
  MikeF 
  
 Group: Members 
 Posts: 4 
 Joined: 2006-05-24 
 Profile
 Posted : 2007-08-23 20:31:31

Thanks for your response.  That helps a lot.

Just to be clear... Will it work if I have the server edition? 

Since it worked fine for over a year on the old 2k3 server should I assume that I had the server version?  Perhaps I used the wrong activation key?

Please clarify.

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-08-23 21:19:09
Please look at the About tab in the QODBC Setup Screen to check what type of license you are running. 

  Top 
  MikeF 
  
 Group: Members 
 Posts: 4 
 Joined: 2006-05-24 
 Profile
 Posted : 2007-08-23 22:05:29

I am indeed running the Desktop Read Write 2006 Version 6.00.00.155 on the new server.

I checked the old server where the program was working.  It says I was running the same version, but it now says it is a "QODBC Expired Evaluation" since I deactivated it.  I cannot tell if it is/was the server version.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-08-24 01:52:36
Hopefully you are not running QuickBooks 2007 on the new server. Try running the Visual FoxPro program manually on the desktop. 

  Top 
  MikeF 
  
 Group: Members 
 Posts: 4 
 Joined: 2006-05-24 
 Profile
 Posted : 2007-08-24 04:07:34

The Visual Foxpro data transfer program runs fine through the terminal server session.

The scheduled task runs fine when the user is logged into terminal server.

The scheduled task will not run when the user is not logged into terminal server. 

This same configuration did work on our old server.  Everything looks the same.

We are using QuickBooks 2006 Pro. 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-08-24 06:46:47
The console user must be logged into terminal server for the scheduled task to run. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to