[freetds] DBD::ODBC + freeTDS

Pablo Endres epablo at comvoz.com
Wed Jun 8 16:24:22 EDT 2005


Hi,

I've been trying to setup a DBD::ODBC connection from my FC3 box.

I had it working A OK before I upgraded to FC3 :(

I have narrowed the problem down to the RTLGROUP problem (I think) but I
was wondering if there was a way of doing this without using unixODBC.

This is my setup:
* unixODBC-2.2.11-2, fresh build made sure that the rtlgroup flag was on
while building
* freetds-0.62.3-1.1.fc3.rf
* perl 5.8.5

I'm going against a MS SQL 2000 server.

This is what I get with the 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 2/11DBD::ODBC::st execute failed: (DBD:
st_execute/SQLExecute err=-1) at t/ODBCTEST.pm line 228.
t/07bind.........NOK 3#     Failed test (t/07bind.t at line 50)
# Test 4 is known to fail often. It is not a major concern.  It *may* be
an indication of being unable to bind datetime values correctly.
t/07bind.........ok 4/11DBD::ODBC::st execute failed:
[unixODBC][FreeTDS][SQL Server]Write to SQL Server failed.
(SQL-08S01)(DBD: st_execute/SQLExecute err=-1) at t/07bind.t line 121.
DBD::ODBC::st fetchrow failed: (DBD: no select statement currently
executing err=-1) at t/07bind.t line 122.
DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Write to
SQL Server failed. (SQL-08S01)(DBD: st_execute/SQLExecute err=-1) at
t/07bind.t line 121.
DBD::ODBC::st fetchrow failed: (DBD: no select statement currently
executing err=-1) at t/07bind.t line 122.
DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Write to
SQL Server failed. (SQL-08S01)(DBD: st_execute/SQLExecute err=-1) at
t/07bind.t line 121.
DBD::ODBC::st fetchrow failed: (DBD: no select statement currently
executing err=-1) at t/07bind.t line 122.
DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Write to
SQL Server failed. (SQL-08S01)(DBD: st_execute/SQLExecute err=-1) at
t/07bind.t line 121.
DBD::ODBC::st fetchrow failed: (DBD: no select statement currently
executing err=-1) at t/07bind.t line 122.
DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Write to
SQL Server failed. (SQL-08S01)(DBD: st_execute/SQLExecute err=-1) at
t/07bind.t line 121.
DBD::ODBC::st fetchrow failed: (DBD: no select statement currently
executing err=-1) at t/07bind.t line 122.
DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Write to
SQL Server failed. (SQL-08S01)(DBD: st_execute/SQLExecute err=-1) at
t/07bind.t line 121.
DBD::ODBC::st fetchrow failed: (DBD: no select statement currently
executing err=-1) at t/07bind.t line 122.
t/07bind.........ok 5/11Unable to find a suitable test type for field
COL_A at t/ODBCTEST.pm line 64.
# Looks like you planned 11 tests but only ran 5.
# Looks like your test died just after 5.
t/07bind.........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3, 6-11
        Failed 7/11 tests, 36.36% okay
t/08bind2........ok
        3/5 skipped: SQLDescribeParam not supported using Microsoft SQL
Server
t/09multi........ok 4/7DBD::ODBC::db do failed: [unixODBC][FreeTDS][SQL
Server]Violation of PRIMARY KEY constraint
'PK__PERL_DBD_TEST__2D52A092'. Cannot insert duplicate key in object
'PERL_DBD_TEST'. (SQL-23000)
[unixODBC][FreeTDS][SQL Server]The statement has been terminated.
(SQL-01000)(DBD: Execute immediate failed err=-1) at t/ODBCTEST.pm line
159.
# Looks like you planned 7 tests but only ran 4.
# Looks like your test died just after 4.
t/09multi........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 5-7
        Failed 3/7 tests, 57.14% okay
t/20SqlServer....ok 2/37# Retrieving: 1, 2001-01-01 01:01:01 string
length: 12  !time
# Retrieving: 2, 2002-02-02 02:02:02 string length: 114 !time
# Retrieving: 3, 2003-03-03 03:03:03 string length: 251 !time
# Retrieving: 4, 2004-04-04 04:04:04 string length: 282 !time
# Retrieving: 5, 2005-05-05 05:05:05 string length: 131 !time
t/20SqlServer....NOK 3#     Failed test (t/20SqlServer.t at line 127)
#          got: '5'
#     expected: '0'
t/20SqlServer....NOK 4#     Failed test (t/20SqlServer.t at line 162)
#          got: '3'
#     expected: '0'
# Please upgrade your ODBC drivers to the latest SQL Server drivers
available.  For example, 2000.80.194.00 is known to be problematic.  Use
MDAC 2.7, if possible
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 3-4, 6-37
        Failed 34/37 tests, 8.11% 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/07bind.t       255 65280    11   13 118.18%  3 6-11
t/09multi.t      255 65280     7    6  85.71%  5-7
t/20SqlServer.t  255 65280    37   66 178.38%  3-4 6-37
5 subtests skipped.
Failed 3/9 test scripts, 66.67% okay. 44/137 subtests failed, 67.88%
okay.
make: *** [test_dynamic] Error 255


Any Ideas?  Thanks in advance for your help



-- 
Pablo Endres <epablo at comvoz.com>
ComVoz Communications

USA:       +1 305 722 0500 Ext 199
Venezuela: +58 212 771 3100 Ext 199
Colombia:  +57 1 313 7630 Ext 199



More information about the FreeTDS mailing list