(Base Database) always tries to connect ODBC using iODBC, not unixODBC on Mac OSX 10.10 [closed]

asked 2014-11-24 08:19:41 +0200

June gravatar image

updated 2016-03-06 17:48:05 +0200

Alex Kemp gravatar image

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/inst...

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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-03-06 17:48:16.922875