Skip to Content.
Sympa Menu

freetds - Re: [freetds] freeTDS to access sqlserverExpress

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Duncan Kerr" <DKerr AT nyx.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freeTDS to access sqlserverExpress
  • Date: Mon, 16 Mar 2009 15:48:27 -0000

Freddy

It still fails. However, I have realised a couple of points

1) The documentation says that sqlServer doesn't allow remote connections by
default - this may be stopping me from connecting
2) I have installed a test version of dbArtisan (I know this should connect
ok) - Fails to connect. However this may be because Microsoft have put a '\'
in the server name, and the dbartisian GUI won't allow me to enter a '\'.

Duncan Kerr
NYSE Technologies
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 Frediano Ziglio
> Sent: 16 March 2009 15:14
> To: FreeTDS Development Group
> Subject: Re: [freetds] freeTDS to access sqlserverExpress
>
> 2009/3/16 Duncan Kerr <DKerr AT nyx.com>:
> > Frediano
> >
> > Thanks for your reply.  I have changed my ~/.freetds.conf, and used the
> command below - but it still fails.  Also, if I change the default
> database to xxxx (invalid value) I get the same errors.
> >
> > .freetds.conf
> > --------------
> > [xph]
> >    host = XPH03846
> >    port=1433
> >    tds version=8.0
> >    instance=sqlexpress
> >
> > /home/duncank/freetds-0.82/src/apps
> > lxdevws85 apps% tsql -S xph  -U sa -P root -D dunc2
> > locale is "C"
> > locale charset is "ANSI_X3.4-1968"
> > Default database being set to dunc2
> > 16 There was a problem connecting to the server
> >
> > Duncan Kerr
> > NYSE Technologies
> > t +44 (0)20 7655 7214
> >
>
> Opps... I forgot... remove port...
>
> [xph]
> host = XPH03846
> tds version=8.0
> instance=sqlexpress
>
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

-----------------------------------------------------------------------------------------------------------
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient or have received this e-mail in error, please
advise the sender immediately by reply e-mail and delete this message and any
attachments without retaining a copy. Any unauthorised copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.






Archive powered by MHonArc 2.6.24.

Top of Page