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 : v7 fix autologin problem with v6?Search Forum

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

 New Topic 
 
 Post Reply 
[1]  
 v7 fix autologin problem with v6? 
 Author   Message 
  MikeG 
  
 Group: Members 
 Posts: 6 
 Joined: 2006-06-06 
 Profile
 Posted : 2006-11-11 04:03:49

Does QODBC v7 fix the autologin problem with QODBC v6.00.00.155? Supposedly there was a problem the SDK from Intuit that v6 was developed from. Here's a topic in this forum describing the issue: After upgrading to QuickBooks 2006, QODBC "auto-login" unattended mode no longer works?

http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=2&post_id=1">

 

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-11-11 18:35:12

This issue is an Intuit SDK issue, not QODBC. Intuit required us to change unattended mode access for QuickBooks 2005 and 2006 (and is still the same for 2007), which we did from QODBC v6.00.00.150 onwards. Unfortunately, all 2005 company files that have been accessed previously by QODBC have this problem when the company file is converted by QuickBooks to the new 2006 or 2007 Sybase backend format. The conversion by QuickBooks corrupts the internal integrated applications settings and you need to do the 17 step workaround procedure.

When I upgraded my QuickBooks 2005 to QuickBooks 2007, I have use the procedure even though unattended (auto-login) mode was working previously with QODBC v6.00.00.176 before.

 

  Top 
  MikeG 
  
 Group: Members 
 Posts: 6 
 Joined: 2006-06-06 
 Profile
 Posted : 2006-11-13 11:08:01

Yeah, I know the problem is with the Intuit SDK and not QODBC.

But just so I'm clear, QODBC v7 was developed with the new Intuit SDK, correct? And the new SDK contains the same issue?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-11-13 11:56:05

QODBC v7 uses the SDK that's installed when QuickBooks is installed. So depending on the Year of your QuickBooks, a different SDK rev is installed. For QuickBooks 2006 it was qbXML v5, and for QuickBooks 2007 it's now qbXML v6, and yes v6 has the same problem as v5.

 

  Top 
  MikeG 
  
 Group: Members 
 Posts: 6 
 Joined: 2006-06-06 
 Profile
 Posted : 2006-11-14 02:43:45

How does this relate to Kowledge Base articles 1000269 (open a single file when QB is closed) and 1000264 (open multiple files when QB is closed) on the QuickBooks Support website?

What I mean is, do these articles only apply before the SDK changes? The only thing  I saw on the Intuit support site is article 1000297 which I guess addresses the SDK changes, but it is more of a workaround than a fix. I have seen these steps before and posted on this website as well, but they don't always work. It would be nice if Intuit would just correct the issue and not force us to use workarounds.

 

  Top 
  Matt 
  
 Group: Members 
 Posts: 1 
 Joined: 2006-12-30 
 Profile
 Posted : 2006-12-30 09:31:05
Hi All -

I wanted to post some additional problems I am experiencing with this. I am running QB2007 on Windows 2003 Server Standard. I was able to get the autologin working according to the 17 step process.

I started running some queries using QODBC, aside from a long connect time, it was fine. Then I wanted to switch to multi-user mode. I did this and the auto-login stopped working. This really sucked. I am going to continue testing and trying things as I am trying to finish a project in a short amount of time right now.

Has anyone experienced this? Any ideas on how to fix it?

Thanks,
Matt 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-12-30 14:08:39

Changing a company file from Single User mode to Multi-User doesn't effect auto-login, as you need to be in single user mode to change Integrated Application preferences in any case, but adding a QuickBooks user does. This issue remains an Intuit problem and you need to voice your protests with your Intuit representative, not us.

The quickest fix is to go back to a company file that hasn't be connected with QODBC before and connect QODBC for the first time again.

 

  Top 
  montare 
  
 Group: Members 
 Posts: 18 
 Joined: 2006-07-14 
 Profile
 Posted : 2007-07-17 14:45:53

I'm running QBES v.7.0 r8 and I had auto login working on 4 company files last Friday.  Today, auto-login will not work on any of them.  I have changed no settings.  The only thing that changed is switching from single user mode to multi-user mode.  Its like QBES just "forgot" the settings.   I need unattended mode to work.  Frustrating.

I can't get the 17 step process mentioned on the forum to work.   Any other ideas?

Anyone hear if Intuit is doing anything about this?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-07-17 18:23:41
Yes, adding user accounts to a QuickBooks company file can break unattended mode access. You need to follow the After upgrading to QuickBooks 2006 or 2007, QODBC "auto-login" unattended mode no longer works? procedure. Remove all user accounts and integrated FLEXquarters QODBC applications and start again. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to