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 not working after upgrading to 2007Search Forum

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

 New Topic 
 
 Post Reply 
[1]  
 SQL not working after upgrading to 2007 
 Author   Message 
  Ravi Agarwal 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-12-30 
 Profile
 Posted : 2006-12-30 09:33:36

Today I upgraded to QODBC v7 (7.00.00.204)  and upgraded to QB enterprise 2007, from the 2006 versions of both products. I have an ASP.NET application that does simple SELECTS/INSERTS/UPDATES to the customer table, and the SELECT queries are now failing - even though the very same SQL works correctly in the vb demo.

An example of SQL failing in my application (it returns zero rows) that returns 1 row in the vb demo is:

SELECT  ListID, AccountNumber FROM    Customer WHERE   FullName = 'Stein, Maxine'

I have the server read/write edition, and other statements (UPDATE/INSERT) work correctly as before. I have not changed any of the asp.net code doing this upgrade, and have restarted the server, and reinstalled qodbc twice. Any suggestions would be really helpful, since this is production code which is failing, thanks
Ravi

 

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

You need to purchase a new CD Key for the QODBC v7 Server Edition for QuickBooks 2007. When you upgraded QuickBooks you also needed to purchase a new CD Key for the new version of QuickBooks. The CD Key you currently have is only good for QuickBooks up to 2006.

The serial number issued to you for this product indicates the highest version of Quickbooks Pro, Premier or Enterprise that the product can be used with. If your serial number contains the year "06" at position 2 of the serial number, it is registered to only work with QuickBooks 2006 and lower versions. If the serial number is set to "05" it will work only with QuickBooks 2005 and lower versions and so on.

 

  Top 
  Ravi Agarwal 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-12-30 
 Profile
 Posted : 2007-01-04 03:52:46

Hi Tom, I have already purchased the key, and it seems to be correctly installed - here's a screenshot:

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-01-04 09:32:00

Ok, how does:

SELECT  ListID, AccountNumber FROM    Customer

work? Still no rows?, then try using ForwardOnly Cursors.

With rs
    .CursorType = CursorTypeEnum.adOpenForwardOnly
    .LockType = LockTypeEnum.adLockOptimistic
    .CursorLocation = CursorLocationEnum.adUseServer
End With

 

  Top 
  Ravi Agarwal 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-12-30 
 Profile
 Posted : 2007-01-04 11:39:33

Hi Tom, do you know what the equivalent code in vb.net is?
(also this is a production web server system, so I need to deploy all tests to production in order to test them, we dont have a development installation for QB - and so it's not pretty work!  )

also, this is my connection string - could any of these options be modified on this?

DSN=Quickbooks Data;DFQ=e:\Quickbooks\...\E...2006.qbw;OpenMode=M;OLE DB Services=-2

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-01-04 20:16:51

I have logged these errors with the QODBC Software Engineer under Support Ticket ID: BR00000047.

You can switch back to QODBC v6, simply rename fqqb32.dll to fqqb32.204 and run the QODBC v6.00.00.176 installer. I do it all the time!

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-04-04 09:50:05
We have now fixed this in QODBC v7.00.00.214. See: How can I get the latest version of QODBC?  

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to