Skip to Content
avatar image
Former Member

The index 1 is out of range -SQL Server Error

Hi,

I have deployed MS SQL SERVER for JDBC 2005 and JDBC 2000 driver in xMII,

When I ran the insert query, I am getting this error message u201C

com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.u201D

Is there any this issue with SQL drivers? Please help me

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 06:07 PM

    It is a known bug with SQL 2005 JDBC diver when you use escaped single quote to pass the string value of a column or parameter.

    There is a Htofix available. Check this out: http://support.microsoft.com/kb/919568

    Add comment
    10|10000 characters needed characters exceeded