sorry I missed the start of this, I'm not sure if any of this will help, but I'll offer it anyway.
I recently had to configure castor to work with SQL server, and face similar issues that you would be facing here. One problem I had was not specifying the port - and from the looks of the error, you're not even getting past first base. What config are you using for the ms driver? fwiw, this is what I use for castor: jdbc:microsoft:sqlserver://database.machine:1433;DatabaseName=test;SelectMethod=cursor also, the following newsgroup was quite useful I found: http://www.microsoft.com/sql/downloads/2000/jdbc.asp the newsgroup microsoft.public.sqlserver.jdbcdriver on msnews.microsoft.com is a good source of information on this. again - not sure if this is going to help, as I've come in a bit late, but anyway. cheers dim On Wed, 14 Nov 2001, David Cao wrote: > Edson, > > Thanks, enclosed with error with SQL Server from two driver: > > ***For Jdbc-Odbc bridge, error with jboss-2.4.x-tomcat-3.2.3 when using > MS Sql > Server: > can't load the entity, find works, just can't load, the error message > is: > java.rmi.ServerException: Load failed; nested exception is: > java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid > Descriptor Index > > > ***And for MS JDBC driver, error when connect use a samal test program: > java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error > establishing socket. > java.lang.Throwable(java.lang.String) > java.lang.Exception(java.lang.String) > java.sql.SQLException(java.lang.String, java.lang.String) > java.sql.SQLException > com.microsoft.jdbc.base.BaseExceptions.getException(java.sql.SQLExceptio > n, int, int, java.lang.String) > java.sql.SQLException > com.microsoft.jdbc.base.BaseExceptions.getException(java.sql.SQLExceptio > n, int, java.lang.String) > com.microsoft.jdbc.sqlserver.tds.TDSConnection(java.lang.String, > java.lang.String, boolean, com.microsoft.jdbc.base.BaseExceptions) > void com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open() > com.microsoft.jdbc.base.BaseImplConnection > com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(boolean, > int) > void > com.microsoft.jdbc.base.BaseConnection.open(com.microsoft.jdbc.base.Base > ConnectionProperties, com.microsoft.jdbc.base.BaseExceptions, > com.microsoft.util.UtilDebug) > java.sql.Connection > com.microsoft.jdbc.base.BaseDriver.connect(java.lang.String, > java.util.Properties) > java.sql.Connection > java.sql.DriverManager.getConnection(java.lang.String, > java.util.Properties, java.lang.ClassLoader) > java.sql.Connection > java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, > java.lang.String) > java.sql.Connection com.ctbs.jdbc.test.DBAccess.connect() > java.sql.ResultSet > com.ctbs.jdbc.test.DBAccess.executeQuery(java.lang.String) > void com.ctbs.jdbc.test.DBAccess.main(java.lang.String []) > > -----Original Message----- > From: Edson Carlos Ericksson Richter [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 14, 2001 10:58 AM > To: David Cao; JBOSS Mail List > Subject: Re: [JBoss-user] MS SQL JDBC Driver problem > > > Hummm. Trying to cut-off MSSQL is not a idea??? > Well, JDBC Driver for SQL2K still beta... > > And JDBC-ODBC bridge should not work because is not thread safe... > > I'll try something here... But have you not any message error or > something??? > > > Edson Richter > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
