crazy sql exception! code works on other machine but doesn't work on mine

[Vinayachandra Acharya]

I am getting a SQL Exception while calling a stored procedure. But with the same code on the other machine it runs properly without any exceptions!!! I am using SQL Server and i am using jdbcdbc bridge driver for the connection. What may be the problem in my system? I am using JBoss Application Server I am puzzled by the fact that same code on same version of jboss works well with this stored procedure... There is no problem with other stored procedure i.e i am able to conect to the database and can execute other stored procedure :-(

2004-11-22 15:04:07,607 INFO [STDOUT] SQLException in STT_Beans.STT_EntityBeans.SearchListEntity.loadTeamMembersRequests(): [Microsoft][ODBC SQL Server Driver][SQL Server]vijayasekar.subramaniam 2004-11-22 15:04:07,617 ERROR [STDERR] java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]vijayasekar.subramaniam 2004-11-22 15:04:07,617 ERROR [STDERR] at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6106) 2004-11-22 15:04:07,627 ERROR [STDERR] at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6263)

[edited to disable smilies]
[ November 23, 2004: Message edited by: Jeanne Boyarsky ]

[Ernest Friedman-Hill]

Perhaps you're using a different version of the JDBC-ODBC bridge on the two machines.

[Vinayachandra Acharya]

Thanks for the reply....
But how to determine the version of the JDBC-ODBC bridge and how upgrade it?

[Jeanne Boyarsky]

The bridge is the jar/zip file that you put in the classpath when you compile and run.

[Vinayachandra Acharya]

I have started using JDBC drivers instead of Bridge.....
problem is resolved now