I have done some tests, and stated that the problem is port number... I don't know how much compatible is really MS driver, but appear that are working for simple tasks...
Best regards, Edson Richter ----- Original Message ----- From: "Dmitri Colebatch" <[EMAIL PROTECTED]> To: "David Cao" <[EMAIL PROTECTED]> Cc: "JBOSS Mail List" <[EMAIL PROTECTED]> Sent: Wednesday, November 14, 2001 9:05 PM Subject: RE: [JBoss-user] MS SQL JDBC Driver problem > 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;SelectMet hod=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 > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
