Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

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 ( [id://1008496]=note: print w/replies, xml ) Need Help??


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

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

Replies are listed 'Best First'.
Re^3: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
by karlgoethebier (Abbot) on Dec 12, 2012 at 14:11 UTC
    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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1008496]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (5)
As of 2024-03-28 15:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found