Re^3: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)

[tobyink]

Indeed you do.

[perlraj]

Hi i am still getting some other error, please check at end of the code its not able to find the servername but i have specified it clearly in my odbc.ini file according to the instructions




My odbcinst.ini file

[FreeTDS]
Description = TDS driver (Sysbase/MS SQL)
Driver = /usr/local/freetds/lib/libtdsodbc.so
Setup = /usr/local/freetds/lib/libtdsodbc.so
UsageCount = 1

My odbc.ini file

[SERVER]
Driver = FreeTDS
Description = ODBC connection via FreeTDS
ServerName = SERVER

My freetds.conf file

# A typical Microsoft server
[SERVER]
        host = xxx.xxx.xxx.xxx
        port = 1433
        tds version = 7.2

$ sudo TDSVER=7.2 osql -S SERVER -U devuser2 -P ZqZMNfVP
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)

[karlgoethebier]

Hi its working...

What does that mean? Can you connect and get some result from a query? If so we're done. Very nice.

...but i am still getting some other error

What does that mean? Unspected behaviour? Error message you don't understand? Something else i couldn't guess?

See also Getting answers, How do I post a question effectively? and Is PM a good place to get answers for homework?

Regards, Karl

[perlraj]

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

$ 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)

Thanks