Error: "01000: Changed language setting to us_english."-VBForums
Results 1 to 6 of 6

Thread: Error: "01000: Changed language setting to us_english."

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2012
    Posts
    3

    Error: "01000: Changed language setting to us_english."

    Users occasionally get this message through our application, but I have been unable to reproduce it, and it seems entirely random. I know that it is informational only, but the application is reporting it as an error. I had assumed it was coming back with a number of 0, so I trapped that (If Err.Number = 0...), but this just happened again, and clearly it is not that.

    So, I was wondering if anyone actually *knows* what error number this returns. I "believe" it may be 5701, but I cannot verify that, since I cannot reproduce it. Also, if anyone knows how I can force this message, I would appreciate that as well.

    And yes, I know I could trap it by checking the description, but I would rather use the number if at all possible.

    Any help is much appreciated

  2. #2
    PowerPoster Nightwalker83's Avatar
    Join Date
    Dec 2001
    Location
    Adelaide, Australia
    Posts
    13,254

    Re: Error: "01000: Changed language setting to us_english."

    By reading the posts I could find on Error: "01000: Changed language setting to us_english." it seems like the error might have something to do with sqlsever. However, I haven't been able to find a solution to the problem I will keep looking.

    Edit:

    If you are using sql server you might be able retrieve a list of all the error codes from the database. Not sure if this would work:

    Code:
    'Originally posted by FreeVBCode.com
    Try running
    
    SELECT * FROM sysmessages
    
    off the master table
    I found this which, might explain things.
    Last edited by Nightwalker83; Apr 14th, 2012 at 07:37 PM. Reason: Adding more!
    when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
    If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
    Please consider giving me some rep points if I help you a lot.
    Links to my code examples can now be found on my website: My websites
    Please rate my post if you find it helpful!
    Technology is a dangerous thing in the hands of an idiot! I am that idiot.

  3. #3

    Thread Starter
    New Member
    Join Date
    Apr 2012
    Posts
    3

    Re: Error: "01000: Changed language setting to us_english."

    Yes, it is definitely coming from SQL. It is not really an error, just part of what Microsoft calls a return code of SQL_SUCCESS_WITH_INFO. I don't necessarily care why we get it, or how to make it stop, but I need a way to ignore it.

    I know that I could simply parse the text of the error description, and if it comes back starting with "0100:" I will know that it is an SQL informational message and not an error, but I would like to catch it on the VB Error Number. I was under the impression that informational messages would come back with an error number of 0 (Err.Number), but that is not the case.

    Based on your query (thanks, by the way), I find that SQL says the error number is 5703, which I had already suspected. But does VB also use that number in the Err object?

  4. #4
    PowerPoster Nightwalker83's Avatar
    Join Date
    Dec 2001
    Location
    Adelaide, Australia
    Posts
    13,254

    Re: Error: "01000: Changed language setting to us_english."

    I don't think so, nothing but links referring to sql came up during the search of which I came across this link. I don't know if it will help you resolve the problem or not.
    when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
    If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
    Please consider giving me some rep points if I help you a lot.
    Links to my code examples can now be found on my website: My websites
    Please rate my post if you find it helpful!
    Technology is a dangerous thing in the hands of an idiot! I am that idiot.

  5. #5
    PowerPoster
    Join Date
    Jul 2006
    Location
    Maldon, Essex. UK
    Posts
    6,334

    Re: Error: "01000: Changed language setting to us_english."

    Looking at the Microsoft article here: http://support.microsoft.com/kb/143339 it suggests that the error number is 5703. Is it possible to configure SQLServer to not report these?

  6. #6

    Thread Starter
    New Member
    Join Date
    Apr 2012
    Posts
    3

    Re: Error: "01000: Changed language setting to us_english."

    From everything I have found on the issue, it is not possible to prevent the messages. It is most annoying, because it is a rare occurrence and seems to have no pattern at all. I added the ADO error number to the error message, so hopefully if it happens again the user will report it.

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.