Hi there!
I am using Libre Office Version: 4.3.4.1 on my Mac OSX 10.10 Yosemite.
In Base Database, I would like to connect MS-SQL server using unixODBC DSN.
But it seems the Libre Office tries to connect via iODBC, not unixODBC.
(I never installed iODBC on my Mac.)
Here is what I tried.
Following the below link, I already setup unixODBC, FreeTDS using Homebrew and all the tsql/isql connection tests were fine.
http://www.joecjr.com/2014/07/27/install-and-use-freetds-unixodbc-and-rodbc-or-pyodbc/
After installing, I launched “Database Wizard” from Base database.
And choose ‘ODBC’ from “Connect to an existing database”,
I entered s01, my unixODBC DSN name, to “Name of the ODBC data source on your system” field. (When I clicked ‘Browse’ no registered data source were shown.)
And I typed my unixODBC username and checked Password required.
When I clicked ‘Test Connection’ button and input the password, an error occurred as below.
[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded.
SQL Status: IM002
[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded
Does anyone have an idea to solve this problem?