locked
Update SQL fail RRS feed

  • Question

  • I migrate a database from SQL 2000 to SQL 2008.

    It works fine for years using SQL 2000.

    I migrated it to SQL  2008 and it happens some times one update SQL fails for some reason.

    the query works sometimes, but it fails sometimes to update and get ODBC error.

    I would like to know are there any reason or place to look in to this that SQL works with SQL 2000 for years and it fails some times after migrate to SQL 2008.

    Your help and information is great appreciated,

    Regards,

    Souris,

    • Changed type sourises Tuesday, April 16, 2013 7:32 PM
    Tuesday, April 16, 2013 1:59 PM

Answers

  • Thanks a million for helping,

    It is the index issue, I need create index for the table,

    Thanks again for the information and help,

    Regards,

    Souris,

    • Marked as answer by sourises Friday, April 19, 2013 3:04 PM
    Friday, April 19, 2013 3:04 PM

All replies

  • Hi, Look this:

    http://www.sqlservercentral.com/blogs/pearlknows/2010/12/13/upgrading-to-sql-server-2008-a-comprehensive-checklist/

    Regards,


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    Tuesday, April 16, 2013 4:25 PM
  • Thanks for the message,

    The SQL is correct and works sometimes, but it fail sometimes,

    any particular place I can look this?

    Your help and information is great appreciated,

    Regards,

    Souris,

    Tuesday, April 16, 2013 4:51 PM
  • What's the error message?


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    Tuesday, April 16, 2013 4:55 PM
  • I use MS Access as frontend,

    the message is ODBC - update onlinked table 'MyTbale' failed

    [Microsoft][ODBC SQL Server Deriver]Query timeout expired(#0),

    Regards,

    Souris,

    Tuesday, April 16, 2013 5:20 PM
  • Check the Query Properties in your access, there you can adjust the ODBC Timeout. Default is 60s. I believe some times your query runs in less than 60 seconds and in other takes more than 60 seconds so you get this error.

    More information about SQL ODBC time outs you can find in the link below:

    http://msdn.microsoft.com/en-us/library/ms190181.aspx

    Regards,


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    Tuesday, April 16, 2013 7:39 PM
  • Thanks for the message and help,

    It is an update query which should take less than one second.

    It works sometime, but not always.

    It seems that the server could not find the record for some reason.

    I would like to try DBCC and Rebuild index to see does it help or not,

    Thanks again for the information and help,

    Regards,

    Souris,

    Tuesday, April 16, 2013 8:00 PM
  • Np! Please mark as helpful if the informations helps you! thks!

    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    Tuesday, April 16, 2013 8:12 PM
  • Thanks a million for helping,

    It is the index issue, I need create index for the table,

    Thanks again for the information and help,

    Regards,

    Souris,

    • Marked as answer by sourises Friday, April 19, 2013 3:04 PM
    Friday, April 19, 2013 3:04 PM