Re: FreeTDS on Debian: connect to MSSQL with ODBC fails

On Wed, Dec 01, 2010 at 09:23:31AM +0100, Boniforti Flavio wrote:
> Ciao Frediano,
> 
> > cfr http://www.freetds.org/userguide/odbcconnattr.htm
> > 
> > Server, not servername in this case...
> 
> so following should be doing it, right?
> 
> [sqlexpress]
> Driver          = FreeTDS
> Port            = 1433
> Description     = MS SQL Server 2005 Express
> Trace           = Yes
> Server          = exchange.piramide.local
> Database        = Piramide_Informatica
> 
> Well, I still get no connection:
> 
> root@ticket:~# isql -v sqlexpress sa
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [37000][unixODBC][FreeTDS][SQL Server]Accesso non riuscito per l'utente
> 'sa'.
> [ISQL]ERROR: Could not SQLConnect
> 
> I noticed there is some more error output, but where am I still doing
> wrong?
> 
> I have this one in my /etc/freetds/freetds.conf also:
> 
> [sqlexpress]
> host = 172.16.16.254
> port = 1433
> tds version = 8.0
> 
> Any help will be appreciated, thanks!
> 
> Flavio Boniforti

Flavio,

Start by using the unixODBC tool "osql" which is a shell script which
tries to discover the correct parameters to pass to isql.

-Peter