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:05:06 -0000

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

> -----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 14:35
> To: FreeTDS Development Group
> Subject: Re: [freetds] freeTDS to access sqlserverExpress
>
> 2009/3/16 Duncan Kerr <DKerr AT nyx.com>:
> > I'm trying to connect to sqlServer Express 2005 with freeTDS from 64 bit
> > linux.
> >
> > I have successfully built the libraries and test programs by disabling
> > the GUI compilation.
> >
> >
> >
> > I am running a database on sqlServer express which is labelled "local
> > instance" & is named
> >
> >
> >
> > XPH846\sqlexpress (my pc hostname is xph03846)
> >
> >
> >
> > I am trying to connect from linux like this
> >
> >
> >
> > tsql -S xph03846\\sqlexpress -U sa -P root -D dunc2
> >
>
> first remember that unix is usually case sensitive so XPH03846 and
> xph03846 can mean different entities. Server point to section in
> freetds.conf, is better to avoid specifying instance here and put in
> freetds.conf, ie
>
> tsql -S xph -U sa -P root -D dunc2
>
> >
> >
> > I have the following entries in ~/.freetds.conf
> >
> >
> >
> > [global]
> >
> >        tds version = 4.2
> >
> >
> >
> > [SQLEXPRESS]
> >
> >        host = XPH03846
> >
> >        port = 1433
> >
> >        tds version = 7.0
> >
> >
> >
> > [XPH03846\SQLEXPRESS]
> >
> >        host = XPH03846
> >
> >        port = 1433
> >
> >        tds version = 7.0
> >
>
> Here
>
> [xph]
> host = XPH03846
> port=1433
> tds version=8.0
> instance=sqlexpress
>
> >
> >
> > But I can't connect - get error like this
> >
> >
> >
> > locale is "C"
> >
> > locale charset is "ANSI_X3.4-1968"
> >
> > Default database being set to dunc2
> >
> > 15 There was a problem connecting to the server
> >
> >
> >
> > However, on my PC I can connect like this
> >
> >
> >
> > cd c:\program files\microsoft sql server\90\tools\binn
> >
> > sqlcmd -S xph03846\sqlexpress -U sa -P root -d dunc2
> >
> > 1>
> >
> >
> >
> > Does anyone have any ideas why I can't connect?
> >
> >
> >
> > Duncan Kerr
> >
>
> Regards
> Frediano Ziglio
> _______________________________________________
> 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