[jboss-user] [JNDI and Naming] - Re: JBOSS 4.2.2 and MS SQL 2005

[mauri11760]

I found the error. File mssql-ds.xml in JBOSS_HOME\docs\examples\jca has the right SQL 2005 class specified but still the SQL 2000 connection-url. 

The SQL Server 2005 JDBC driver has a different URL prefix from the SQL Server 2000 JDBC driver.  The SQL Server 2000 JDBC driver uses an URL prefix of "jdbc:microsoft:sqlserver://", while the SQL Server 2005 JDBC driver uses an URL prefix of "jdbc:sqlserver://".

Maurizio


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4253435#4253435

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4253435