<?xml version="1.0" encoding="windows-1252"?>
<node id="1008496" title="Re^2: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)" created="2012-12-12 07:18:33" updated="2012-12-12 07:18:33">
<type id="11">
note</type>
<author id="993957">
perlraj</author>
<data>
<field name="doctext">
&lt;p&gt;Hi Thanks a lot&lt;/p&gt;
&lt;p&gt;My odbc.ini&lt;/p&gt;
&lt;code&gt;
[SQLServer]
Driver=/usr/local/freetds/lib/libtdsodbc.so
Description=SQL Server DSN created during installation
Server=10.101.11.87
Port=1433
User=
Password=
Language=
Database=
Logging=0
LogFile=
QuotedId=Yes
AnsiNPW=Yes
Mars_Connection=No
&lt;/code&gt;

&lt;p&gt;But I am getting the error when i execute the command&lt;/p&gt;
&lt;code&gt;$ osql -S servername -U username -P password&lt;/code&gt;

&lt;code&gt;checking shared odbc libraries linked to isql for default directories...
	trying /usr ... no
	trying /loc ... no
	trying /tmp/sql.log ... no
	trying /home ... no
	trying /.odbc.ini ... no
	trying /usr/local/etc ... OK
checking odbc.ini files
	reading /home/perlzuser/.odbc.ini
[10.101.11.87] not found in /home/perlzuser/.odbc.ini
	reading /usr/local/etc/odbc.ini
[10.101.11.87] found in /usr/local/etc/odbc.ini
found this section:
looking for driver for DSN [10.101.11.87] in /usr/local/etc/odbc.ini
  no driver mentioned for [10.101.11.87] in odbc.ini
looking for driver for DSN [default] in /usr/local/etc/odbc.ini
osql: error: no driver found for [10.101.11.87] in odbc.ini
&lt;/code&gt;</field>
<field name="root_node">
1008467</field>
<field name="parent_node">
1008480</field>
</data>
</node>
