[fdo-users] Problem building FDO 3.3 with MySQL/ODBC on CentOS 5

[larry white]

Andy,


This is the error I mentioned in a posting a few days ago.

There are missing LD_LIBRARY references for 'libodbcinst' in the
UnitTest Makefile.am

You have to modify Makefile.am (and/or Makefile after initial compilation).

In particular, in the 'UnitTestOdbc_LDADD' section you need to add a
couple of lines (both may not be necessary, but it works).

At (or around) line 154 and line 191, you'll find references to libodbc:
 -lodbc \

insert the additional following line
-lodbcinst \

Compilation should be successful after making that change; Unit Tests
will run; and the provider will install and function properly (eg., I'm
been using MySQL driver as the primary provider for some current
testing. However, I have not used the ODBC provider.)




-- larry white
Sr Systems Analyst
neomatix.ca





Andy Morsell wrote:
> I'm trying to build FDO 3.3 on CentOS 5.  I have been able to build with
> the core providers without MySQL / ODBC support, but when I attempt to
> build with that provider, it fails.  It fails in the same place when
> using the FDO build_linux script with the --w rdbms switch, or when
> using the build_linux script separately from the GenericRdbms
> directory.  It does not fail if running the FDO build_linux script with
> all default settings, but the FDO ODBC files are never created.  I do
> have the MySQL client and developer libraries installed and correctly
> referenced via the FDOMYSQL environment variable.  I also have the
> unixodbc libraries installed.  Below is the last few lines of the
> build.  Any insight on where to go next would be appreciated.  Thank you.
> 
> 
> ../Rdbi/.libs/librdbi.a ../Util/.libs/libutil.a /usr/lib/libodbc.so -ldl
> -lpthread -lz  -Wl,--rpath -Wl,/usr/local/fdo-3.3.0/lib
> 
> ../ODBC/.libs/libFdoRdbmsODBC.a(FdoRdbmsOdbcConnection.o): In function
> `FdoRdbmsOdbcConnection::GetSchemaNameFromDsn()':
> 
> FdoRdbmsOdbcConnection.cpp:(.text+0x1c8f): undefined reference to
> `SQLGetPrivateProfileString'
> collect2: ld returned 1 exit status
> make[3]: *** [UnitTestOdbc] Error 1
> make[3]: Leaving directory
> `/Software/FDO/OpenSource_FDO/Providers/GenericRdbms/Src/UnitTest'
> make[2]: *** [all-recursive] Error 1
> make[2]: Leaving directory
> `/Software/FDO/OpenSource_FDO/Providers/GenericRdbms/Src/UnitTest'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory
> `/Software/FDO/OpenSource_FDO/Providers/GenericRdbms/Src'
> make: *** [all-recursive] Error 1
> 
> Andy Morsell, P.E.
> Spatial Integrators, Inc.
> _http://www.SpatialGIS.com_
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users