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