Re: FreeTDS on Debian: connect to MSSQL with ODBC fails
"Boniforti Flavio" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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: [email protected]