I need an easy and complete tutorial for making a MSSQL connection from Ubuntu.
I think I installed FreeTDS and UnixODBC but configurations are very complicated I didn't understand the issue.
I followed this tutorial: https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/wiki/Platform-Installation---Ubuntu
But I failed.
root@hackmachine:~# isql -v example.com XXXXX XXXXXXX [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect root@hackmachine:~#
Before this edit "/etc/odbcinst.ini" and "/etc/odbc.ini" was empty.
I added these lines to /etc/odbcinst.ini :
[FreeTDS] Description = TDS driver (Sybase/MS SQL) Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so CPTimeout = CPReuse = FileUsage = 1
I added these lines to /etc/odbc.ini :
[project_development] Driver = FreeTDS Description = ODBC connection via FreeTDS Trace = No Servername = developer Database = project_development [project_test] Driver = FreeTDS Description = ODBC connection via FreeTDS Trace = No Servername = developer Database = test [project_production] Driver = FreeTDS Description = ODBC connection via FreeTDS Trace = No Servername = production Database = project_production
I didn't make any changes on "/etc/freetds/freetds.conf" since the very beginning.
Still, nothing has changed.