0

I am trying to connect a MSSQL database from a Ubuntu 14.04 machine. I am using FreeTDS to connect, by following this tutorial

[http://guywyant.info/log/206/connecting-to-ms-sql-server-from-ubuntu/][1]

I'm stuck with the final stage, after giving the following command :

isql -v MSSQL devuser 'devpass'

Ubuntu is giving me the following error :

[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

How can I overcome this issue and connect the MSSQL database?

Update 1 My problem is half solved now. Driver has been found now. At this moment it is showing the following error.

[IM002][unixODBC][Driver Manager]Data source name not found
[IM003][unixODBC][Driver Manager]Host name unknown
[ISQL]ERROR: Could not SQLConnect
tuxtu
  • 3,165
  • 9
  • 28
  • 43
  • Thanks for your comment, but my problem is different. My problem is that, it is showing "Data source name not found". – tuxtu Oct 21 '15 at 15:59
  • OK, then, could you post the content of your `odbc.ini` and `odbcinst.ini files`? The problem lies there. – Marc Vanhoomissen Oct 21 '15 at 16:37
  • What did you change to achieve Update1? In my experience, the message `Data source not found` can come from the fact that the file `odbc.ini` is not found or that some parameters in there are wrong. I once had such a message and I found out that the problem was in an inccorrect uid/password combination (it was to connect to MySQL, however). – Marc Vanhoomissen Oct 22 '15 at 10:27
  • I just reinstall everything from the beginning and go through every step of the tutorial very carefully. You are right I also think that, problem lies in the odbc.ini and odbcinst.ini files. – tuxtu Oct 23 '15 at 00:22
  • May i suggest to turn on the trace facility of unixODBC. this can be achieved by adding the following to your odbcinst.ini: `[ODBC] Trace = yes TraceFile = trace_file_path` – Marc Vanhoomissen Oct 23 '15 at 10:00

0 Answers0