in reply to Re^2: [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)
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:
- No database in your odbc.ini
- 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»
In Section
Seekers of Perl Wisdom