Re: tomcat and jdbc connector

2007-10-01 Thread David Smith
I doubt this is tomcat's fault in any way given the code snippet is pure java and doesn't access the api except for the success message. Can you verify the Ubuntu machine really has access to the MS SQL server (no firewall on either system)? Also I'm guessing you also verified the version of

Re: tomcat and jdbc connector

2007-10-01 Thread Ognjen Blagojevic
Hi, loredana loredana wrote: "javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not running." Can you try to do the same outside Tomcat, in a main method of a test Java class? It doesn't look like a T

tomcat and jdbc connector

2007-10-01 Thread loredana loredana
Hi, I have a small jsp file that test a connection to an sql server 2000 database using ms jdbc drivers. the file is pretty basic: DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); Connection connection = DriverManager.getConnection("jdbc:microsoft:sqlse