[freetds] freeTDS to access sqlserverExpress
DKerr at nyx.com
Thu Mar 19 12:06:32 EDT 2009
t +44 (0)20 7655 7214
> -----Original Message-----
> From: freetds-bounces at lists.ibiblio.org [mailto:freetds-
> bounces at lists.ibiblio.org] On Behalf Of James K. Lowden
> Sent: 19 March 2009 13:21
> To: FreeTDS Development Group
> Subject: Re: [freetds] freeTDS to access sqlserverExpress
> Duncan Kerr wrote:
> > it returns null as you suggested. Does that
> > mean I can't use the instance option in .freetds.conf, or do I need
> > do something else to point to a NULL server?
> > lxdevws85 apps% tsql -S mcdb -U FUENV4\\fuadmin -P ful1ffe -Lv
> > locale is "C"
> > locale charset is "ANSI_X3.4-1968"
> > 1> select serverproperty('InstanceName')
> > 2> go
> > NULL
> > (1 row affected)
> Before there were Instances, we all used Port. That's still a safe
> if you know the port, you might as well use it.
> Technically, you could use the name of the default instance instead.
> server should return the name of all instances, including the default,
> using the tsql command I provided (assuming a recent snapshot). Or
> could ask your friendly DBA.
> But I wouldn't bother. If you know the port, why not use it? It's
> and explicit, and it's not going to change.
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
More information about the FreeTDS