Bug 86719

Summary:	(Base Database) always tries to connect ODBC using iODBC, not unixODBC on Mac OSX 10.10
Product:	LibreOffice	Reporter:	June <qwertyjune>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	critical	CC:	iplaw67
Priority:	medium
Version:	4.3.4.1 release
Hardware:	All
OS:	macOS (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description June 2014-11-26 01:20:52 UTC

Problem description: 

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.)



Steps to reproduce:
1. 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/

2. 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.

3. 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.


Current behavior:
SQL Status: IM002

[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded


Expected behavior:
Establishing an ODBC connection using unixODBC.

Comment 1 Alex Thurgood 2014-11-26 10:43:04 UTC

The ODBCAdmin tool and corresponding iodbc libraries are no longer present by default, but can still be installed, either from Apple, or now, a more recent app bundle called ODBC_Manager, have you tried that instead of unixODBC ? It could well be that the LO production build is made with the libraries from the ODBCAdmin tool (system dev libs) and therefore not unixODBC dev libs

Comment 2 Alex Thurgood 2014-11-26 16:23:55 UTC

As a cvomparison, I use ODBC Manager, MySQL odbc driver 5.3 and LO 4332 on OSX 10.10 and it works.

Comment 3 Alex Thurgood 2014-11-30 11:59:27 UTC

Setting to needinfo as unixodbc is not required for odbc access, when OS-native solution exists.
Please test with "ODBC Manager.app" and report back

Comment 4 Alex Thurgood 2015-01-03 17:38:57 UTC

Adding self to CC if not already on

Comment 5 Julien Nabet 2015-03-06 21:12:04 UTC

No feedback since more 3 months + Alex's test is ok => let's put this one to WFM.

June: don't hesitate to reopen this tracker if you can still reproduce even after having followed Alex's advice +, if needed, having upgraded to last stable LO version (4.3.6 or brand new 4.4.1)