Change in OBDC Error 182 from MYSQL

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Change in OBDC Error 182 from MYSQL

Postby feinstev » Wed Nov 07, 2018 2:57 am

I have Open Office 3.4 (but this problem is happening with 4.1.5 as wll.

I have a MYSQL 5.4 database running on a Windows 2008 File Server and accessed with a Windows 2008 Terminal Server. I use Open Office 3.4 to manage the data in a single ODB database. i also have a number of Forms (ODT files). The OBDC I used is the 5.4 Beta which has worked fine for years.

We are trying to migrate the servers to Windows 16 server. We have the MySQL 8.0 OBDC running on a Windows 2016 Terminal Server connected to the Mysql database that is still on Windows 2008 File Server. With this configuration, I can click on the ODB database and all is good. However, when i click on the ODT files I get the following error from Open Office:

SQL Status: IM003
Error code: 160

Specified driver could not be loaded due to system error 182: (MySQL ODBC 8.0 ANSI Driver,
C:\Program Files (x86)\MySQL\Connector ODBC 8.0\myodbc8a.dll).

I seem to get the same error on both OO 3.4 and OO 4.1.5. I'm assuming that the ODT files somehow don't know about the MYSQL ODBC. Can you give me an idea what the problem can be and what I could do to fix this?

Steve F
MYSQL Connction Error in Base.PNG
MYSQL Connction Error in Base.PNG (7.92 KiB) Viewed 2616 times
Open Office 3.4 running on Windows XP with MYSQL
Posts: 3
Joined: Thu Sep 13, 2012 1:34 am

Re: Change in OBDC Error 182 from MYSQL

Postby Villeroy » Thu Nov 08, 2018 3:25 pm

An odt file does not have any connection to databases. An office document connects through a Base document. The Base document connects to your MySQL database through a setup ODBC connection on your system. The error message indicates that some file does not exist. You can check easily if it exists or not. This is not related to your office suite. You would get the same error when trying to connect any other database tool with that database.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Posts: 29707
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest