Skip to Content.
Sympa Menu

freetds - RE: TODO

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: TODO
  • Date: Wed, 4 Sep 2002 17:02:46 +0100


Brian

Freetds latest snapshot;
sqsh 1.4 (db-library version);
Solaris 2.6

This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
1> use master
2>
(0 rows affected)
1> select * from sysusers
2>
suid uid gid name environ


------ ------ ------ ------------------------------
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
--------------------------------------------------------
-------------------------------------------
-16389 16389 16389 replication_role NULL


-16388 16388 16388 navigator_role NULL


-16387 16387 16387 sybase_ts_role NULL


-16386 16386 16386 oper_role NULL


-16385 16385 16385 sso_role NULL

etc. etc.

(10 rows affected)
1> sp_help sysusers
2>
Name Owner Type
------------------------------ ------------------------------
----------------------
sysusers dbo system table

(1 row affected)
Data_located_on_segment When_created
------------------------------ --------------------------
system Jan 1 1900 12:00:00:000AM

(1 row affected)
Column_name Type Length Prec Scale Nulls Default_name
Rule_name Identity
--------------- --------------- ------ ---- ----- ----- ---------------
--------------- --------
suid smallint 2 NULL NULL 0 NULL NULL
0
uid smallint 2 NULL NULL 0 NULL NULL
0
gid smallint 2 NULL NULL 0 NULL NULL
0
name sysname 30 NULL NULL 0 NULL NULL
0
environ varchar 255 NULL NULL 1 NULL NULL
0

(5 rows affected)
index_name index_description
index_keys


index_max_rows_per_page index_fillfactor index_reservepagegap
--------------------
--------------------------------------------------------
------------------------------------------------------
----------------------------------------------------------------------------
--------------------------------------------------------
---------------------------------------------------------------------
----------------------- ---------------- --------------------
sysusers clustered, unique located on system
suid

0
0 0
ncsysusers1 nonclustered, unique located on system
name

0
0 0
ncsysusers2 nonclustered, unique located on system
uid

0
0 0

(3 rows affected)

etc. etc.

looks OK to me.

BUT tsql on the other hand....

1> use master
2>
3> go
1> select * from sysusers
2> go
suid uid gid name environ
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16389 16389 16389 replication_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16388 16388 16388 navigator_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16387 16387 16387 sybase_ts_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16386 16386 16386 oper_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16385 16385 16385 sso_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16384 16384 16384 sa_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-2 0 0 public
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-1 2 0 guest
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
1 1 0 dbo
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
150 3 0 gloss_sa

is that what you mean ?
> -----Original Message-----
> From: Brian Bruns [SMTP:camber AT ais.org]
> Sent: Wednesday, September 04, 2002 4:56 PM
> To: TDS Development Group
> Subject: [freetds] RE: TODO
>
> Jim, also I think we need to pay special attention to some of the
> conversion errors, I got a bunch of spurious errors in tsql when selecting
> from sysusers (sybase 11.0.3), but haven't had time to look further.
> Definately, 0.60 fodder if it's a bug.
>
> Brian
>
> > > From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafoneomnitel.it]
> > > Sent: September 4, 2002 11:28 AM
> > >
> > > What does it mean the row in TODO:
> > > . move error message macro/prototype to tds.h.in; use in dblib.c.
> >
> > The definition of CONVERSION_ERROR and the prototype for
> > send_conversion_error_msg() are in tds/convert.c. If they were moved to
> > tds.in.h, they could be used from dblib.c.
> >
> > Currently, dblib.c::dbconvert() writes to stderr instead of calling
> > CONVERSION_ERROR. There are probably simlilar, um, oversights in ctlib
> and
> > odbc.
> >
> > See tds_convert() for example.
> >
> > Is clear?
> >
> > --jkl
>
> ---
> You are currently subscribed to freetds as: [thompbil AT exchange.uk.ml.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')




  • TODO, ZIGLIO Frediano, 09/04/2002
    • <Possible follow-up(s)>
    • RE: TODO, Lowden, James K, 09/04/2002
    • Re: TODO, Brian Bruns, 09/04/2002
    • RE: TODO, Brian Bruns, 09/04/2002
    • RE: TODO, Thompson, Bill D (London), 09/04/2002
    • RE: TODO, Brian Bruns, 09/04/2002
    • RE: TODO, Thompson, Bill D (London), 09/04/2002
    • RE: TODO, Eric Deutsch, 09/04/2002
    • RE: TODO, Brian Bruns, 09/04/2002
    • RE: TODO, Thompson, Bill D (London), 09/04/2002
    • RE: TODO, Frediano Ziglio, 09/04/2002
    • RE: TODO, Lowden, James K, 09/04/2002
    • RE: TODO, Frediano Ziglio, 09/04/2002

Archive powered by MHonArc 2.6.24.

Top of Page