Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: neutral (herse.apache.org: local policy)
Mime-Version: 1.0 (Apple Message framework v752.2)
In-Reply-To: <45B1C2BA.3040909@gmail.com>
References: <1169192566.3756.3.camel@localhost> <45B1C2BA.3040909@gmail.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <9445CE7D-8DB3-4497-B77E-F461D02B887C@orange.nl>
Content-Transfer-Encoding: 7bit
From: JV <jv832@orange.nl>
Subject: Re: Tomcat and jdbc over MS SQL Server
Date: Sat, 20 Jan 2007 12:17:36 +0100
To: "Tomcat Users List" <users@tomcat.apache.org>

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: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> 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
>
>


---------------------------------------------------------------------
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