in reply to Re^5: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
in thread [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
Hi please look at the last line i am not able to find out the error, its showing the servername as empty string and no further process but i have defined the servername in odbc.ini file which in turn will refer the freetds.conf file for ip address
Thanks$ sudo TDSVER=7.2 osql -S SERVER -U username -P password 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 [SERVER] not found in /home/perlzuser/.odbc.ini reading /usr/local/etc/odbc.ini [SERVER] found in /usr/local/etc/odbc.ini found this section: [SERVER] Driver = FreeTDS Description = ODBC connection via FreeTDS ServerName = SERVER looking for driver for DSN [SERVER] in /usr/local/etc/odbc.ini found driver line: " Driver = FreeTDS" driver "FreeTDS" found for [SERVER] in odbc.ini found driver named "FreeTDS" "FreeTDS" is not an executable file looking for entry named [FreeTDS] in /usr/local/etc/odbcinst.ini found driver line: " Driver = /usr/local/freetds/lib/libtdsodbc.s +o" found driver /usr/local/freetds/lib/libtdsodbc.so for [FreeTDS] in o +dbcinst.ini /usr/local/freetds/lib/libtdsodbc.so is an executable file Using ODBC-Combined strategy DSN [SERVER] has servername "" (from /usr/local/etc/odbc.ini)
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^7: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
by karlgoethebier (Abbot) on Dec 14, 2012 at 12:57 UTC |