On Wed, 2005-06-08 at 16:48 -0500, Jay Hannah wrote:
> > > Not us. We use DBD::Sybase and FreeTDS to connect to MS-SQL from Linux.
>
> > Could you give me a pointer on how to set this up?
> > I did a couple of tests the other day but I couldn't make it work.
>
> Maybe our Intranet document will help you? I attached it. If not, I'll need a
> lot more info about what errors you're seeing.
>
> Cheers,
>
> j
>
I upgraded my server to FC4 now I'm using
GCC 4.00
Perl v5.8.6
unixODBC 2.2.11
freetds 0.63
Same results.
But now I have some strange warnings when I build:
cp Changes blib/lib/DBD/ODBC/Changes.pm
cp ODBC.pm blib/lib/DBD/ODBC.pm
/usr/bin/perl -p -e
"s/~DRIVER~/ODBC/g" /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-
multi/auto/DBI//Driver.xst > ODBC.xsi
/usr/bin/perl /usr/lib/perl5/5.8.6/ExtUtils/xsubpp -
typemap /usr/lib/perl5/5.8.6/ExtUtils/typemap ODBC.xs > ODBC.xsc && mv
ODBC.xsc ODBC.c
Warning: duplicate function definition 'data_sources' detected in
ODBC.xs, line 202
gcc -c -I/usr/include -I. -I/usr/lib/perl5/vendor_perl/5.8.6/i386-
linux-thread-multi/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -
fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wp,-
D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -
fasynchronous-unwind-tables -DVERSION=\"1.13\" -DXS_VERSION=\"1.13\" -
fPIC "-I/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE" -
I/usr/include ODBC.c
ODBC.xs: In function ‘XS_DBD__ODBC__dr_data_sources’:
ODBC.xs:231: warning: pointer targets in passing argument 1 of
‘__builtin___strcpy_chk’ differ in signedness
ODBC.xs:231: warning: pointer targets in passing argument 1 of
‘__strcpy_ichk’ differ in signedness
ODBC.xs:251: warning: pointer targets in passing argument 2 of
‘Perl_newSVpv’ differ in signedness
gcc -c -I/usr/include -I. -I/usr/lib/perl5/vendor_perl/5.8.6/i386-
linux-thread-multi/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -
fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wp,-
D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -
fasynchronous-unwind-tables -DVERSION=\"1.13\" -DXS_VERSION=\"1.13\" -
fPIC "-I/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE" -
I/usr/include dbdimp.c
dbdimp.c: In function ‘odbc_db_login6’:
dbdimp.c:595: warning: pointer targets in passing argument 3 of
‘SQLDriverConnect’ differ in signedness
dbdimp.c:595: warning: pointer targets in passing argument 5 of
‘SQLDriverConnect’ differ in signedness
dbdimp.c:657: warning: pointer targets in passing argument 2 of
‘SQLConnect’ differ in signedness
dbdimp.c:657: warning: pointer targets in passing argument 4 of
‘SQLConnect’ differ in signedness
dbdimp.c:657: warning: pointer targets in passing argument 6 of
‘SQLConnect’ differ in signedness
dbdimp.c: In function ‘dbd_error2’:
dbdimp.c:961: warning: pointer targets in passing argument 3 of
‘Perl_sv_setpvn’ differ in signedness
dbdimp.c:987: warning: pointer targets in passing argument 2 of
‘Perl_newSVpv’ differ in signedness
dbdimp.c:988: warning: pointer targets in passing argument 2 of
‘Perl_newSVpv’ differ in signedness
dbdimp.c:1010: warning: pointer targets in passing argument 3 of
‘Perl_sv_setpv’ differ in signedness
dbdimp.c:1012: warning: pointer targets in passing argument 3 of
‘Perl_sv_catpvn_flags’ differ in signedness
dbdimp.c:1014: warning: pointer targets in passing argument 3 of
‘Perl_sv_catpv’ differ in signedness
dbdimp.c:1020: warning: pointer targets in passing argument 1 of
‘strlen’ differ in signedness
dbdimp.c:1020: warning: pointer targets in passing argument 1 of
‘__builtin_strcmp’ differ in signedness
dbdimp.c:1020: warning: pointer targets in passing argument 1 of
‘strlen’ differ in signedness
dbdimp.c:1020: warning: pointer targets in passing argument 1 of
‘__builtin_strcmp’ differ in signedness
dbdimp.c:1020: warning: pointer targets in passing argument 1 of
‘__builtin_strcmp’ differ in signedness
dbdimp.c:1020: warning: pointer targets in passing argument 1 of
‘__builtin_strcmp’ differ in signedness
dbdimp.c: In function ‘odbc_st_tables’:
dbdimp.c:1314: warning: pointer targets in passing argument 2 of
‘SQLTables’ differ in signedness
dbdimp.c:1314: warning: pointer targets in passing argument 4 of
‘SQLTables’ differ in signedness
dbdimp.c:1314: warning: pointer targets in passing argument 6 of
‘SQLTables’ differ in signedness
dbdimp.c:1314: warning: pointer targets in passing argument 8 of
‘SQLTables’ differ in signedness
dbdimp.c: In function ‘odbc_st_primary_keys’:
dbdimp.c:1374: warning: pointer targets in passing argument 2 of
‘SQLPrimaryKeys’ differ in signedness
dbdimp.c:1374: warning: pointer targets in passing argument 4 of
‘SQLPrimaryKeys’ differ in signedness
dbdimp.c:1374: warning: pointer targets in passing argument 6 of
‘SQLPrimaryKeys’ differ in signedness
dbdimp.c: In function ‘odbc_st_prepare’:
dbdimp.c:1454: warning: pointer targets in passing argument 2 of
‘SQLPrepare’ differ in signedness
dbdimp.c: In function ‘odbc_st_execute’:
dbdimp.c:2015: warning: pointer targets in passing argument 2 of
‘SQLExecDirect’ differ in signedness
dbdimp.c:2061: warning: pointer targets in assignment differ in
signedness
dbdimp.c: In function ‘_dbd_rebind_ph’:
dbdimp.c:2762: warning: pointer targets in assignment differ in
signedness
dbdimp.c:2772: warning: pointer targets in assignment differ in
signedness
dbdimp.c: In function ‘odbc_st_FETCH_attrib’:
dbdimp.c:3579: warning: pointer targets in passing argument 2 of
‘Perl_newSVpv’ differ in signedness
dbdimp.c:3622: warning: pointer targets in passing argument 2 of
‘SQLGetCursorName’ differ in signedness
dbdimp.c: In function ‘odbc_get_statistics’:
dbdimp.c:3824: warning: pointer targets in passing argument 2 of
‘SQLStatistics’ differ in signedness
dbdimp.c:3824: warning: pointer targets in passing argument 4 of
‘SQLStatistics’ differ in signedness
dbdimp.c:3824: warning: pointer targets in passing argument 6 of
‘SQLStatistics’ differ in signedness
dbdimp.c: In function ‘odbc_get_primary_keys’:
dbdimp.c:3864: warning: pointer targets in passing argument 2 of
‘SQLPrimaryKeys’ differ in signedness
dbdimp.c:3864: warning: pointer targets in passing argument 4 of
‘SQLPrimaryKeys’ differ in signedness
dbdimp.c:3864: warning: pointer targets in passing argument 6 of
‘SQLPrimaryKeys’ differ in signedness
dbdimp.c: In function ‘odbc_get_special_columns’:
dbdimp.c:3910: warning: pointer targets in passing argument 3 of
‘SQLSpecialColumns’ differ in signedness
dbdimp.c:3910: warning: pointer targets in passing argument 5 of
‘SQLSpecialColumns’ differ in signedness
dbdimp.c:3910: warning: pointer targets in passing argument 7 of
‘SQLSpecialColumns’ differ in signedness
dbdimp.c: In function ‘odbc_get_foreign_keys’:
dbdimp.c:3974: warning: pointer targets in passing argument 2 of
‘SQLForeignKeys’ differ in signedness
dbdimp.c:3974: warning: pointer targets in passing argument 4 of
‘SQLForeignKeys’ differ in signedness
dbdimp.c:3974: warning: pointer targets in passing argument 6 of
‘SQLForeignKeys’ differ in signedness
dbdimp.c:3974: warning: pointer targets in passing argument 8 of
‘SQLForeignKeys’ differ in signedness
dbdimp.c:3974: warning: pointer targets in passing argument 10 of
‘SQLForeignKeys’ differ in signedness
dbdimp.c:3974: warning: pointer targets in passing argument 12 of
‘SQLForeignKeys’ differ in signedness
dbdimp.c: In function ‘odbc_describe_col’:
dbdimp.c:4000: warning: pointer targets in passing argument 3 of
‘SQLDescribeCol’ differ in signedness
dbdimp.c: In function ‘odbc_db_columns’:
dbdimp.c:4208: warning: pointer targets in passing argument 2 of
‘SQLColumns’ differ in signedness
dbdimp.c:4208: warning: pointer targets in passing argument 4 of
‘SQLColumns’ differ in signedness
dbdimp.c:4208: warning: pointer targets in passing argument 6 of
‘SQLColumns’ differ in signedness
dbdimp.c:4208: warning: pointer targets in passing argument 8 of
‘SQLColumns’ differ in signedness
Running Mkbootstrap for DBD::ODBC ()
chmod 644 ODBC.bs
rm -f blib/arch/auto/DBD/ODBC/ODBC.so
gcc -shared -L/usr/local/lib ODBC.o dbdimp.o -o
blib/arch/auto/DBD/ODBC/ODBC.so -L/usr/lib -lodbc
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
/usr/bin/make -- OK
Running 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
3/5 skipped: SQLDescribeParam not supported using Microsoft SQL
Server
t/09multi........ok
t/20SqlServer....ok 5/37DBD::ODBC::st execute failed: (DBD:
st_execute/SQLExecute err=-1) at t/20SqlServer.t line 210.
# Looks like you planned 37 tests but only ran 5.
# Looks like your test died just after 5.
t/20SqlServer....dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 6-37
Failed 32/37 tests, 13.51% okay
t/30Oracle.......ok
2/4 skipped: Oracle tests not supported using Microsoft SQL
Server
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/20SqlServer.t 255 65280 37 64 172.97% 6-37
5 subtests skipped.
Failed 1/9 test scripts, 88.89% okay. 32/137 subtests failed, 76.64%
okay.
make: *** [test_dynamic] Error 255
Any ideas?
Thanks in advance for your help
--
Pablo Endres <[EMAIL PROTECTED]>
ComVoz Communications
USA: +1 305 722 0500 Ext 199
Venezuela: +58 212 771 3100 Ext 199
Colombia: +57 1 313 7630 Ext 199
