The index 1 is out of range -SQL Server Error

[subramaniyan_thangavel]

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

[Former Member · Accepted solution]

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