All,
I am trying to use Perl with DBI/DBD and Datadirect ODBC to import datafile
on unix to remote windows-based SQL server RDBMS.
I have installed DBI-1.45 and Datadirect (www.datadirect.com) ODBC drive for
SQL server DB on my Redhat 9.0 Linux. So far DataDirect SQL ODBC drive on
linux is working and can be associated to remote SQL server DB. Now I have
problem to configure the DBD:ODBC 1.11 integrated with DataDirect ODBC to
connect SQL server DB. I have read the documentation of knowledgebase on
www.datadirect.com. The final test step make test awalys failed with
attached message. Could someone advise me on it? Thanks a lot!
Mike Z. Chen, Database Engineer <<DBDconfig.txt>>
Information Technology
Harris County Hospital District
713-566-6057(O)
281-952-4751(P)
713-566-6003(F)
IT Mission Statement: We advance the Mission and Values of HCHD by providing
cost-effective technologies with attention to our customer's needs and
through continuous improvement.
CONFIDENTIALITY NOTICE:
If you have received this e-mail in error, please immediately notify the sender
by return e-mail and delete this e-mail and any attachments from your computer
system.
To the extent the information in this e-mail and any attachments contain
protected health information as defined by the Health Insurance Portability and
Accountability Act of 1996 ("HIPAA"), PL 104-191; 43 CFR Parts 160 and 164; or
Chapter 181, Texas Health and Safety Code, it is confidential and/or
privileged. This e-mail may also be confidential and/or privileged under Texas
law. The e-mail is for the use of only the individual or entity named above.
If you are not the intended recipient, or any authorized representative of the
intended recipient, you are hereby notified that any review, dissemination or
copying of this e-mail and its attachments is strictly prohibited.
[EMAIL PROTECTED] DBD-ODBC-1.11]# perl Makefile.PL
Useless use of private variable in void context at Makefile.PL line 429.
Configuring DBD::ODBC ...
>>> Remember to actually *READ* the README file!
And re-read it if you have any problems.
Multiple copies of Driver.xst found in:
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI/ at
Makefile.PL line 60
Using DBI 1.45 (for perl 5.008 on i386-linux-thread-multi) installed in
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/
Using ODBC in /home/chenm1/odbc32v50
Umm, this looks like a intersolve type of driver manager.
You seem to have the official header files.
Injecting selected odbc driver into cc command
Injecting selected odbc driver into cc command
Multiple copies of Driver.xst found in:
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI/ at
Makefile.PL line 460
Using DBI 1.45 (for perl 5.008 on i386-linux-thread-multi) installed in
/usr/lib/perl5/site_perl/5.8.0/i386-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:HHSQLTEST e.g. dbi:ODBC:demo
DBI_USER=chen
DBI_PASS=chen
[EMAIL PROTECTED] DBD-ODBC-1.11]# make
Makefile:90: *** missing separator. Stop.
[EMAIL PROTECTED] DBD-ODBC-1.11]# echo $LANG
en_US.UTF-8
[EMAIL PROTECTED] DBD-ODBC-1.11]# LANG=en_US
[EMAIL PROTECTED] DBD-ODBC-1.11]# export LANG
[EMAIL PROTECTED] DBD-ODBC-1.11]# echo $LANG
en_US
[EMAIL PROTECTED] DBD-ODBC-1.11]# perl Makefile.PL
Useless use of private variable in void context at Makefile.PL line 429.
Configuring DBD::ODBC ...
>>> Remember to actually *READ* the README file!
And re-read it if you have any problems.
Multiple copies of Driver.xst found in:
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI/ at
Makefile.PL line 60
Using DBI 1.45 (for perl 5.008 on i386-linux-thread-multi) installed in
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/
Using ODBC in /home/chenm1/odbc32v50
Umm, this looks like a intersolve type of driver manager.
You seem to have the official header files.
Injecting selected odbc driver into cc command
Injecting selected odbc driver into cc command
Multiple copies of Driver.xst found in:
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI/ at
Makefile.PL line 460
Using DBI 1.45 (for perl 5.008 on i386-linux-thread-multi) installed in
/usr/lib/perl5/site_perl/5.8.0/i386-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:HHSQLTEST e.g. dbi:ODBC:demo
DBI_USER=chen
DBI_PASS=chen
[EMAIL PROTECTED] DBD-ODBC-1.11]# make
gcc -c -I. -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/
-I/home/chenm1/odbc32v50/include -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 -mcpu=i686 -g
-DVERSION=\"1.11\" -DXS_VERSION=\"1.11\" -fPIC
"-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" ODBC.c
gcc -c -I. -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/
-I/home/chenm1/odbc32v50/include -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 -mcpu=i686 -g
-DVERSION=\"1.11\" -DXS_VERSION=\"1.11\" -fPIC
"-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" dbdimp.c
Running Mkbootstrap for DBD::ODBC ()
chmod 644 ODBC.bs
rm -f blib/arch/auto/DBD/ODBC/ODBC.so
LD_RUN_PATH="/home/chenm1/odbc32v50/lib" gcc -shared -L/usr/local/lib ODBC.o
dbdimp.o -o blib/arch/auto/DBD/ODBC/ODBC.so
-L/home/chenm1/odbc32v50/lib -R/home/chenm1/odbc32v50/lib -lodbc
gcc: unrecognized option `-R/home/chenm1/odbc32v50/lib'
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
Manifying blib/man3/DBD::ODBC.3pm
[EMAIL PROTECTED] DBD-ODBC-1.11]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/01base.........ok
t/02simple.......ok
t/03dbatt........ok
t/05meth.........ok
t/07bind.........ok
t/08bind2........ok
t/09multi........skipped
all skipped: multiple statements not supported using Microsoft SQL
Server (SQL_MULT_RESULT_SETS)
t/20SqlServer....ok 25/28Can't call method "execute" on an undefined value at
t/20SqlServer.t line 440.
t/20SqlServer....dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 26-28
Failed 3/28 tests, 89.29% okay
t/30Oracle.......skipped
all skipped: Oracle tests not supported using Microsoft SQL Server
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/20SqlServer.t 2 512 28 3 10.71% 26-28
2 tests skipped.
Failed 1/9 test scripts, 88.89% okay. 3/95 subtests failed, 96.84% okay.
make: *** [test_dynamic] Error 29
[EMAIL PROTECTED] DBD-ODBC-1.11]#
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DBI_DSN=dbi:ODBC:HHSQLTEST
ODBCINI=/home/chenm1/odbc32v50/odbc.ini
ODBCHOME=/home/chenm1/odbc32v50
[EMAIL PROTECTED] root]# more setodbcenv
ODBCINI=/home/chenm1/odbc32v50/odbc.ini
ODBCHOME=/home/chenm1/odbc32v50
DBI_DSN=dbi:ODBC:HHSQLTEST
DBI_USER=chen
DBI_PASS=chen
LD_LIBRARY_PATH=/home/chenm1/odbc32v50/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH ODBCINI ODBCHOME
export DBI_DSN DBI_USER DBI_PASS
