RE: Connect to user instance via JDBC?
- From: evanba@xxxxxxxxxxxxxxxxxxxx (Evan T. Basalik (MSFT))
- Date: Mon, 13 Mar 2006 13:31:25 GMT
Unfortunately, it is not possible to connect to a user instance via JDBC. User instances only allow named pipe connections
(http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp) and the SQL Server 2005 JDBC driver requires TCP/IP.
Evan
--------------------
Thread-Topic: Connect to user instance via JDBC?
thread-index: AcY9vpq6F6K7T89ER+yaFglb2QZJKA==
From: =?Utf-8?B?TmF0aGFu?= <Nathan@xxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Connect to user instance via JDBC?
Date: Wed, 1 Mar 2006 22:00:27 -0800
Is it possible to connect to a user instance of a SQL Server 2005 Express
database via the JDBC driver?
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
.
- Prev by Date: Re: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- Next by Date: Re: JDBC connection for SQL Server 7.0
- Previous by thread: Re: Connection Pooling / Caching in java
- Next by thread: Re: How to change to using direct vs. cursor for queries within connec
- Index(es):