Re: FreeTDS on Debian: connect to MSSQL with ODBC fails
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
I though you already found the problem... Just to recall /etc/odbcinst.ini: [FreeTDS] Description = Free Sybase & MS SQL Driver Driver = /usr/lib/odbc/libtdsodbc.so Setup = /usr/lib/odbc/libtdsS.so UsageCount = 1 /etc/freetds/freetds.conf: [sqlexpress] host = 172.16.16.254 port = 1433 tds version = 8.0 tsql is working: # tsql -S sqlexpress -U sa locale is "it_CH.UTF-8" locale charset is "UTF-8" Password: 1> 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 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 should work Regards Frediano 2010/12/21 Boniforti Flavio <[email protected]>: > Hello... nobody getting back on this issue? > Thanks... > F. > >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of >> Boniforti Flavio >> Sent: Friday, December 03, 2010 11:56 AM >> To: FreeTDS Development Group >> Subject: Re: [freetds] FreeTDS on Debian: connect to MSSQL >> with ODBC fails >> >> Hello James, >> >> > If you haven't already, make sure you're using the latest >> revision of >> > the osql script, currently 1.11. You can extract it from >> the nightly >> > tarball. >> >> I'm actually using the latest freetds-bin for Debian Sid, which is: >> >> ii freetds-bin 0.82-7 >> >> Now, how may I check for the osql version? >> >> > Run it. If it doesn't work -- i.e. if it doesn't start >> isql and fails >> > to give you a good diagnostic -- run it verbosely: >> > >> > sh -x osql ... >> > >> > Post the output here, and let's see. >> >> I'll be doing this test after I've checked the above. >> >> Kind regards and thank you! >> 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] >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds