Re: freeTDS to access sqlserverExpress

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