On Monday 12 March 2001 19:55, you wrote:
> Hello All,
>
> I am trying to compile up a version of the unixODBC gui manager, but am
> having much problems.
>
> It seems that it is not finding the qt 2 libraries. I have talked to the
> developer and he says that we need to have qt2.2 or greater. I know that
> 2.2.4 is installed by the libqt2 rpm, but the configurer does not seem to
> find it.
>
try: ./configure --with-qt-dir=/usr/lib/qt2
> I alsohave had no luck in taking out the default installed qt libraries so
> that I could install the latest version 2.3 from trolltech.no.
>
> When I forced the removal of the qt libraries it messed up my system and
> now I have to do a fresh install of Mandrake to get everything back to
> normal.
>
> I simply wanted to be able to develop applications with the latest version
> of the qt libraries, and in particular the unixODBC gui package so that I
> can talk to my PostgreSQL 7.0.x datbase server.
>
There is a (S)RPM package in cooker. You have to modify the .spec for the gui
programs. Or take this spec:
%define name unixODBC
%define version 2.0.3
%define release 1mdk
#%define _prefix /usr
%define prefix %{_prefix}
Name: %{name}
Summary: Unix ODBC driver manager and database drivers
Summary: Driver ODBC unix
Version: %{version}
Release: %{release}
Source: %{name}-%{version}.tar.bz2
Source1: odbcinst.ini
Group: Databases
Copyright: LGPL
URL: http://www.unixODBC.org/unixODBC/index.html
BuildRoot: %{_tmppath}/%{name}-%{version}-buildroot
BuildPreReq: bison, flex
Provides: libodbc.so, libodbcinst.so
Prefix: %{prefix}
%description
The unixODBC Project goals are to develop and promote unixODBC to
be the definitive standard for ODBC on the Linux platform. This is to
include GUI support for KDE.
Install unixODBC if you'd like to access databases through ODBC. This
package include drivers for PostgreSQL and local files.
If you want to develop programs that will access data through ODBC,
you'll also need to have the unixODBC package installed.
%package devel
Summary: Development files for programs which will use the unixODBC library.
Group: Development/Libraries
Requires: unixODBC = %{PACKAGE_VERSION}
%description devel
Install unixODBC if you'd like to access databases through ODBC drivers.
If you want to develop programs that will access data through ODBC,
you'll also need to install the unixODBC-devel (this) package.
%package kde
Summary: KDE DriverManager components
Group: System Environment/Libraries
requires: qt >= 2.0
%description kde
Components for the ODBCConfig and DataManager (KDE) Components of unixODBC.
%prep
%setup -q
%build
(cd ODBCConfig && rm -f mclass*.cpp)
(cd DataManager && rm -f mclass*.cpp)
%configure \
--with-qt-dir=/usr/lib/qt2 \
--with-gnu-ld
%make
%install
%makeinstall
cp %{S:1} $RPM_BUILD_ROOT/%{_sysconfdir}
touch $RPM_BUILD_ROOT/%{_sysconfdir}/odbc.ini
# icon
mkdir -p $RPM_BUILD_ROOT/{%{_iconsdir},%{_miconsdir}}
cp ODBCConfig/LinuxODBC.xpm $RPM_BUILD_ROOT/%{_iconsdir}/LinuxODBC.xpm
cp ODBCConfig/smallLinuxODBC.xpm $RPM_BUILD_ROOT/%{_miconsdir}/LinuxODBC.xpm
# menu
mkdir -p $RPM_BUILD_ROOT/%{_menudir}
cat > $RPM_BUILD_ROOT/%{_menudir}/ODBCConfig <<EOF
?package(ODBCconfig):\
needs="x11"\
section="Applications/Databases"\
title="ODBCConfig"\
longtitle="Configuration tool for unixODBC"\
command="/usr/bin/ODBCConfig"\
icon="LinuxODBC.xpm"
EOF
# menu
mkdir -p $RPM_BUILD_ROOT/%{_menudir}
cat > $RPM_BUILD_ROOT/%{_menudir}/DataManager <<EOF
?package(DataManager):\
needs="x11"\
section="Applications/Databases"\
title="DataManager"\
longtitle=""\
command="/usr/bin/DataManager"\
icon="LinuxODBC.xpm"
EOF
%clean
rm -rf $RPM_BUILD_ROOT
%files
%defattr(-,root,root)
%doc README
%doc COPYING
%doc AUTHORS
%doc ChangeLog
%doc NEWS
%doc INSTALL
%doc doc
%config %{_sysconfdir}
%{_libdir}/lib*.so*
%{_bindir}/odbcinst
%{_bindir}/isql
%{_bindir}/dltest
%files devel
%{_includedir}/odbcinst.h
%{_includedir}/odbcinstext.h
%{_includedir}/sql.h
%{_includedir}/sqlext.h
%{_includedir}/sqltypes.h
%{_libdir}/lib*.la
%files kde
%{_bindir}/ODBCConfig
%{_bindir}/DataManager
%{_bindir}/odbctest
%{_menudir}/ODBCConfig
%{_menudir}/DataManager
%{_iconsdir}/LinuxODBC.xpm
%{_miconsdir}/LinuxODBC.xpm
%post
ldconfig -n /usr/lib
%post kde
%{update_menus}
ldconfig -n /usr/lib
%postun
ldconfig -n /usr/lib
%postun kde
%{clean_menus}
ldconfig -n /usr/lib
%changelog
* Fri Jan 26 2001 RA <[EMAIL PROTECTED]> 2.0.3-1mdk
- update; modified for Mdk
* Tue Apr 18 2000 Murray Todd Williams <[EMAIL PROTECTED]>
- added a unixODBC-devel RPM to the group, added KDE links and icons to system
- all of which came from recommendations from Fredrick Meunier
- <[EMAIL PROTECTED]>
* Mon Apr 17 2000 Murray Todd Williams <[EMAIL PROTECTED]>
- unixODBC-1.8.7
- moved install to $RPM_BUILD_ROOT so it didn't overrun existing files.
