Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Boniforti Flavio" <flavio AT piramide.ch>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails
  • Date: Mon, 10 Jan 2011 23:12:17 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page