Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I installed FreeTDS in CentOS 6 and I can connect from php to remote MS SQL server. However I cannot set up odbc connection so that it shows in list of ODBC connections in OpenOffice apps.

If my server is called [10.0.0.11\myinstance] in freetds.conf what should I put in odbcinst.ini, and what in odbc.ini in order to be able to see this connection availabe for use in OpenOffice Base and Calc?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

I dont' know if it is really correct to ask a question and then answer it later. If it isn't I appologize.

  1. In odbcinst.ini add

    [FREETDS]

    Description = v0.91 with protocol v7.2

    Driver = /usr/lib/libtdsodbc.so

  2. In ~/.odbc.ini add

    [MSSQLTestServer] Driver = FreeTDS Description = MSSQL DB Trace = No Server = 10.0.0.11\myinstance Database = MyDataBaseName

Now I have MSSQLTestServer listed as available source and can use it in OO.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.