Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

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

by karlgoethebier (Vicar)
on Dec 12, 2012 at 10:24 UTC ( #1008480=note: print w/ replies, xml ) Need Help??


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

FreeTDS comes with some useful tools for debugging. Please take a look at Troubleshooting ODBC connections.

Regards, Karl

«The Crux of the Biscuit is the Apostrophe»


Comment on Re: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
Re^2: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
by perlraj (Acolyte) on Dec 12, 2012 at 12:18 UTC

    Hi Thanks a lot

    My odbc.ini

    [SQLServer] Driver=/usr/local/freetds/lib/libtdsodbc.so Description=SQL Server DSN created during installation Server=10.101.11.87 Port=1433 User= Password= Language= Database= Logging=0 LogFile= QuotedId=Yes AnsiNPW=Yes Mars_Connection=No

    But I am getting the error when i execute the command

    $ osql -S servername -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 [10.101.11.87] not found in /home/perlzuser/.odbc.ini reading /usr/local/etc/odbc.ini [10.101.11.87] found in /usr/local/etc/odbc.ini found this section: looking for driver for DSN [10.101.11.87] in /usr/local/etc/odbc.ini no driver mentioned for [10.101.11.87] in odbc.ini looking for driver for DSN [default] in /usr/local/etc/odbc.ini osql: error: no driver found for [10.101.11.87] in odbc.ini
      osql: error: no driver found for [10.101.11.87] in odbc.ini

      ...something is wrong with your configuration ;-)

      I don't use FreeTDS, it's new to me - but i've just read the manual a bit and by search i found this:

      /etc $ cat freetds.conf [SERVER] host = 192.168.0.10 port = 1433 tds version = 7.0 /etc$ cat odbcinst.ini [FreeTDS] Description = TDS driver (Sybase/MS SQL) Driver = /usr/lib/odbc/libtdsodbc.so Setup = /usr/lib/odbc/libtdsS.so CPTimeout = CPReuse = FileUsage = 1 /etc$ cat odbc.ini [SERVER] Driver = FreeTDS Description = ODBC connection via FreeTDS Trace = No Servername = SERVER Database = DATABASE

      Differences i can see:

      1. No database in your odbc.ini
      2. In your odbcinst.ini Setup is the same as Driver (don't know if this matters)

      Not very much, but perhaps it helps a bit to get ahead.

      Update: The FreeTSD Archives

      Regards, Karl

      «The Crux of the Biscuit is the Apostrophe»

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1008480]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (13)
As of 2015-07-07 13:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (88 votes), past polls