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

[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

[karlgoethebier]

The only difference i can see between your configuration and the example from the ubuntu site is that you miss the value for the Database key in the server section of your odbci.ini. I mentioned this already. As far as i understood the manual you must provide a value for that key (...yes, i'm skating on thin ice).

Please keep in mind that this is not a perl issue. Read the manual again - with patience. This is something that i can't do for you.

See also:

There are a few ways to use Perl to connect to a SQL Server using FreeTDS.The recommended choice is DBD::Sybase from Michael Peppler. Despite the name it works for any Sybase or Microsoft SQL Server...

tobyink already mentioned this, see above.

Regards, Karl