Re: freeTDS to access sqlserverExpress

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: [email protected] [mailto:freetds-
> [email protected]] 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 <[email protected]>:
> > 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
> [email protected]
> 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.