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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freeTDS to access sqlserverExpress
  • Date: Mon, 16 Mar 2009 15:35:20 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page