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


in reply to [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)

For what it's worth, I've had a lot more luck using DBD::Sybase to connect to MSSQL servers than ODBC.

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

Replies are listed 'Best First'.
Re^2: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
by karlgoethebier (Abbot) on Dec 12, 2012 at 21:29 UTC

    ...but as far as i remember, don't you need also FreeTDS when connecting to MSSQL with DBD::Sybase?

    Regards, Karl

    «The Crux of the Biscuit is the Apostrophe»

[reply]

      Indeed you do.

      perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'
[reply]

        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]

In Section Seekers of Perl Wisdom