Tomcat SQL Server Integration Question

[tomas_bar <ba...@gmail.com>]

Hi,

I'm using Tomcat for a Java web application (created with GWT).
The application needs to access a server-side database. Initially my choice
was MySQL but for reasons beyond my control it will have to be SQL Server.
Is it problematic to use SQL Server from Tomcat?
I mean, as long as I have a ODBC driver for my java program to communicate
with the database, it makes no difference to Tomcat if the database is MySQL
or SQL Server?
Or are things trickier using SQL Server?

Thanks a lot.

Tomas Bar
-- 
View this message in context: http://www.nabble.com/Tomcat-SQL-Server-Integration-Question-tp23447252p23447252.html
Sent from the Tomcat - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org

RE: Tomcat SQL Server Integration Question

["Caldarale, Charles R" <Ch...@unisys.com>]

> From: tomas_bar [mailto:bartomas@gmail.com]
> Subject: Tomcat SQL Server Integration Question
> 
> Is it problematic to use SQL Server from Tomcat?

No.

> I mean, as long as I have a ODBC driver for my java program to
> communicate with the database

Never, never, never use ODBC.  You need a JDBC driver (sqljdbc.jar, for MS SQL Server), not ODBC.

You didn't bother to tell us your Tomcat level, but for the current one, the doc is here:
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html

 - Chuck


THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org