Results 1 to 14 of 14

Thread: SQL Error 40002

  1. #1
    Join Date
    Jun 2006
    Posts
    7

    SQL Error 40002

    When saving to db sql chucks out error 40002 and kills application. Application was written in VB5 with data recently migrated from sql7 to sql2000.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    What's the full error message.

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    Maybe mdac version mismatch, try upgrade mdac on app server.

  4. #4
    Join Date
    Jun 2006
    Posts
    7
    Updated MDAC still getting same error. SQL2000 running on server 2003 with xp on clients. Error only occurs when saving data, application will open and read data.

    Thanks in advance

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Do you have complete error message?

  6. #6
    Join Date
    Jun 2006
    Posts
    7
    Full error message reads.
    Runtime error 40002
    01000: [Microsoft][ODBC SQL SERVER DRIVER][SQL SERVER] this statement has been terminated.

    Again thanks in advance

  7. #7
    Join Date
    Sep 2002
    Posts
    5,938
    Do you have same version of mdac on both server and client machine?

  8. #8
    Join Date
    Jun 2006
    Posts
    7

    Mdac

    Indeed I do have the same version of mdac running on both app server and clients...

  9. #9
    Join Date
    Sep 2002
    Posts
    5,938
    Did you apply any sql2k service pack? Is the db in compatibility level 80?

  10. #10
    Join Date
    Jun 2006
    Posts
    7

    Exclamation Compatibility

    No sp's applied, compatibility level is 80
    Last edited by davidb; 01-17-2007 at 04:38 AM. Reason: forgot to add in additional text

  11. #11
    Join Date
    Sep 2002
    Posts
    5,938
    Apply sp4 if possible.

  12. #12
    Join Date
    Jun 2006
    Posts
    7
    sp4 applied still same as any ideas?

  13. #13
    Join Date
    Jun 2006
    Posts
    7
    product version: 8.00.2039
    product level: sp4
    edition: enterprise edition

  14. #14
    Join Date
    Apr 2006
    Posts
    30
    are u using ADO in the VB app (i hope)?

    try using oledb rather then odbc driver.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •