http://www.perlmonks.org?node_id=1008603


in reply to Re^2: [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)

Indeed you do.

perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'
  • Comment on Re^3: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)

Replies are listed 'Best First'.
Re^4: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
by perlraj (Acolyte) on Dec 13, 2012 at 09:15 UTC

    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

    [download]

    My odbc.ini file

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

    [download]

    My freetds.conf file

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

    [download]
    $ 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)

    [download]
[reply]
[d/l]
[select]
[reply]

        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)

        [download]
        Thanks
[reply]
[d/l]

In Section Seekers of Perl Wisdom