FreeTDS Development Group

["Boniforti Flavio" <flavio AT piramide.ch>]

Hello Frediano, hello list.

Sorrz for getting back to this so late...

> Just to recall

The configs are still as zou wrote...

> tsql is working:
> 
> # tsql -S sqlexpress -U sa
> locale is "it_CH.UTF-8"
> locale charset is "UTF-8"
> Password:
> 1>

Yes it is

> You can go through steps:
> 
> 1: odbc.ini that points to freetds.conf
> 
> /etc/odbc.ini:
> 
> [sqlexpress]
> Servername = sqlexpress
> Driver = FreeTDS
> 
> # isql -v sqlexpress sa
> 
> should work

It does *not* work:

root@ticket:~# cat /etc/odbc.ini
[sqlexpress]
Servername = sqlexpress
Driver = FreeTDS

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

> 2: move freetds.conf entries to odbc.ini
> 
> /etc/odbc.ini:
> 
> [sqlexpress]
> Server = 172.16.16.254
> Port = 1433
> TDS_Version = 8.0
> Driver = FreeTDS
> 
> # isql -v sqlexpress sa

This too is not working:

root@ticket:~# cat /etc/odbc.ini
[sqlexpress]
Server = 172.16.16.254
Port = 1433
TDS_Version = 8.0
Driver = FreeTDS

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

Anz help will be appreciated...

Thanks,
Flavio Boniforti

PIRAMIDE INFORMATICA SAGL
Via Ballerini 21
6600 Locarno
Switzerland
Phone: +41 91 751 68 81
Fax: +41 91 751 69 14
URL: http://www.piramide.ch
E-mail: flavio AT piramide.ch