> have you ever used the jdbc driver for sql server? There is a > project was > developed with servlet and dbAnywhere and sql server ,but > we decided to > change dbanywhere to jdbc driver for sql server from > Microsoft. The problem > that exist is, the stored procedure doesn't work properly in > jdbc driver. I > get error such as "[Microsoft][SQLServer 2000 Driver for > JDBC]No ResultSet > set was produced." .I appreciate any help in advance.
Well, first question is which version of MS SQL Server you are using? If you are using MS SQL Server 2000 (as your choice of JDBC driver suggest) in that case make sure that you enable JTA support on MS SQL Server side. Does not matter if you want to run SELECT statements and nothing else. To do that find a folder: c:\program files\microsoft sql server 2000 driver for jdbc\sqlserver jta and take a file instjdbc.sql. You must to run this file against your SQL server. Second, you must a DLL sqljdbc.dll somewhere in path, for example $WINNT\SYSTEM32. Make sure that you restart MS Distributed Transaction Coordinator (DTC) service on MS SQL Server machine and your application server as well. Keep in mind that this JDBC driver will work *only* with MS SQL Server 2000. If you have any previous version of MS SQL Server, you must purchase a JDBC driver. There is no other free working JDBC driver, as far as I know. I hope that this will work for you. --Srdjan -------------------- Srdjan Pantic ASU Solutions, Inc. 3333 Bowers Ave, # 160 Santa Clara, CA 95054 phone (408) 654 7827 fax (408) 654 7820 =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
