how connect to MS-SQL directly without ODBC?

Thread view:

Enable EMail Alerts

Start New Thread

mtczx232@yahoo.com - 30 May 2006 08:05 GMT

have Library to connect SQL server directly without ODBC, like .NET do?

Reply to this Message

Philipp Leitner - 30 May 2006 08:25 GMT

mtczx...@yahoo.com wrote:

> have Library to connect SQL server directly without ODBC, like .NET do?

I guess JDBC will do what you want. For MS-SQL you might check out jTDS
(http://jtds.sourceforge.net/). From my experience it is reasonably
stable, even for productive systems, by now.

/philipp

Reply to this Message

Marc E - 30 May 2006 10:45 GMT

For what it's worth, I've been using jTDS for quite some time now in a
heavy-load production system and it performs admirably. I was exceeding heap
memory with impunity when using the stock MS jdbc drivers, and using jTDS
fixed that right away.

> mtczx...@yahoo.com wrote:
>> have Library to connect SQL server directly without ODBC, like .NET do?
[quoted text clipped - 4 lines]
>
> /philipp

Reply to this Message

steen - 30 May 2006 08:27 GMT

> have Library to connect SQL server directly without ODBC, like .NET do?

Just download the appropriate jdbc driver from microsoft.

sql server 2005 : http://msdn.microsoft.com/data/ref/jdbc/
sql server 2000 :
http://www.microsoft.com/downloads/details.aspx?FamilyID=07287B11-0502-461A-B138
-2AA54BFDC03A&displaylang=en

Reply to this Message

jcsnippets.atspace.com - 30 May 2006 15:58 GMT

> have Library to connect SQL server directly without ODBC, like .NET do?

Have a look at the following page:
http://jcsnippets.atspace.com/java/database/connect-to-sql-server-database.h
tml .

It will tell you all you need to know to connect to SQL Server.

Best regards,

JayCee
--
http://jcsnippets.atspace.com/
a collection of source code, tips and tricks

Reply to this Message

how connect to MS-SQL directly without ODBC?

Free Magazines