FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2012/10/8 Tony Esposito <Tony.Esposito AT region10.org>:
> Hello all,
>                 Not sure everyone got this thread.  If you did, my 
> apologies for the duplicate email.
>
> 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.
>
> See trace file from Oracle ODBC gateway below:
>
> Entered hgopoer at 2012/10/02-12:03:44
> hgopoer, line 231: got native error 504 and sqlstate 52W09; message 
> follows...
> [FreeTDS][SQL Server]SQL Anywhere Error -265: Procedure 'sp_datatype_info' 
> not found {52W09,NativeErr = 504}
> Exiting hgopoer, rc=0 at 2012/10/02-12:03:44
> hgoulcp, line 1246: calling SQLGetTypeInfo got sqlstate 52W09
> Exiting hgoulcp, rc=28500 at 2012/10/02-12:03:44 with error ptr 
> FILE:hgoulcp.c LINE:1246 FUNCTION:hgoulcp() ID:GetTypeInfo: varchar
> hostmstr: 0: HOA After hoaulcp
>
>                 Since there seems to be an issue with FreeTDS using an 
> unsupported stored procedure (in Sybase SQL Anywhere), I thought it might 
> be helpful to list those
> stored procedures no longer available/supported in Sybase SQL Anywhere 12.
>
> Support for all the store procedures below has been removed from Sybase SQL 
> Anywhere 12:
>
> Procedure name
>
> Procedure name
>
....

Thanks for the list.

It seems that the only one we use that they removed is
sp_datatype_info. Do they say which should replace this store
procedure? Or a view or whatever ?? This would help a lot.

Regards,
  Frediano