Skip to Content.
Sympa Menu

freetds - [freetds] DBD::ODBC + freeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Pablo Endres <epablo AT comvoz.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] DBD::ODBC + freeTDS
  • Date: Wed, 08 Jun 2005 16:24:22 -0400

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





Archive powered by MHonArc 2.6.24.

Top of Page