Trouble Installing DBD::ODBC with postgresql
- From: ucantspamthis@xxxxxxxxxxx (Craig Metzer)
- Date: Thu, 12 Jul 2007 18:11:03 -0400
I'm having trouble installing DBD::ODBC 1.13 on a system with postgresql. It appears it's because it can't find the sql.h, sqlext.h, etc. headers. I installed the developer and library packages that were supposed to contain these headers. Could someone please tell me what I'm doing wrong or where to find the headers?
TIA,
Craig
~~~ install info ~~~~~~
[mrtg@prod-netflow DBD-ODBC-1.13]$ perl Makefile.PLUseless use of private variable in void context at Makefile.PL line 431.
Configuring DBD::ODBC ...
Multiple copies of Driver.xst found in: /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ /usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 61Using DBI 1.58 (for perl 5.008005 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/Using ODBC in /usrRemember to actually *READ* the README file! And re-read it if you have any problems.
Umm, this looks like a unixodbc type of driver manager.We expect to find the sql.h, sqlext.h and (which weresupplied with unixODBC) in $ODBCHOME/include directory alongsidethe /usr/lib/libodbc.so library. in $ODBCHOME/lib
Injecting selected odbc driver into cc commandInjecting selected odbc driver into cc commandMultiple copies of Driver.xst found in: /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ /usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 462Using DBI 1.58 (for perl 5.008005 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/Writing Makefile for DBD::ODBC
The DBD::ODBC tests will use these values for the database connection: DBI_DSN=dbi:ODBC:pgsql e.g. dbi:ODBC:demo DBI_USER=postgres DBI_PASS=postgres
[mrtg@prod-netflow DBD-ODBC-1.13]$ rpm -qa | grep postgresqlpostgresql-7.4.13-2.RHEL4.1postgresql-devel-8.1.3-1.el4s1.2postgresql-libs-7.4.13-2.RHEL4.1postgresql-pl-7.4.13-2.RHEL4.1postgresql-libs-8.1.3-1.el4s1.2postgresql-odbc-7.3-8.RHEL4.1postgresql-server-7.4.13-2.RHEL4.1postgresql-test-7.4.13-2.RHEL4.1postgresql-contrib-7.4.13-2.RHEL4.1postgresql-python-7.4.13-2.RHEL4.1postgresql-docs-7.4.13-2.RHEL4.1postgresql-contrib-7.4.13-2.RHEL4.1postgresql-jdbc-7.4.13-2.RHEL4.1postgresql-tcl-7.4.13-2.RHEL4.1postgresql-perl-7.1..3-7.rhel2.1AS[mrtg@prod-netflow DBD-ODBC-1.13]$ find /usr -name sql\*.h/usr/include/sql3types.h/usr/include/sqlca.h/usr/include/pgsql/informix/esql/sqltypes.h/usr/include/pgsql/informix/esql/sqlda.h/usr/include/mysql/sql_state.h/usr/include/mysql/sql_common.h/usr/share/doc/qt-devel-3.3.3/examples/demo/sql/sqlex.ui.h/usr/local/include/sqltypes.h/usr/src/redhat/SOURCES/postgresql-7.4.13/src/bin/psql/sql_help.h/usr/src/redhat/SOURCES/postgresql-7.4..13/src/interfaces/ecpg/include/sql3types.h/usr/src/redhat/SOURCES/postgresql-7.4.13/src/interfaces/ecpg/include/sqlca.h/usr/src/redhat/SOURCES/postgresql-7.4.13/src/interfaces/ecpg/include/sqltypes.h/usr/src/redhat/SOURCES/postgresql-7.4.13/src/interfaces/ecpg/include/sqlda.h
_________________________________________________________________
See what you’re getting into…before you go there.
http://newlivehotmail.com
- Follow-Ups:
- Re: Trouble Installing DBD::ODBC with postgresql
- From: Alexander Foken
- Re: Trouble Installing DBD::ODBC with postgresql
- From: Martin Evans
- Re: Trouble Installing DBD::ODBC with postgresql
- Prev by Date: DBI 1.50 install error in Solaris 10
- Next by Date: Reference to a hash as argument for a plperl-function
- Previous by thread: DBI 1.50 install error in Solaris 10
- Next by thread: Re: Trouble Installing DBD::ODBC with postgresql
- Index(es):