You have already solved the problems you had but just one more thing to add. You had problems with different Tomcat version but from the quote below I see that you also had problems with different MS sql Server versions as well... For example I have these setting in production use for SQL server 2000 driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver url: jdbc:microsoft:sqlserver://hostname:1433;DatabaseName=dbname;SelectMethod=Cursor
BUT when I use SQL Server 2005 the following works driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver url: jdbc:sqlserver://hostname:1433;DatabaseName=dbnam;SelectMethod=Cursor So things have changed there as well and the examples you found form the net were probably correct but for different SQL server version. Just thought that was worth mentioning... Regards, Ilari On Sun, 6 Jul 2008, Jason Cipriani wrote: > * The driver name is "com.microsoft.sqlserver.jdbc.SQLServerDriver"! > Some examples on the internet have the "sqlserver" and "jdbc" part > reversed! (That was a big problem in my last attempt -- it is NOT > com.microsoft.jdbc.sqlserver.SQLServerDriver). > * I don't think it causes any problems but you do NOT need to use > "jdbc:microsoft:sqlserver", leaving out the "microsoft" works just > fine. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
