Problem installing MyODBC - looking for sql.h

Problem installing MyODBC - looking for sql.h

am 10.10.2005 18:45:09 von Ryan Stille

I am setting up ColdFusion to access a MySQL 4.1.x database. This
required new MyODBC drivers to be installed on the system for
ColdFusion. After a lot of trial and error, I got it figured out. I
install mysql on the system (using --without-server), then install
MyODBC. Then copy the libmyodbc3.so file to a directory under
ColdFusion, and change ColdFusion's odbc.ini file to reference this new
driver.

I am now trying to do it on a second system, but am getting errors
during the ./configure of MyODBC (3.5.11). This is my configure
statement:

../configure --with-mysql-path=3D/usr/local/mysql \
--without-samples \
--disable-test \
--enable-thread-safe

And this is the resulting output:

....
ODBC DRIVER MANAGER CONFIGURATION - LIBRARIES AND HEADERS
checking for isql... no
checking for unixODBC version... unknown
checking sql.h usability... no
checking sql.h presence... no
checking for sql.h... no
configure: error: Unable to find the unixODBC headers in
'/usr/local//include'


It's complaining about unixODBC headers, maybe specifically the sql.h
file in the second to last line? But I don't have unixODBC installed on
the FIRST system, the one that is working just fine. (ColdFusion has
it's one built in ODBC manager, unixODBC is not necessary.) However
there is a /usr/local/include/sql.h file on that system. I don't know
how it got there. By looking inside the file it appears to be related
to MyODBC 3.5.11.

Just for kicks I copied this file to the second system, but got the same
error when trying to run ./configure.

Any ideas?

-Ryan

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg