I have problems connecting my application to SQL Server 2000. (See the stack trace below).

If I connect the application a SQL Server 2005 (using hibernate 3), it works fine.
If I connect other application (using hibernate 2), to SQL Server 2000, it connects without problem.

Both, SQL Server 2000's and SQL Server 2005's databases, have the same information.

I appreciate any help.

Hibernate version: 3.2.2

Full stack trace of any exception that occurs:
9/04/2008 12:07:38 PM com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
ADVERTENCIA: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1964ca1 -- Acquisition Attempt Failed!!! Clearing
pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of a
llowed acquisition attempts (30). Last acquisition attempt exception:
com.microsoft.sqlserver.jdbc.SQLServerException: La respuesta de inicio de sesi¾n previo de TDS estß incompleta. El serv
idor de destino debe ser SQL Server 2000 o posterior.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.DBComms.Prelogin(Unknown Source)
at com.microsoft.sqlserver.jdbc.DBComms.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:
182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:
171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0Po
oledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)



ADVERTENCIA: Could not obtain connection metadata
java.sql.SQLException: Connections could not be acquired from the underlying database!


Name and version of the database you are using:
SQL Server 2000[/b]

Hi,
this looks like a driver error.
Probably the newer hibernate is using some modern driver functions, unfortunately the latest features on microsoft's driver are not much backwards compatible.
I would advise you to use jTDS driver, we use it in production environment for SQL Server 2000 and it really rocks: never had a problem and very good performance.
http://jtds.sourceforge.net/

We actually use it also for newer SQL server editions.

regards,
Sanne