Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
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 ( #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


Comment on Re^2: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
Select or Download Code
Replies are listed 'Best First'.
Re^3: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
by karlgoethebier (Vicar) 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
Node Status?
node history
Node Type: note [id://1008496]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (16)
As of 2015-07-07 20:58 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 (93 votes), past polls