By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

JDBC connectivity with SQL Server

P: n/a
How do I configure the MS-SQLSERVER to accept JDBC connections and
process the sql?
I'm using SQLSERVER 2000 on Windows NT.

Thanks for your help

May 17 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
(so***********@yahoo.com) writes:
How do I configure the MS-SQLSERVER to accept JDBC connections and
process the sql?
I'm using SQLSERVER 2000 on Windows NT.


I don't know JDBC, but I can't see that there should be any particular
configuration needed for SQL Server to accept JDBC connections.

If you have connections problems, it helps if you give more details.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 19 '06 #2

P: n/a


Erland Sommarskog wrote:
(so***********@yahoo.com) writes:
How do I configure the MS-SQLSERVER to accept JDBC connections and
process the sql?
I'm using SQLSERVER 2000 on Windows NT.

I don't know JDBC, but I can't see that there should be any particular
configuration needed for SQL Server to accept JDBC connections.

If you have connections problems, it helps if you give more details.


The only possible issue is that the DBMS needs to accept 'mixed mode'
connection requests (TCP socket-level requests) for most JDBC drivers.
By default MS SQLServer is not configured in this way, but it is easily
done via the setup options.
HTH,
Joe Weinstein at BEA Systems

May 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.