tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From J Ilari Moilanen <imoil...@cc.helsinki.fi>
Subject Re: [6.0.16] JNDI, MSSQL, context.xml, server.xml, web.xml, common/lib, DataSources, exceptions, configuration hell, vague tutorials, hidden documentation, lions, tigers, bears, oh my...
Date Sun, 06 Jul 2008 20:59:36 GMT
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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message