I do have configured MyODBC-3.51/unixodbc-2.2.1 on a Mandrake 8.0
(recently updated) distrib.
I think it should not be a problem to install it on 8.2



Start to install unixODBC:
I managed to build unixODBC without the hard-to-compile GUI (the GUI
requires too much libs for my taste...)
I achieved this with --disable-gui option of configure

make / make install should work well



For MyODBC :
To make configure work, you'll probably have to set options
--with-mysql-libs=<path to libmysqlclient*>  --with-mysql-includes=<path
to mysql client includes> --with-unixODBC=<path to unixODBC directory>

make / make install should work well


Run-time conf :
It was a bit difficult to configure odbc without the gui, but the
following small conf works :

-------------------
/etc/odbcinst.ini :
-------------------
[MyODBC]
Description             = MySQL ODBC 3.51 Driver
Driver          = /usr/local/lib/libmyodbc3.so
Setup           = /usr/local/lib/libodbcmyS.so
Threading               = 3
FileUsage               = 1


-------------
/etc/odbc.ini
-------------
[ODBC Data Sources]
name_of_your_source = a line to describe this source

[name_of_your_source]
Driver          = MyODBC
Description     = a description again
Server          = localhost
Port            = 3306
User            = login
Password        = pass
Database        = MYSQL_DATABASE
Option          = < see the manual, I don't remember ... >
Socket          = /var/lib/mysql/mysql.sock



All of these libs compiled fine with gcc-3.
I'm accessing the ODBC system through the C++ lib OTL, and it works very
well. To use it, my ODBC connection string is simply :
"DSN=name_of_my_source"


Have fun !

Mathieu 





On Fri, 2002-07-05 at 17:48, Bas Mooyman wrote:
> Hi all,
> 
> I am trying to couple Openoffice.org to MySQL using ODBC. Does anybody
> have an odbc driver functioning on a mandrake 8.2 linux machine? If so
> please tell me how to do it.
> 
> Kind regards,
> 
> Bas Mooyman.
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to