[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    MyODBC, unixODBC, MySQL, and Mac OS X
From:       "Paul J. Teeter" <paul.teeter () hotellocators ! com>
Date:       2003-02-25 21:41:17
[Download RAW message or body]

I'm trying to compile and install either 2.50.39 or 3.50.01 MyODBC on 
Mac OS X 10.2.4.

I'm using the Entropy release of MySQL - 
http://www.entropy.ch/software/macosx/mysql/ - so version 3.23.55.

I'm also using version 2.2.4 of unixODBC and version 20020606 of 
dlcompat.

MyODBC 2.50.39

- configure execution fails when verifying the unixODBC header files
- here's the configure execution statement:

./configure --host=powerpc-apple --with-mysql-libs=/usr/local/mysql/lib 
--with-unixODBC=/usr/local

- the resulting error is:

checking for the mysql client libraries... /usr/local/mysql/lib
checking for mysql_real_query in -lmysqlclient... yes
checking for mysql include files in ... yes
checking for sql.h... no
configure: error: Unable to find the unixODBC headers in 
/usr/local/include

- this error occurs, despite the existence of the unixODBC header files 
in /usr/local/include:

root@dev-server -> /usr/local/include # ls -la
total 368
drwxrwxr-x  11 root  wheel    374 Feb 25 09:51 .
drwxrwxr-x  11 root  wheel    374 Feb 24 14:47 ..
-rw-r--r--   1 root  wheel   5511 Feb 25 09:51 autotest.h
-rw-r--r--   1 root  wheel   2034 Feb 24 11:20 dlfcn.h
-rw-r--r--   1 root  wheel   8595 Feb 25 09:51 odbcinst.h
-rw-r--r--   1 root  wheel   8581 Feb 25 09:51 odbcinstext.h
-rw-r--r--   1 root  wheel  28431 Feb 25 09:51 sql.h
-rw-r--r--   1 root  wheel  78370 Feb 25 09:51 sqlext.h
-rw-r--r--   1 root  wheel  11062 Feb 25 09:51 sqltypes.h
-rw-r--r--   1 root  wheel  21660 Feb 25 09:51 sqlucode.h
-rw-r--r--   1 root  wheel   2591 Feb 25 09:51 uodbc_stats.h

I've tried ktrace'ing the configure execution, nothing much useful 
there.  Can anyone tell me why this refuses to work?


MyODBC 3.50.01 - source code

- configure and make seem to work fine, but when I go to create 
libmyodbc3.so
- here's my configure statement:

./configure --build=powerpc-apple-darwin6.4 --with-unixODBC=/usr/local 
--with-mysql-libs=/usr/local/mysql/lib

- I'm trying to create the .so like this:

cc -bundle -o libmyodbc.so driver/catalog.o driver/connect.o 
driver/dll.o driver/execute.o driver/info.o driver/myodbc3.o 
driver/options.o driver/prepare.o driver/results.o driver/transact.o 
driver/utility.o driver/misc.o -L/usr/local/mysql/lib -lmysqlclient -lz 
-L/usr/local/lib -lodbc

-and the resulting error is this:

ld: Undefined symbols:
_my_SQLFreeStmt
_set_error
_set_conn_error
_set_dbc_error
_translate_error
_check_if_positioned_cursor_exists
_my_pos_delete
_my_pos_update
_set_stmt_error
_myodbc_sqlstate2_init
_set_env_error
_set_handle_error
_set_current_cursor_data

Which object files are missing?  Any thoughts on why this error occurs?


MyODBC 3.50.01 - binary installation

- similar to installing from source code
- I should be able to create libmyodbc3.so from the acquired 
libmyodbc3-3.51.01.dylib using:

cc -bundle -o libmyodbc3.so libmyodbc3-3.51.05.dylib

- maybe not...here's the error I get:

ld: warning can't open dynamic library: 
/Users/mysqldev/myvenu/local/mysql/lib/mysql/libmysqlclient.10.dylib 
(checking for undefined symbols may be affected) (No such file or 
directory, errno = 2)
ld: warning can't open dynamic library: 
/Users/mysqldev/myvenu/local/mysql/lib/mysql/libmysqlclient_r.10.dylib 
(checking for undefined symbols may be affected) (No such file or 
directory, errno = 2)

Am I using the correct cc command and options?  Anyone have any 
thoughts about this?



Your help would be much appreciated.  Thanks.

Paul Teeter


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

To unsubscribe, e-mail <myodbc-unsubscribe@lists.mysql.com>
To unsubscribe from Yahoo! Groups version, e-mail myodbc-unsubscribe@yahoogroups.com

[prev in list] [next in list] [prev in thread] [next in thread]