[freetds] make check results/errors

Knut Behrends knb at gfz-potsdam.de
Thu Feb 5 09:16:33 EST 2009


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I use Freetds another try because I want to fetch data *from* a MSSQL
server, I don't want to do bcp in/out , no CRUD statements. Just plain
SELECTs .

This seems to work except for text/image datatypes fetched via ODBC, so
I think I'll just use the freetds/unixodbc on our development machine.


Using Freetds freetds-0.83.dev.20090104 and unixodbc,
i was just Connecting to a
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05
  Copyright (c) 1988-2003 Microsoft Corporation  Personal Edition on
Windows NT 5.1 (Build 2600: Service Pack 3)


Here is a brief summary of running the unittests on solaris 10.



the ctlib tests all pass.

make-check-tds.txt:FAIL: convert

make-check.dblib.txt:FAIL: t0001
make-check.dblib.txt:sqlexec FAIL: done_handling
make-check.dblib.txt:FAIL: timeout

make-check.odbc.txt:FAIL: putdata
make-check.odbc.txt:FAIL: getdata
make-check.odbc.txt:FAIL: genparams
make-check.odbc.txt:FAIL: data
make-check.odbc.txt:FAIL: cancel
make-check.odbc.txt:FAIL: utf8_2


*Anyone interested in more details?*

Can *I* do something to get better results?








    351 connection parameters:
    352 server:   'deleted'
    353 user:     'deleted'
    354 password: '????'
    355 database: 'tempdb'
    356 use tempdb
    357 CREATE TABLE #putdata (c TEXT NULL, b IMAGE NULL)
    358 DECLARE @i INT
    359 DECLARE @i INT
    360 DECLARE @i INT
    361 DECLARE @i INT
    362 DECLARE @i2 INT
    363 FAIL: putdata
    364 odbctest

    564 connection parameters:
    565 server:   'delted'
    566 user:     'deleted'
    567 password: '????'
    568 database: 'tempdb'
    569 use tempdb
    570 SELECT CONVERT(TEXT,'Prova')
    571 SELECT CONVERT(VARCHAR(100), 'Other test')
    572 SELECT CONVERT(TEXT,'Prova')
    573 Wrong data result 1
    574 FAIL: getdata
    575 odbctest


- --
____________________________________________________________________________

Knut Behrends                       Phone: +49 (0) 331 288 1688
Email: knb at gfz-potsdam.de           KeyID: 0xF22CACEF (GPG Public Key)
____________________________________________________________________________
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkmK9MEACgkQcfWHNfIsrO+iAQCgi4wW0AljccxUrLSNDFarCl1x
aKUAoI8mGYcfS6QVh4wn4/dW7hJiogbO
=+q15
-----END PGP SIGNATURE-----


More information about the FreeTDS mailing list