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: Wed, 1 Dec 2010 09:23:31 +0100

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

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