Getting arithmetic error in ISQL or OSQL

  • Hi! Folks:

    Have you experienced with the following problem?

    c:\>osql -U ehrlidj -P xxxx -S MYSERVER

    1> use master

    2> GO

    Arithmetic overflow occurred.

    Arithmetic overflow occurred.

    Arithmetic overflow occurred.

    Arithmetic overflow occurred.

    Arithmetic overflow occurred.

    Arithmetic overflow occurred.

    1> SELECT * FROM database_info

    2> GO

    Arithmetic overflow occurred.

    Arithmetic overflow occurred.

    Arithmetic overflow occurred.

    Arithmetic overflow occurred.

    Arithmetic overflow occurred.

    Arithmetic overflow occurred.

     owner_code      major_revnum         minor_revnum         last_touch_date

            data_source                                        usage

            script_reference

            note

     --------------- -------------------- -------------------- -----------------------

     MM              2.2-770              5                    2005-10-07 15:45:31.097

            StarterDB                                          NULL

            20051006-SYM2.2-FR8

            NULL

    I have used the DataServer several months already and have never encountered the problem like this. I tried on other MS SQL Server 2000 instances, I did not get error.

    Your help is appreciated!

    Regards,

    -- Peter Lo

     

  • This was removed by the editor as SPAM

  • Have you looked into the application eventlog or the system event log ? If there is nothing there then possibly try re-installing the client tools. Also, even though isql is no longer in use in SQL 2005, does isql give you the same error ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply