Skip to Content.
Sympa Menu

freetds - RE: DBD::Sybase, FreeTDS, Solaris 2.7, Perl 5.6.1

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Richard Norman" <normri AT samc.com>
  • To: <camber AT ais.org>,<freetds AT franklin.oit.unc.edu>
  • Subject: RE: DBD::Sybase, FreeTDS, Solaris 2.7, Perl 5.6.1
  • Date: Thu, 04 Oct 2001 09:47:18 -0700


I just did a make check for two versions of the FreeTDS driver. Here is what
I have found thus far. (If more details are needed, let me know.

(My configuration is the same as my previous emails Perl 5.00503, Red Hat
6.2, etc.)

for the FreeTDS-0.53pre1, The following appears after a make check:

*******************************************************
freetds.conf


[root@instep freetds-0.53]# more freetds.conf
#
# The freetds.conf file is a replacement for the original interfaces file
# developed by Sybase. You may use either this or the intefaces file, but not
# both.
#
# FreeTDS will search for a file in the following order:
#
# 1) Check if a file was set programatically via dbsetifile() and is in .conf
# format, if so use that.
# 2) Look in ~/.freetds.conf
# 3) Look in @sysconfdir@/freetds.conf
#
# If freetds has found no suitable conf file it will then search for an
# an interfaces file:
#
# 1) Check if a file was set programatically via dbsetifile() and is in
# interfaces format, if so use that.
# 2) Look in ~/.interfaces
# 3) Look in $SYBASE/interfaces
#
# Only hostname, port number, and protocol version can be specified using the
# interfaces format.
#
# The conf file format follows a modified Windows INI style (or Samba style if
# you prefer to think of it that way). There is a [global] section which will
# affect all dataservers or basic program behaviour, and a section headed with
# the dataserver's name which will have settings which override the global
ones
#
# the complete list of settings and their defaults follows:
#

# any value here may be overridden in the dataserver specific section
[global]
tds version = 7.0
initial block size = 512
swap broken dates = no
swap broken money = no
# if both server and domain logins are enabled freetds will try domain login
# first if a domain is specified, and then fallback to server logins.
try server login = yes
try domain login = yes
# the default domain can be overridden by using the DOMAIN\username format.
nt domain = SAMC
# if the server responds with different domain try that one?
cross domain login = no
dump file = /usr/local/freetds/freetds.log
debug level = 10
; timeout = 10;
; connect timeout = 10;

# This is a sybase hosted dataserver, if you are directly on the net you can
# use it to test.
;[JDBC]
; host = 192.138.151.39
; port = 4444
; tds version = 5.0

# a typical MS SQL 7.0 configuration
;[MyServer70]
; host = ntmachine.domain.com
; port = 1433
; tds version = 7.0

[normri2]
host = normri2.samc.com
port = 1433
tds version = 7.0


[intouchsql]
host = intouchsql.samc.com
port = 1433
tds version = 7.0

# a typical MS SQL 7.0 configuration using domain logins
;[MyServer70]
; host = ntmachine.domain.com
; port = 1433
; tds version = 7.0
; try domain logins = yes
; try server logins = no
; nt domain = MYDOMAIN

# a typical MS SQL 6.x configuration
;[MyServer65]
; host = ntmachine.domain.com
; port = 1433
; tds version = 4.2

*******************************************************
PWD file

[root@instep freetds-0.53]# more PWD
# This file was taken from DBD::Sybase :-) It is used by 'make check' to test
# the installation
#
# UID: the username of a user to connect with
# PWD: the password for that user
# SRV: the symbolic server name from the freetds.conf (or interfaces) file.
# Note: if you use a hostname/IP here instead, freetds will attempt to
# connect using the compiletime default port (4000 for TDS 5.0, 1433 for
# 4.2 or 7.0) which is usually not right.
# DB: Database in which to create tables used in the tests. For those new to
# Sybase or MS SQL server, there may be many database per server. tempdb
# is a good default choice if unsure.
#
UID=sa
PWD=sa
SRV=normri2
DB=tempdb

*******************************************************
Results

[root@instep freetds-0.53]# make check
Making check in include
make[1]: Entering directory `/usr/local/freetds/freetds-0.53/include'
make[1]: Nothing to be done for `check'.
make[1]: Leaving directory `/usr/local/freetds/freetds-0.53/include'
Making check in src
make[1]: Entering directory `/usr/local/freetds/freetds-0.53/src'
Making check in tds
make[2]: Entering directory `/usr/local/freetds/freetds-0.53/src/tds'
Making check in unittests
make[3]: Entering directory
`/usr/local/freetds/freetds-0.53/src/tds/unittests'
make t0001 t0002 t0003 t0004 t0005 t0006
make[4]: Entering directory
`/usr/local/freetds/freetds-0.53/src/tds/unittests'
make[4]: `t0001' is up to date.
make[4]: `t0002' is up to date.
make[4]: `t0003' is up to date.
make[4]: `t0004' is up to date.
make[4]: `t0005' is up to date.
make[4]: `t0006' is up to date.
make[4]: Leaving directory `/usr/local/freetds/freetds-0.53/src/tds/unittests'
make check-TESTS
make[4]: Entering directory
`/usr/local/freetds/freetds-0.53/src/tds/unittests'
t0001.c: Testing login, logout
Unknown marker: 0!!
tds_connect() failed
try_tds_login() failed
FAIL: t0001
t0002.c: Test basic submit query, results
Unknown marker: 0!!
tds_connect() failed
try_tds_login() failed
FAIL: t0002
t0003.c: Testing DB change -- 'use tempdb'
Unknown marker: 0!!
tds_connect() failed
try_tds_login() failed
FAIL: t0003
t0004.c: Test large (>512 bytes) queries
Unknown marker: 0!!
tds_connect() failed
try_tds_login() failed
FAIL: t0004
t0005.c: Test large (>512 bytes) replies
Unknown marker: 0!!
tds_connect() failed
try_tds_login() failed
FAIL: t0005
t0006.c: Test SYBREAL, SYBFLT8 values
Unknown marker: 0!!
tds_connect() failed
try_tds_login() failed
FAIL: t0006
===================
6 of 6 tests failed
===================
make[4]: *** [check-TESTS] Error 1
make[4]: Leaving directory `/usr/local/freetds/freetds-0.53/src/tds/unittests'
make[3]: *** [check-am] Error 2
make[3]: Leaving directory `/usr/local/freetds/freetds-0.53/src/tds/unittests'
make[2]: *** [check-recursive] Error 1
make[2]: Leaving directory `/usr/local/freetds/freetds-0.53/src/tds'
make[1]: *** [check-recursive] Error 1
make[1]: Leaving directory `/usr/local/freetds/freetds-0.53/src'
make: *** [check-recursive] Error 1

*******************************************************

Now if I take the freetds-0.52.tgz and do the same process with the same
perameters I get the following results.

*******************************************************
Results

Making check in include
make[1]: Entering directory `/usr/local/freetds/freetds-0.52/include'
make[1]: Nothing to be done for `check'.
make[1]: Leaving directory `/usr/local/freetds/freetds-0.52/include'
Making check in src
make[1]: Entering directory `/usr/local/freetds/freetds-0.52/src'
Making check in tds
make[2]: Entering directory `/usr/local/freetds/freetds-0.52/src/tds'
Making check in unittests
make[3]: Entering directory
`/usr/local/freetds/freetds-0.52/src/tds/unittests'
make t0001 t0002 t0003 t0004 t0005 t0006
make[4]: Entering directory
`/usr/local/freetds/freetds-0.52/src/tds/unittests'
make[4]: `t0001' is up to date.
make[4]: `t0002' is up to date.
make[4]: `t0003' is up to date.
make[4]: `t0004' is up to date.
make[4]: `t0005' is up to date.
make[4]: `t0006' is up to date.
make[4]: Leaving directory `/usr/local/freetds/freetds-0.52/src/tds/unittests'
make check-TESTS
make[4]: Entering directory
`/usr/local/freetds/freetds-0.52/src/tds/unittests'
t0001.c: Testing login, logout
PASS: t0001
t0002.c: Test basic submit query, results
PASS: t0002
t0003.c: Testing DB change -- 'use tempdb'
PASS: t0003
t0004.c: Test large (>512 bytes) queries
PASS: t0004
t0005.c: Test large (>512 bytes) replies
PASS: t0005
t0006.c: Test SYBREAL, SYBFLT8 values
PASS: t0006
==================
All 6 tests passed
==================
make[4]: Leaving directory `/usr/local/freetds/freetds-0.52/src/tds/unittests'
make[3]: Leaving directory `/usr/local/freetds/freetds-0.52/src/tds/unittests'
make[3]: Entering directory `/usr/local/freetds/freetds-0.52/src/tds'
make[3]: Nothing to be done for `check-am'.
make[3]: Leaving directory `/usr/local/freetds/freetds-0.52/src/tds'
make[2]: Leaving directory `/usr/local/freetds/freetds-0.52/src/tds'
Making check in ctlib
make[2]: Entering directory `/usr/local/freetds/freetds-0.52/src/ctlib'
Making check in unittests
make[3]: Entering directory
`/usr/local/freetds/freetds-0.52/src/ctlib/unittests'
make t0001 t0002 t0003 t0004
make[4]: Entering directory
`/usr/local/freetds/freetds-0.52/src/ctlib/unittests'
make[4]: `t0001' is up to date.
make[4]: `t0002' is up to date.
make[4]: `t0003' is up to date.
make[4]: `t0004' is up to date.
make[4]: Leaving directory
`/usr/local/freetds/freetds-0.52/src/ctlib/unittests'
make check-TESTS
make[4]: Entering directory
`/usr/local/freetds/freetds-0.52/src/ctlib/unittests'
t0001.c: Testing login, logout
PASS: t0001
t0002.c: Testing bind & select
PASS: t0002
t0003.c: Retrieve CS_TEXT_TYPE using ct_bind()
PASS: t0003
t0004.c: Check ordering of returns from cs_results()
PASS: t0004
==================
All 4 tests passed
==================
make[4]: Leaving directory
`/usr/local/freetds/freetds-0.52/src/ctlib/unittests'
make[3]: Leaving directory
`/usr/local/freetds/freetds-0.52/src/ctlib/unittests'
make[3]: Entering directory `/usr/local/freetds/freetds-0.52/src/ctlib'
make[3]: Nothing to be done for `check-am'.
make[3]: Leaving directory `/usr/local/freetds/freetds-0.52/src/ctlib'
make[2]: Leaving directory `/usr/local/freetds/freetds-0.52/src/ctlib'
Making check in dblib
make[2]: Entering directory `/usr/local/freetds/freetds-0.52/src/dblib'
Making check in unittests
make[3]: Entering directory
`/usr/local/freetds/freetds-0.52/src/dblib/unittests'
make check-TESTS
make[4]: Entering directory
`/usr/local/freetds/freetds-0.52/src/dblib/unittests'
Start
About to logon
About to open
Dropping table
creating table
insert
insert into dblib0001 values (0, 'row 000')
insert into dblib0001 values (1, 'row 001')
insert into dblib0001 values (2, 'row 002')
insert into dblib0001 values (3, 'row 003')
insert into dblib0001 values (4, 'row 004')
insert into dblib0001 values (5, 'row 005')
insert into dblib0001 values (6, 'row 006')
insert into dblib0001 values (7, 'row 007')
insert into dblib0001 values (8, 'row 008')
insert into dblib0001 values (9, 'row 009')
insert into dblib0001 values (10, 'row 010')
insert into dblib0001 values (11, 'row 011')
insert into dblib0001 values (12, 'row 012')
insert into dblib0001 values (13, 'row 013')
insert into dblib0001 values (14, 'row 014')
insert into dblib0001 values (15, 'row 015')
insert into dblib0001 values (16, 'row 016')
insert into dblib0001 values (17, 'row 017')
insert into dblib0001 values (18, 'row 018')
insert into dblib0001 values (19, 'row 019')
insert into dblib0001 values (20, 'row 020')
insert into dblib0001 values (21, 'row 021')
insert into dblib0001 values (22, 'row 022')
insert into dblib0001 values (23, 'row 023')
insert into dblib0001 values (24, 'row 024')
insert into dblib0001 values (25, 'row 025')
insert into dblib0001 values (26, 'row 026')
insert into dblib0001 values (27, 'row 027')
insert into dblib0001 values (28, 'row 028')
insert into dblib0001 values (29, 'row 029')
insert into dblib0001 values (30, 'row 030')
insert into dblib0001 values (31, 'row 031')
insert into dblib0001 values (32, 'row 032')
insert into dblib0001 values (33, 'row 033')
insert into dblib0001 values (34, 'row 034')
insert into dblib0001 values (35, 'row 035')
insert into dblib0001 values (36, 'row 036')
insert into dblib0001 values (37, 'row 037')
insert into dblib0001 values (38, 'row 038')
insert into dblib0001 values (39, 'row 039')
insert into dblib0001 values (40, 'row 040')
insert into dblib0001 values (41, 'row 041')
insert into dblib0001 values (42, 'row 042')
insert into dblib0001 values (43, 'row 043')
insert into dblib0001 values (44, 'row 044')
insert into dblib0001 values (45, 'row 045')
insert into dblib0001 values (46, 'row 046')
insert into dblib0001 values (47, 'row 047')
insert into dblib0001 values (48, 'row 048')
insert into dblib0001 values (49, 'row 049')
select
col 1 is i
col 2 is s
Read a row of data -> 0 row 000
Read a row of data -> 1 row 001
Read a row of data -> 2 row 002
Read a row of data -> 3 row 003
Read a row of data -> 4 row 004
Read a row of data -> 5 row 005
Read a row of data -> 6 row 006
Read a row of data -> 7 row 007
Read a row of data -> 8 row 008
Read a row of data -> 9 row 009
Read a row of data -> 10 row 010
Read a row of data -> 11 row 011
Read a row of data -> 12 row 012
Read a row of data -> 13 row 013
Read a row of data -> 14 row 014

Read a row of data -> 15 row 015
Read a row of data -> 16 row 016
Read a row of data -> 17 row 017
Read a row of data -> 18 row 018
Read a row of data -> 19 row 019
Read a row of data -> 20 row 020
Read a row of data -> 21 row 021
Read a row of data -> 22 row 022
Read a row of data -> 23 row 023
Read a row of data -> 24 row 024
Read a row of data -> 25 row 025
Read a row of data -> 26 row 026
Read a row of data -> 27 row 027
Read a row of data -> 28 row 028
Read a row of data -> 29 row 029
Read a row of data -> 30 row 030
Read a row of data -> 31 row 031
Read a row of data -> 32 row 032
Read a row of data -> 33 row 033
Read a row of data -> 34 row 034
Read a row of data -> 35 row 035
Read a row of data -> 36 row 036
Read a row of data -> 37 row 037
Read a row of data -> 38 row 038
Read a row of data -> 39 row 039
Read a row of data -> 40 row 040
Read a row of data -> 41 row 041
Read a row of data -> 42 row 042
Read a row of data -> 43 row 043
Read a row of data -> 44 row 044
Read a row of data -> 45 row 045
Read a row of data -> 46 row 046
Read a row of data -> 47 row 047
Read a row of data -> 48 row 048
Read a row of data -> 49 row 049
dblib okay on t0001.c
PASS: t0001
Start
About to logon
About to open
Dropping table
creating table
insert
select
col 1 is i
col 2 is s
Read a row of data -> 1 row 001
Read a row of data -> 2 row 002
Read a row of data -> 3 row 003
Read a row of data -> 4 row 004
Read a row of data -> 5 row 005
Read a row of data -> 6 row 006
Read a row of data -> 7 row 007
Read a row of data -> 8 row 008
Read a row of data -> 9 row 009
Read a row of data -> 10 row 010
Read a row of data -> 1 row 001
Read a row of data -> 2 row 002
Read a row of data -> 10 row 010
Read a row of data -> 11 row 011
Read a row of data -> 12 row 012
dblib okay on t0002.c
PASS: t0002
Start
About to logon
About to open
Dropping table
creating table
insert
select
col 1 is i
col 2 is s
Read a row of data -> 1 row 001
Read a row of data -> 2 row 002
Read a row of data -> 3 row 003
Read a row of data -> 4 row 004
Read a row of data -> 5 row 005
Read a row of data -> 6 row 006
Read a row of data -> 7 row 007
Read a row of data -> 8 row 008
Read a row of data -> 9 row 009
Read a row of data -> 10 row 010
Read a row of data -> 11 row 011
Read a row of data -> 12 row 012
Read a row of data -> 13 row 013
Read a row of data -> 14 row 014
Read a row of data -> 15 row 015
Read a row of data -> 16 row 016
Read a row of data -> 17 row 017
Read a row of data -> 18 row 018
Read a row of data -> 19 row 019
Read a row of data -> 20 row 020
Read a row of data -> 21 row 021
Read a row of data -> 22 row 022
Read a row of data -> 23 row 023
Read a row of data -> 24 row 024
Read a row of data -> 25 row 025
Read a row of data -> 26 row 026
Read a row of data -> 27 row 027
Read a row of data -> 28 row 028
Read a row of data -> 29 row 029
Read a row of data -> 30 row 030
Read a row of data -> 31 row 031
Read a row of data -> 32 row 032
Read a row of data -> 33 row 033
Read a row of data -> 34 row 034
Read a row of data -> 35 row 035
Read a row of data -> 36 row 036
Read a row of data -> 37 row 037
Read a row of data -> 38 row 038
Read a row of data -> 39 row 039
Read a row of data -> 40 row 040
Read a row of data -> 41 row 041
Read a row of data -> 42 row 042
Read a row of data -> 43 row 043
Read a row of data -> 44 row 044
Read a row of data -> 45 row 045
Read a row of data -> 46 row 046
Read a row of data -> 47 row 047
Read a row of data -> 48 row 048
Read a row of data -> 49 row 049
dblib okay on t0003.c
PASS: t0003
Start
About to logon
About to open
Dropping table
creating table
insert
insert into dblib0004 values (1, 'row 0001')
insert into dblib0004 values (2, 'row 0002')
insert into dblib0004 values (3, 'row 0003')
insert into dblib0004 values (4, 'row 0004')
insert into dblib0004 values (5, 'row 0005')
insert into dblib0004 values (6, 'row 0006')
insert into dblib0004 values (7, 'row 0007')
insert into dblib0004 values (8, 'row 0008')
insert into dblib0004 values (9, 'row 0009')
insert into dblib0004 values (10, 'row 0010')
insert into dblib0004 values (11, 'row 0011')
insert into dblib0004 values (12, 'row 0012')
insert into dblib0004 values (13, 'row 0013')
insert into dblib0004 values (14, 'row 0014')
insert into dblib0004 values (15, 'row 0015')
insert into dblib0004 values (16, 'row 0016')
insert into dblib0004 values (17, 'row 0017')
insert into dblib0004 values (18, 'row 0018')
insert into dblib0004 values (19, 'row 0019')
insert into dblib0004 values (20, 'row 0020')
insert into dblib0004 values (21, 'row 0021')
insert into dblib0004 values (22, 'row 0022')
insert into dblib0004 values (23, 'row 0023')
insert into dblib0004 values (24, 'row 0024')
insert into dblib0004 values (25, 'row 0025')
insert into dblib0004 values (26, 'row 0026')
insert into dblib0004 values (27, 'row 0027')
insert into dblib0004 values (28, 'row 0028')
insert into dblib0004 values (29, 'row 0029')
insert into dblib0004 values (30, 'row 0030')
insert into dblib0004 values (31, 'row 0031')
insert into dblib0004 values (32, 'row 0032')
insert into dblib0004 values (33, 'row 0033')
insert into dblib0004 values (34, 'row 0034')
insert into dblib0004 values (35, 'row 0035')
insert into dblib0004 values (36, 'row 0036')
insert into dblib0004 values (37, 'row 0037')
insert into dblib0004 values (38, 'row 0038')
insert into dblib0004 values (39, 'row 0039')
insert into dblib0004 values (40, 'row 0040')
insert into dblib0004 values (41, 'row 0041')
insert into dblib0004 values (42, 'row 0042')
insert into dblib0004 values (43, 'row 0043')
insert into dblib0004 values (44, 'row 0044')
insert into dblib0004 values (45, 'row 0045')
insert into dblib0004 values (46, 'row 0046')
insert into dblib0004 values (47, 'row 0047')
insert into dblib0004 values (48, 'row 0048')
insert into dblib0004 values (49, 'row 0049')
select * from dblib0004 where i<=25 order by i
col 1 is i
col 2 is s
Read a row of data -> 1 row 0001
Read a row of data -> 2 row 0002
Read a row of data -> 3 row 0003
Read a row of data -> 4 row 0004
Read a row of data -> 5 row 0005
Read a row of data -> 6 row 0006
Read a row of data -> 7 row 0007
Read a row of data -> 8 row 0008
Read a row of data -> 9 row 0009
Read a row of data -> 10 row 0010
Read a row of data -> 11 row 0011
Read a row of data -> 12 row 0012
Read a row of data -> 13 row 0013
Read a row of data -> 14 row 0014
Read a row of data -> 15 row 0015
Read a row of data -> 16 row 0016
Read a row of data -> 17 row 0017
Read a row of data -> 18 row 0018
Read a row of data -> 19 row 0019
Read a row of data -> 20 row 0020
Read a row of data -> 21 row 0021
Read a row of data -> 22 row 0022
Read a row of data -> 23 row 0023
Read a row of data -> 24 row 0024
Read a row of data -> 25 row 0025
second select
select * from dblib0004 where i>950 order by i
About to exec for the second time. Should fail
dblib okay on t0004.c
PASS: t0004
Start
About to logon
About to open
Dropping table
creating table
insert
select * from dblib0005 where i<50 order by i
col 1 is i
col 2 is s
Read a row of data -> 1 row 0001
Read a row of data -> 2 row 0002
Read a row of data -> 3 row 0003
Read a row of data -> 4 row 0004
Read a row of data -> 5 row 0005
Read a row of data -> 6 row 0006
Read a row of data -> 7 row 0007
Read a row of data -> 8 row 0008
Read a row of data -> 9 row 0009
Read a row of data -> 10 row 0010
Read a row of data -> 11 row 0011
Read a row of data -> 12 row 0012
Read a row of data -> 13 row 0013
Read a row of data -> 14 row 0014
Read a row of data -> 15 row 0015
Read a row of data -> 16 row 0016
Read a row of data -> 17 row 0017
Read a row of data -> 18 row 0018
Read a row of data -> 19 row 0019
Read a row of data -> 20 row 0020
Read a row of data -> 21 row 0021
Read a row of data -> 22 row 0022
Read a row of data -> 23 row 0023
Read a row of data -> 24 row 0024
Read a row of data -> 25 row 0025
Read a row of data -> 26 row 0026
Read a row of data -> 27 row 0027
Read a row of data -> 28 row 0028
Read a row of data -> 29 row 0029
Read a row of data -> 30 row 0030
Read a row of data -> 31 row 0031
Read a row of data -> 32 row 0032
Read a row of data -> 33 row 0033
Read a row of data -> 34 row 0034
Read a row of data -> 35 row 0035
Read a row of data -> 36 row 0036
Read a row of data -> 37 row 0037
Read a row of data -> 38 row 0038
Read a row of data -> 39 row 0039
Read a row of data -> 40 row 0040
Read a row of data -> 41 row 0041
Read a row of data -> 42 row 0042
Read a row of data -> 43 row 0043
Read a row of data -> 44 row 0044
Read a row of data -> 45 row 0045
Read a row of data -> 46 row 0046
Read a row of data -> 47 row 0047
Read a row of data -> 48 row 0048
Read a row of data -> 49 row 0049
select * from dblib0005 where i>950 order by i
dblib okay on t0005.c
PASS: t0005
Start
About to logon
About to open
Dropping table
creating table
insert
first select
col 1 is i
col 2 is s
Read a row of data -> 1 row 0001
Read a row of data -> 2 row 0002
Read a row of data -> 3 row 0003
Read a row of data -> 4 row 0004
Read a row of data -> 5 row 0005
Read a row of data -> 6 row 0006

Read a row of data -> 7 row 0007
Read a row of data -> 8 row 0008
Read a row of data -> 9 row 0009
Read a row of data -> 10 row 0010
Read a row of data -> 11 row 0011
Read a row of data -> 12 row 0012
Read a row of data -> 13 row 0013
Read a row of data -> 14 row 0014
Read a row of data -> 15 row 0015
Read a row of data -> 16 row 0016
Read a row of data -> 17 row 0017
Read a row of data -> 18 row 0018
Read a row of data -> 19 row 0019
Read a row of data -> 20 row 0020
Read a row of data -> 21 row 0021
Read a row of data -> 22 row 0022
Read a row of data -> 23 row 0023
Read a row of data -> 24 row 0024
Read a row of data -> 25 row 0025
Read a row of data -> 26 row 0026
Read a row of data -> 27 row 0027
Read a row of data -> 28 row 0028
Read a row of data -> 29 row 0029
Read a row of data -> 30 row 0030
Read a row of data -> 31 row 0031
Read a row of data -> 32 row 0032
Read a row of data -> 33 row 0033
Read a row of data -> 34 row 0034
Read a row of data -> 35 row 0035
Read a row of data -> 36 row 0036
Read a row of data -> 37 row 0037
Read a row of data -> 38 row 0038
Read a row of data -> 39 row 0039
Read a row of data -> 40 row 0040
Read a row of data -> 41 row 0041
Read a row of data -> 42 row 0042
Read a row of data -> 43 row 0043
Read a row of data -> 44 row 0044
Read a row of data -> 45 row 0045
Read a row of data -> 46 row 0046
Read a row of data -> 47 row 0047
Read a row of data -> 48 row 0048
Read a row of data -> 49 row 0049
second select
Read a row of data -> 25 row 0025
Read a row of data -> 26 row 0026
Read a row of data -> 27 row 0027
Read a row of data -> 28 row 0028
Read a row of data -> 29 row 0029
Read a row of data -> 30 row 0030
Read a row of data -> 31 row 0031
Read a row of data -> 32 row 0032
Read a row of data -> 33 row 0033
Read a row of data -> 34 row 0034
Read a row of data -> 35 row 0035
Read a row of data -> 36 row 0036
Read a row of data -> 37 row 0037
Read a row of data -> 38 row 0038
Read a row of data -> 39 row 0039
Read a row of data -> 40 row 0040
Read a row of data -> 41 row 0041
Read a row of data -> 42 row 0042
Read a row of data -> 43 row 0043
Read a row of data -> 44 row 0044
Read a row of data -> 45 row 0045
Read a row of data -> 46 row 0046
Read a row of data -> 47 row 0047
Read a row of data -> 48 row 0048
Read a row of data -> 49 row 0049
dblib okay on t0006.c
PASS: t0006
Start
About to logon
About to open
Dropping table
creating table
insert
insert into dblib0007 values (1, 'row 0000001')
insert into dblib0007 values (2, 'row 0000002')
insert into dblib0007 values (3, 'row 0000003')
insert into dblib0007 values (4, 'row 0000004')
insert into dblib0007 values (5, 'row 0000005')
insert into dblib0007 values (6, 'row 0000006')
insert into dblib0007 values (7, 'row 0000007')
insert into dblib0007 values (8, 'row 0000008')
insert into dblib0007 values (9, 'row 0000009')
select * from dblib0007 where i<=5 order by i
col 1 is i
col 2 is s
Read a row of data -> 1 row 0000001
Read a row of data -> 2 row 0000002
second select
select * from dblib0007 where i>=5 order by i
dblib okay on t0007.c
PASS: t0007

Start
About to logon
About to open
Dropping table
creating table
insert
select
col 1 is i
col 2 is s
Read a row of data -> 1 row 001
Read a row of data -> 2 row 002
Read a row of data -> 3 row 003
Read a row of data -> 4 row 004
Read a row of data -> 5 row 005
Read a row of data -> 6 row 006
Read a row of data -> 7 row 007
Read a row of data -> 8 row 008
Read a row of data -> 9 row 009
Read a row of data -> 10 row 010
Read a row of data -> 11 row 011
Read a row of data -> 12 row 012
Read a row of data -> 13 row 013
Read a row of data -> 14 row 014
Read a row of data -> 15 row 015
Read a row of data -> 16 row 016
Read a row of data -> 17 row 017
Read a row of data -> 18 row 018
Read a row of data -> 19 row 019
Read a row of data -> 20 row 020
Read a row of data -> 21 row 021
Read a row of data -> 22 row 022
Read a row of data -> 23 row 023
Read a row of data -> 24 row 024
Read a row of data -> 25 row 025
Read a row of data -> 26 row 026
Read a row of data -> 27 row 027
Read a row of data -> 28 row 028
Read a row of data -> 29 row 029
Read a row of data -> 30 row 030
Read a row of data -> 31 row 031
Read a row of data -> 32 row 032
Read a row of data -> 33 row 033
Read a row of data -> 34 row 034
Read a row of data -> 35 row 035
Read a row of data -> 36 row 036
Read a row of data -> 37 row 037
Read a row of data -> 38 row 038
Read a row of data -> 39 row 039
Read a row of data -> 40 row 040
Read a row of data -> 41 row 041
Read a row of data -> 42 row 042
Read a row of data -> 43 row 043
Read a row of data -> 44 row 044
Read a row of data -> 45 row 045
Read a row of data -> 46 row 046
Read a row of data -> 47 row 047
Read a row of data -> 48 row 048
PASS: t0008
Start
About to logon
About to open
Dropping table
creating table
insert
select
col 1 is i
col 2 is s
FAIL: t0009
Start
About to logon
About to open
Dropping table
creating table
insert
select
col 1 is i
col 2 is s
PASS: t0010
Start
About to logon
About to open
Dropping table
creating table
insert
insert into dblib0011 values (1, 'This is a really long column to ensure that
the next row ends properly.','This is a really long column to ensure that the
next row ends properly.','This is a really long column to ensure that the
next row ends properly.')
insert into dblib0011 values (2, 'Short column','Short column','Short column')
insert into dblib0011 values (3, 'Short column',NULL,NULL)
select
col 1 is i
col 2 is c1
col 3 is c2
col 4 is vc
c: This is a really long column to ensure that the next row ends properly.

$
c2: This is a really long column to ensure that the next row ends properly.

$
vc: This is a really long column to ensure that the next row ends properly.$
c: Short column

$
c2: Short column

$
vc: Short column$
c: Short column

$
c2: Short column

$
vc: Short column$
dblib okay on t0011.c
PASS: t0011
Start
About to logon
About to open, PASSWORD: , USER: , SERVER:
After logon
tempdb: Sep 24 2001 05:54PM
Year = 2001.
Month = 8.
Day of month = 24.
Day of year = 267.
Day of week = 1.
Hour = 17.
Minute = 54.
Second = 54.
Millisecond = 345.
dblib okay on t0012.c
PASS: t0012
Start
About to logon
About to open, PASSWORD: , USER: , SERVER:
After logon
About to read binary input file
FAIL: t0013
Start
About to logon
About to open, PASSWORD: , USER: , SERVER:
After logon
About to read binary input file
FAIL: t0014
Start
About to logon
About to open
Dropping table
creating table
insert
insert into dblib0015 values (0, 'row 000')
insert into dblib0015 values (1, 'row 001')
insert into dblib0015 values (2, 'row 002')
insert into dblib0015 values (3, 'row 003')
insert into dblib0015 values (4, 'row 004')
insert into dblib0015 values (5, 'row 005')
insert into dblib0015 values (6, 'row 006')
insert into dblib0015 values (7, 'row 007')
insert into dblib0015 values (8, 'row 008')
insert into dblib0015 values (9, 'row 009')
insert into dblib0015 values (10, 'row 010')
insert into dblib0015 values (11, 'row 011')
insert into dblib0015 values (12, 'row 012')
insert into dblib0015 values (13, 'row 013')
insert into dblib0015 values (14, 'row 014')
insert into dblib0015 values (15, 'row 015')
insert into dblib0015 values (16, 'row 016')
insert into dblib0015 values (17, 'row 017')
insert into dblib0015 values (18, 'row 018')
insert into dblib0015 values (19, 'row 019')
insert into dblib0015 values (20, 'row 020')
insert into dblib0015 values (21, 'row 021')
insert into dblib0015 values (22, 'row 022')
insert into dblib0015 values (23, 'row 023')
insert into dblib0015 values (24, 'row 024')
insert into dblib0015 values (25, 'row 025')
insert into dblib0015 values (26, 'row 026')
insert into dblib0015 values (27, 'row 027')
insert into dblib0015 values (28, 'row 028')
insert into dblib0015 values (29, 'row 029')
insert into dblib0015 values (30, 'row 030')
insert into dblib0015 values (31, 'row 031')
insert into dblib0015 values (32, 'row 032')
insert into dblib0015 values (33, 'row 033')
insert into dblib0015 values (34, 'row 034')
insert into dblib0015 values (35, 'row 035')
insert into dblib0015 values (36, 'row 036')
insert into dblib0015 values (37, 'row 037')
insert into dblib0015 values (38, 'row 038')
insert into dblib0015 values (39, 'row 039')
insert into dblib0015 values (40, 'row 040')
insert into dblib0015 values (41, 'row 041')
insert into dblib0015 values (42, 'row 042')
insert into dblib0015 values (43, 'row 043')
insert into dblib0015 values (44, 'row 044')
insert into dblib0015 values (45, 'row 045')
insert into dblib0015 values (46, 'row 046')
insert into dblib0015 values (47, 'row 047')
insert into dblib0015 values (48, 'row 048')
insert into dblib0015 values (49, 'row 049')
select
col 1 is i
col 2 is s
select 2
Read a row of data -> 26 row 026
Read a row of data -> 27 row 027
Read a row of data -> 28 row 028
Read a row of data -> 29 row 029
Read a row of data -> 30 row 030
Read a row of data -> 31 row 031
Read a row of data -> 32 row 032
Read a row of data -> 33 row 033
Read a row of data -> 34 row 034
Read a row of data -> 35 row 035
Read a row of data -> 36 row 036
Read a row of data -> 37 row 037
Read a row of data -> 38 row 038
Read a row of data -> 39 row 039
Read a row of data -> 40 row 040
Read a row of data -> 41 row 041
Read a row of data -> 42 row 042
Read a row of data -> 43 row 043
Read a row of data -> 44 row 044
Read a row of data -> 45 row 045
Read a row of data -> 46 row 046
Read a row of data -> 47 row 047
Read a row of data -> 48 row 048
Read a row of data -> 49 row 049
dblib okay on t0015.c
PASS: t0015
Start
About to logon
About to open, PASSWORD: , USER: , SERVER:
After logon
Dropping table
Creating table
1175 rows copied in
0 rows copied out
dblib okay on t0016.c
PASS: t0016
Start
About to logon
About to open, PASSWORD: , USER: , SERVER:
After logon
Dropping table
Creating table
1175 rows copied
dblib okay on t0017.c
PASS: t0017
Start
About to logon
About to open
Dropping table
creating table
insert
insert into dblib0018 values (0, 'row 000')
insert into dblib0018 values (1, 'row 001')
insert into dblib0018 values (2, 'row 002')
insert into dblib0018 values (3, 'row 003')
insert into dblib0018 values (4, 'row 004')
insert into dblib0018 values (5, 'row 005')
insert into dblib0018 values (6, 'row 006')
insert into dblib0018 values (7, 'row 007')
insert into dblib0018 values (8, 'row 008')
insert into dblib0018 values (9, 'row 009')
insert into dblib0018 values (10, 'row 010')
insert into dblib0018 values (11, 'row 011')
insert into dblib0018 values (12, 'row 012')
insert into dblib0018 values (13, 'row 013')
insert into dblib0018 values (14, 'row 014')
insert into dblib0018 values (15, 'row 015')
insert into dblib0018 values (16, 'row 016')
insert into dblib0018 values (17, 'row 017')
insert into dblib0018 values (18, 'row 018')
insert into dblib0018 values (19, 'row 019')
insert into dblib0018 values (20, 'row 020')
insert into dblib0018 values (21, 'row 021')
insert into dblib0018 values (22, 'row 022')
insert into dblib0018 values (23, 'row 023')
insert into dblib0018 values (24, 'row 024')
insert into dblib0018 values (25, 'row 025')
insert into dblib0018 values (26, 'row 026')
insert into dblib0018 values (27, 'row 027')
insert into dblib0018 values (28, 'row 028')
insert into dblib0018 values (29, 'row 029')
insert into dblib0018 values (30, 'row 030')
insert into dblib0018 values (31, 'row 031')
insert into dblib0018 values (32, 'row 032')
insert into dblib0018 values (33, 'row 033')
insert into dblib0018 values (34, 'row 034')

insert into dblib0018 values (35, 'row 035')
insert into dblib0018 values (36, 'row 036')
insert into dblib0018 values (37, 'row 037')
insert into dblib0018 values (38, 'row 038')
insert into dblib0018 values (39, 'row 039')
insert into dblib0018 values (40, 'row 040')
insert into dblib0018 values (41, 'row 041')
insert into dblib0018 values (42, 'row 042')
insert into dblib0018 values (43, 'row 043')
insert into dblib0018 values (44, 'row 044')
insert into dblib0018 values (45, 'row 045')
insert into dblib0018 values (46, 'row 046')
insert into dblib0018 values (47, 'row 047')
insert into dblib0018 values (48, 'row 048')
insert into dblib0018 values (49, 'row 049')
select
col 1 is i
col 2 is s
Read a row of data -> 0 row 000
Read a row of data -> 1 row 001
Read a row of data -> 2 row 002
Read a row of data -> 3 row 003
Read a row of data -> 4 row 004
Read a row of data -> 5 row 005
Read a row of data -> 6 row 006
Read a row of data -> 7 row 007
Read a row of data -> 8 row 008
Read a row of data -> 9 row 009
Read a row of data -> 10 row 010
Read a row of data -> 11 row 011
Read a row of data -> 12 row 012
Read a row of data -> 13 row 013
Read a row of data -> 14 row 014
Read a row of data -> 15 row 015
Read a row of data -> 16 row 016
Read a row of data -> 17 row 017
Read a row of data -> 18 row 018
Read a row of data -> 19 row 019
Read a row of data -> 20 row 020
Read a row of data -> 21 row 021
Read a row of data -> 22 row 022
Read a row of data -> 23 row 023
Read a row of data -> 24 row 024
Read a row of data -> 25 row 025
Read a row of data -> 26 row 026
Read a row of data -> 27 row 027
Read a row of data -> 28 row 028
Read a row of data -> 29 row 029
Read a row of data -> 30 row 030
Read a row of data -> 31 row 031
Read a row of data -> 32 row 032
Read a row of data -> 33 row 033
Read a row of data -> 34 row 034
Read a row of data -> 35 row 035
Read a row of data -> 36 row 036
Read a row of data -> 37 row 037
Read a row of data -> 38 row 038
Read a row of data -> 39 row 039
Read a row of data -> 40 row 040
Read a row of data -> 41 row 041
Read a row of data -> 42 row 042
Read a row of data -> 43 row 043
Read a row of data -> 44 row 044
Read a row of data -> 45 row 045
Read a row of data -> 46 row 046
Read a row of data -> 47 row 047
Read a row of data -> 48 row 048
Read a row of data -> 49 row 049
Number of rows affected by update = 50.
dblib okay on t0018.c
PASS: t0018
Start
About to logon
About to open
Dropping table
creating table
insert
insert into dblib0018 values (0, 'row 000')
insert into dblib0018 values (1, 'row 001')
insert into dblib0018 values (2, 'row 002')
insert into dblib0018 values (3, 'row 003')
insert into dblib0018 values (4, 'row 004')
insert into dblib0018 values (5, 'row 005')
insert into dblib0018 values (6, 'row 006')
insert into dblib0018 values (7, 'row 007')
insert into dblib0018 values (8, 'row 008')
insert into dblib0018 values (9, 'row 009')
insert into dblib0018 values (10, 'row 010')
insert into dblib0018 values (11, 'row 011')
insert into dblib0018 values (12, 'row 012')
insert into dblib0018 values (13, 'row 013')
insert into dblib0018 values (14, 'row 014')
insert into dblib0018 values (15, 'row 015')
insert into dblib0018 values (16, 'row 016')
insert into dblib0018 values (17, 'row 017')
insert into dblib0018 values (18, 'row 018')
insert into dblib0018 values (19, 'row 019')
insert into dblib0018 values (20, 'row 020')
insert into dblib0018 values (21, 'row 021')
insert into dblib0018 values (22, 'row 022')
insert into dblib0018 values (23, 'row 023')
insert into dblib0018 values (24, 'row 024')
insert into dblib0018 values (25, 'row 025')
insert into dblib0018 values (26, 'row 026')
insert into dblib0018 values (27, 'row 027')
insert into dblib0018 values (28, 'row 028')
insert into dblib0018 values (29, 'row 029')
insert into dblib0018 values (30, 'row 030')
insert into dblib0018 values (31, 'row 031')
insert into dblib0018 values (32, 'row 032')
insert into dblib0018 values (33, 'row 033')
insert into dblib0018 values (34, 'row 034')
insert into dblib0018 values (35, 'row 035')
insert into dblib0018 values (36, 'row 036')
insert into dblib0018 values (37, 'row 037')
insert into dblib0018 values (38, 'row 038')
insert into dblib0018 values (39, 'row 039')
insert into dblib0018 values (40, 'row 040')
insert into dblib0018 values (41, 'row 041')
insert into dblib0018 values (42, 'row 042')
insert into dblib0018 values (43, 'row 043')
insert into dblib0018 values (44, 'row 044')
insert into dblib0018 values (45, 'row 045')
insert into dblib0018 values (46, 'row 046')
insert into dblib0018 values (47, 'row 047')
insert into dblib0018 values (48, 'row 048')
insert into dblib0018 values (49, 'row 049')
select
col 1 is i
col 2 is s
Read a row of data -> 0 row 000
Read a row of data -> 1 row 001
Read a row of data -> 2 row 002
Read a row of data -> 3 row 003
Read a row of data -> 4 row 004
Read a row of data -> 5 row 005
Read a row of data -> 6 row 006
Read a row of data -> 7 row 007
Read a row of data -> 8 row 008
Read a row of data -> 9 row 009
Read a row of data -> 10 row 010
Read a row of data -> 11 row 011
Read a row of data -> 12 row 012
Read a row of data -> 13 row 013
Read a row of data -> 14 row 014
Read a row of data -> 15 row 015
Read a row of data -> 16 row 016
Read a row of data -> 17 row 017
Read a row of data -> 18 row 018
Read a row of data -> 19 row 019
Read a row of data -> 20 row 020
Read a row of data -> 21 row 021
Read a row of data -> 22 row 022
Read a row of data -> 23 row 023
Read a row of data -> 24 row 024
Read a row of data -> 25 row 025
Read a row of data -> 26 row 026
Read a row of data -> 27 row 027
Read a row of data -> 28 row 028
Read a row of data -> 29 row 029
Read a row of data -> 30 row 030
Read a row of data -> 31 row 031
Read a row of data -> 32 row 032
Read a row of data -> 33 row 033
Read a row of data -> 34 row 034
Read a row of data -> 35 row 035
Read a row of data -> 36 row 036
Read a row of data -> 37 row 037
Read a row of data -> 38 row 038
Read a row of data -> 39 row 039
Read a row of data -> 40 row 040
Read a row of data -> 41 row 041
Read a row of data -> 42 row 042
Read a row of data -> 43 row 043
Read a row of data -> 44 row 044
Read a row of data -> 45 row 045
Read a row of data -> 46 row 046
Read a row of data -> 47 row 047
Read a row of data -> 48 row 048
Read a row of data -> 49 row 049
Number of rows affected by update = 50.
dblib okay on t0018.c
PASS: t0019
Start
About to logon
About to open
dblib okay on t0020.c
PASS: t0020
====================
3 of 20 tests failed
====================
make[4]: Leaving directory
`/usr/local/freetds/freetds-0.52/src/dblib/unittests'
make[3]: Leaving directory
`/usr/local/freetds/freetds-0.52/src/dblib/unittests'
make[2]: Leaving directory `/usr/local/freetds/freetds-0.52/src/dblib'
make[1]: Leaving directory `/usr/local/freetds/freetds-0.52/src'

*******************************************************

However even though the 0.52 version passed most tests, when I try to compile
the DBD-Sybase-0.91 Perl package, when I run the make check I get the
following error

*******************************************************
make test results

[root@instep DBD-Sybase-0.91]# make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib
-I/usr/lib/perl5/5.
00503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests
$ve
rbose); $verbose=0; runtests @ARGV;' t/*.t
t/autocommit........dubious
Test returned status 0 (wstat 11, 0xb)
Undefined subroutine &Test::Harness::WCOREDUMP called at
/usr/lib/perl5/5.00503/
Test/Harness.pm line 288.
make: *** [test_dynamic] Error 255
*******************************************************
I will try just working with it to see if I get it to work as expected. But
you may want to address the test issue with Version 0.53 before releasing it.

Sincerely,

Richard Norman
Web/Application Engineer

Research & Development Department
Corporate Information Systems

Saint Agnes Medical Center
1303 E. Herndon
Mail Stop #900
Fresno, CA 93720

Email: Richard.Norman AT samc.com

P.S. - :-) Just before I sent this email, I tried again and this time it
worked with the Sybase driver 0.91 and the TDS version 7.0 protocol. I used
FreeTDS version 0.52 to do this since the 0.53 had check errors. I would
love to have ODBC (using unixODBC) working, the command line tool works, but
the Perl module did not. Here is the error from the Perl Module

Unable to connect: [unixODBC]Could not find DSN in connect string (SQL-08001)
[unixODBC]Could not find Database parameter (SQL-08001)(DBD:
db_login/SQLConnect err=-1)

And here is the command line tool results:

[root@instep bin]# ./isql paging pager pageradmin -v
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>

If anyone can figure this out, or would like me to try to help (I am not that
good in Perl or Unix C but I have some Windows C and C++ experience) let me
know.


-----Original Message-----

From: camber AT ais.org
Sent: Wednesday, October 03, 2001 5:52 PM
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: [freetds] RE: DBD::Sybase, FreeTDS, Solaris 2.7, Perl 5.6.1



Well, first off DBD::Sybase 0.93 does not work with freetds, or i
suppose
i should say freetds doesn't work with 0.93....

So, for 0.91. FreeTDS 0.52 had problems in several configurations
that
would cause a core dump. This was fixed in the subsequent development
cycle and is in 0.53pre1.

I would like to hear about errors with 0.53pre1 before I release the
final
0.53. Please post specifics of your configuration (freetds.conf or
interfaces file, PWD file, which test it bombs on). Note that not all
DBD::Sybase features are supported by FreeTDS (most notably
placeholders) so some errors on 'make test' are to be expected.

I assume the second line in the chart should read '0.91 pre0.51 ...'
as
there is no way 0.93 would have compiled with 0.51, or any releases prior
or since for that matter.

Brian

On Wed, 3 Oct 2001, Richard Norman wrote:

> YESS!!!! This is partly what I have been seeing as well. I have
only tried FreeTDS 0.52 & 0.53 and DBD::Sybase 0.91 & 0.93. But I have also
tried DBD::ODBC 0.28 / unixODBC as well.

>
> HELP US!!!
>
> : )
>
> Richard Norman
>
> Original Message
> From: wrayburn AT cisco.com
> Sent: Wednesday, October 03, 2001 4:21 PM
> To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
> Subject: [freetds] DBD::Sybase, FreeTDS, Solaris 2.7, Perl 5.6.1
>
>
>
> Below are my results testing different client combinations
> of DBD::Sybase and FreeTDS, with Solaris 2.7 and Perl 5.6.1.
> Server is SQL Server 7, TDS is 4.2.
>
> DBD::Sybase FreeTDS Result
>
> 0.22 pre 0.51 compile, run ok
> 0.93 pre 0.51 compile, run ok
>
> 0.22 0.51 compile, run ok
> 0.91 0.51 compile, run ok
> 0.93 0.51 DBD::Sybase compile error
>
> 0.22 0.52 compiled, but DBD/Sybase.pm runtime error
> 0.23 0.52 DBD::Sybase compile error
> 0.91 0.52 compiled, but runtime core dump
> 0.93 0.52 DBD::Sybase compile error
>
> pre 0.51 refers to whatever state I grabbed out of CVS before 0.51,
> a long time ago.
>
> Have other people seen the same results using the same
> combinations with 0.51 and 0.52?
>
> Thanks,
> Bill
>
>
>
> You are currently subscribed to freetds as: [normri AT samc.com]
> To unsubscribe, forward this message to leave freetds
> 137192W AT franklin.oit.unc.edu
>
>
>
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to leave freetds
> 137192W AT franklin.oit.unc.edu
>



You are currently subscribed to freetds as: [normri AT samc.com]
To unsubscribe, forward this message to leave freetds
137192W AT franklin.oit.unc.edu





Archive powered by MHonArc 2.6.24.

Top of Page