Re: FreeTDS does not work with Sybase SQL Anywhere 10, 11 or 12

2012/10/9 James K. Lowden <[email protected]>:
> On Mon, 8 Oct 2012 18:49:03 +0000
> Tony Esposito <[email protected]> wrote:
>
>> It appears that the FreeTDS ODBC drivers are converting the
>> SQLGetTypeInfo ODBC call to the Sybase stored procedure
>> sp_datatype_info. That's ok when running against Sybase Adaptive
>> Server Enterprise but the drivers will fail against Sybase SQL
>> Anywhere because the stored procedure sp_datatype_info has been
>> removed/deprecated.
>
> I wonder how many customers were happy about that?
>
> Patches welcome.  The query below would be a start.
>

Tony, I think that a

select * from master.dbo.sysdomain

and a

select * from master.dbo.sysusertype

would be helpful

Frediano


> --jkl
>
> http://infocenter.sybase.com/help/topic/com.sybase.help.ase_15.0.sprocs/html/sprocs/sprocs229.htm
> http://manuals.sybase.com:80/onlinebooks/group-pbarc/conn5/sqlug/@Generic__BookTextView/71268;pt=69960#X
> http://manuals.sybase.com:80/onlinebooks/group-pbarc/conn5/sqlug/@Generic__BookTextView/69960;pt=69960#X
>
> select    domain_name   as type_name
>         , type_id       as data_type
>         , precision     as precision
>         , cast(NULL as varchar(32))   as literal_prefix
>         , cast(NULL as varchar(32))   as literal_suffix
>         , cast(NULL as varchar(32))   as create_params
>         , cast(NULL as smallint)      as nullable
>         , cast(NULL as smallint)      as case_sensitive
>         , cast(NULL as smallint)      as searchable
>         , cast(NULL as smallint)      as unsigned_attribute
>         , cast(NULL as smallint)      as money
>         , cast(NULL as smallint)      as auto_increment
>         , cast(NULL as smallint)      as local_type_name
> from    master.dbo.SYSDOMAIN
> UNION
> select    type_name     as type_name
>         , type_id       as data_type
>         , width         as precision
>         , cast(NULL as varchar(32))   as literal_prefix
>         , cast(NULL as varchar(32))   as literal_suffix
>         , cast(NULL as varchar(32))   as create_params
>         , nulls                       as nullable
>         , cast(NULL as smallint)      as case_sensitive
>         , cast(NULL as smallint)      as searchable
>         , cast(NULL as smallint)      as unsigned_attribute
>         , cast(NULL as smallint)      as money
>         , cast(NULL as smallint)      as auto_increment
>         , cast(NULL as smallint)      as local_type_name
> from    master.dbo.SYSUSERTYPE
>
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds