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

List:       dbi-dev
Subject:    odbc setup help please
From:       Terry Mullett <tmullett () bensoft ! com>
Date:       1997-09-30 16:02:03
[Download RAW message or body]

    *** From dbi-users -- To unsubscribe, see the end of this message. ***

Hi,

I'm trying to get DBD:ODBC setup to work on a Linux (ELF) web server to
talk to a Linux database server machine which is running Empress. I can
get Empress' own client libraries to work across the network, but could
not get them to work successfully with DBD::ODBC - in particular, I get
killed on the SQLDescribeParam as mentioned in the DBD::ODBC readme. So
I tried compiling it against iODBC 2.12 instead. I have perl 5.00401 and

DBI 0.90 installed. Running make test bombs on a connection failure.
Below is the log, along with my relevant environment strings and the
contents of odbc.ini which was set up as per the iODBC readme. Any help
on this would be very greatly appreciated.

Be well,
Terry

========================================================
bensoft:/usr/local/src/DBD-ODBC-0.16# perl Makefile.PL

Configuring DBD::ODBC ...

>>>Remember to actually *READ* the README file!
   And re-read it if you have any problems.

Using ODBC in /usr/lib/odbc
Checking if your kit is complete...
Looks good
Writing Makefile for DBD::ODBC

The DBD::ODBC tests will use these values for the database connection:
    DBI_DSN=dbi:ODBC:empresse.g. dbi:ODBC:demo
    DBI_USER=empress
    DBI_PASS=********
bensoft:/usr/local/src/DBD-ODBC-0.16# make
mkdir ./blib
mkdir ./blib/lib
mkdir ./blib/lib/DBD
mkdir ./blib/arch
mkdir ./blib/arch/auto
mkdir ./blib/arch/auto/DBD
mkdir ./blib/arch/auto/DBD/ODBC
mkdir ./blib/lib/auto
mkdir ./blib/lib/auto/DBD
mkdir ./blib/lib/auto/DBD/ODBC
cp ODBC.pm ./blib/lib/DBD/ODBC.pm
perl -p -e "s/~DRIVER~/ODBC/g" <
/usr/lib/perl5/site_perl/i586-linux/auto/DBI/Driver.xst > ODBC.xsi
/usr/bin/perl -I/usr/lib/perl5/i586-linux/5.00401 -I/usr/lib/perl5
/usr/lib/perl5/ExtUtils/xsubpp  -typemap /usr/lib/perl5/ExtUtils/typemap

ODBC.xs >ODBC.tc && mv ODBC.tc ODBC.c
cc -c -I. -I/usr/lib/perl5/site_perl/i586-linux/auto/DBI -Dbool=char
-DHAS_BOOL -I/usr/local/include -O2    -DVERSION=\"0.16\"
-DXS_VERSION=\"0.16\" -fpic -I/usr/lib/perl5/i586-linux/5.00401/CORE
-I/usr/local/src/iodbc-2.12 ODBC.c
cc -c -I. -I/usr/lib/perl5/site_perl/i586-linux/auto/DBI -Dbool=char
-DHAS_BOOL -I/usr/local/include -O2    -DVERSION=\"0.16\"
-DXS_VERSION=\"0.16\" -fpic -I/usr/lib/perl5/i586-linux/5.00401/CORE
-I/usr/local/src/iodbc-2.12 dbdimp.c
Running Mkbootstrap for DBD::ODBC ()
chmod 644 ODBC.bs
LD_RUN_PATH="/usr/lib" cc -o blib/arch/auto/DBD/ODBC/ODBC.so  -shared
-L/usr/local/lib ODBC.o dbdimp.o    -liodbc
chmod 755 blib/arch/auto/DBD/ODBC/ODBC.so
cp ODBC.bs ./blib/arch/auto/DBD/ODBC/ODBC.bs
chmod 644 blib/arch/auto/DBD/ODBC/ODBC.bs
bensoft:/usr/local/src/DBD-ODBC-0.16# make test TEST_VERBOSE=1
PERL_DL_NONLAZY=1 /usr/bin/perl -I./blib/arch -I./blib/lib
-I/usr/lib/perl5/i586-linux/5.00401 -I/usr/lib/perl5 -e 'use
Test::Harness qw(&runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t

t/01base............1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t/02simple..........1..6
ok 1
 Test 2: connecting to the database
Connect failed: (DBD: db_login/SQLConnect err=-1)
dubious
Test returned status 2 (wstat 512)
DIED. FAILED tests 2-6
Failed 5/6 tests, 16.67% okay
t/03dbatt...........1..6
ok 1
Connect failed: (DBD: db_login/SQLConnect err=-1)
dubious
Test returned status 2 (wstat 512)
DIED. FAILED tests 2-6
Failed 5/6 tests, 16.67% okay
t/05meth............1..6
ok 1
Connect failed: (DBD: db_login/SQLConnect err=-1)
dubious
Test returned status 2 (wstat 512)
DIED. FAILED tests 2-6
Failed 5/6 tests, 16.67% okay
t/09bind............1..5
ok 1
 Test 2: connecting to the database
Connect failed: (DBD: db_login/SQLConnect err=-1)
dubious
Test returned status 2 (wstat 512)
DIED. FAILED tests 2-5
Failed 4/5 tests, 20.00% okay
Failed Test  Status Wstat Total Fail  Failed  List of failed
------------------------------------------------------------------------------

t/02simple.t      2   512     6    5  83.33%  2-6
t/03dbatt.t       2   512     6    5  83.33%  2-6
t/05meth.t        2   512     6    5  83.33%  2-6
t/09bind.t        2   512     5    4  80.00%  2-5
Failed 4/5 test scripts, 20.00% okay. 19/28 subtests failed, 32.14%
okay.
make: *** [test_dynamic] Error 2
bensoft:/usr/local/src/DBD-ODBC-0.16# cat ~/.odbc.ini
[empress]
Server = 192.168.0.2
Port = 6322
Driver = /usr/lib/odbc/empodbc.so
bensoft:/usr/local/src/DBD-ODBC-0.16# set | grep DBI
DBI_DSN=dbi:ODBC:empress
DBI_PASS=********
DBI_USER=empress
bensoft:/usr/local/src/DBD-ODBC-0.16# set |grep ODBCHOME
ODBCHOME=/usr/lib/odbc
bensoft:/usr/local/src/DBD-ODBC-0.16# perl -v

This is perl, version 5.004_01

Copyright 1987-1997, Larry Wall

Perl may be copied only under the terms of either the Artistic License
or the
GNU General Public License, which may be found in the Perl 5.0 source
kit.

bensoft:/usr/local/src/DBD-ODBC-0.16#






------------------------------------------------------------------------------
To unsubscribe from this list, please visit http://www.fugue.com/dbi.
If you are without web access, or if you are having trouble with the web page,
please send mail to dbi-request@fugue.com.   Please try to use the web
page first - it will take a long time for your request to be processed by hand.
------------------------------------------------------------------------------

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