Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

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

by karlgoethebier (Curate)
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 drinking their drinks and smoking their pipes about the Monastery: (12)
As of 2014-07-10 10:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (205 votes), past polls