Data Source for Ms Sql2005

Hi all,

We are unable to create a data source with JDBC version 2 type for ms sql2005 server.

We had used the following things to create a data source.

XADS Classname: com.microsoft.sqlserver.jdbc.SQLServerXADataSource

In additional we gave the connection string and user name and password.

Created a driver with sqljdbc.jar.

Is there anything other than that we need to do?

The same connection string is working fine for JDBC version 1 type data source.

Regards,

Prakasu.M