At work we use SQL Server 2000 and 2005. At first we used Opta2000 as jdbc connector. Now we use jTDS, which is open source and freely available. I don't know about performance issues, but we don't notice any difference (it's development mainly, and low traffic sites). I've tried to use the Microsoft driver, but that didn't work for some reason.

http://jtds.sourceforge.net/
http://www.inetsoftware.de/products/ (for Opta)

JV

Op 20 jan 2007, om 08:20 heeft Zack Grafton het volgende geschreven:

Hi,

It is possible, there are 2 different methods. The JDBC-ODBC bridge, here's a link on the subject http://java.sun.com/j2se/1.3/ docs/guide/jdbc/getstart/bridge.doc.html

And, depending on your version of SQL Server you could use the one provided by Microsoft,

For SQL Server 2000
http://www.microsoft.com/downloads/details.aspx? FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en

For SQL Server 2005
http://www.microsoft.com/downloads/details.aspx? familyid=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en

If you are using anything older than SQL Server 2000, you should really consider upgrading.


Zack

Andrea Modesto Rossi wrote:
Hi all,

      Need help on this. I'm using Tomcat6 over Debian GNU/Linux. Now
i've a webapps written by JAVA but the database is sql server microsoft
on the windows server.

Is it possible to connect java webapps with sqlserver using jdbc?



Appreciate your help.



Krishna


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to