Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS does not work with Sybase SQL Anywhere 10, 11 or 12

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS does not work with Sybase SQL Anywhere 10, 11 or 12
  • Date: Tue, 9 Oct 2012 18:30:28 +0100

2012/10/9 James K. Lowden <jklowden AT freetds.org>:
> On Mon, 8 Oct 2012 18:49:03 +0000
> Tony Esposito <Tony.Esposito AT region10.org> 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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page