We are currently using IDM 3.0.1 and JDBC driver 2.1. First we configured
JDBC driver with MSSQL 2000 version and it is working fine. When we want
to connect to MSSQL 2005, it is showing following error and also we are
using a database instance in 2005 version.

<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="0"
jdbc:sql-state="HY000" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:message>[Microsoft][SQLServer 2000 Driver for JDBC]Unable to
connect. Invalid URL.</jdbc:message>
</jdbc:exception>


Is the authentication context bellow correct ? for MSSQL2005 version
"sql2005" as database instance

jdbc:microsoft:sqlserver://IPADDRESS:1433sql2005;DatabaseName=idm

Are the MSSQL ODBC jar files needs to be modified, when we shift from
MSSQL2000 to MSSQL1005 ?

thanks for your time and reply.