On Tue, Jul 19, 2011 at 9:47 AM, Carl Von Stetten
<[email protected]>wrote:

>  If your SQL Server is SERVERNAME\SQLEXPRESS, it's a named instance and is
> running on a non-standard port.
>

Well, this instance isn't necessarily running on a non-standard port.
Someone pointed out in another thread recently that may be the default
instance name that's running on port 1433.

But yes, if it's running on a non-standard port, you'd have to know what
that is. Technically speaking both the MS and jTDS drivers support named
instances but I've never had good luck with them, and when you use the named
instance you're making another round trip to the server to negotiate the
port number anyway.

-- 
Matthew Woodward
[email protected]
http://blog.mattwoodward.com
identi.ca / Twitter: @mpwoodward

Please do not send me proprietary file formats such as Word, PowerPoint,
etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html

-- 
official tag/function reference: http://openbd.org/manual/
 mailing list - http://groups.google.com/group/openbd?hl=en

Reply via email to