FreeTDS Development Group

[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

sp_addalias

sp_helpindex

sp_addauditrecord

sp_helpjoins

sp_addlanguage

sp_helpkey

sp_addremotelogin

sp_helplanguage

sp_addsegment

sp_helplog

sp_addserver

sp_helpremotelogin

sp_addthreshold

sp_helpprotect

sp_adddumpdevice

sp_helpsegment

sp_auditdatabase

sp_helpserver

sp_auditlogin

sp_helpsort

sp_auditobject

sp_helpthreshold

sp_auditoption

sp_helpuser

sp_auditsproc

sp_indsuspect

sp_bindefault

sp_lock

sp_bindmsg

sp_locklogin

sp_bindrule

sp_logdevice

sp_changedbowner

sp_modifylogin

sp_checknames

sp_modifythreshold

sp_checkreswords

sp_monitor

sp_clearstats

sp_placeobject

sp_commonkey

sp_primarykey

sp_configure

sp_procxmode

sp_cursorinfo

sp_recompile

sp_dboption

sp_remap

sp_dbremap

sp_remoteoption

sp_depends

sp_rename

sp_diskdefault

sp_renamedb

sp_displaylogin

sp_reportstats

sp_dropalias

sp_role

sp_dropdevice

sp_serveroption

sp_dropkey

sp_setlangalias

sp_droplanguage

sp_spaceused

sp_dropremotelogin

sp_syntax

sp_dropsegment

sp_unbindefault

sp_dropserver

sp_unbindmsg

sp_dropthreshold

sp_unbindrule

sp_estspace

sp_volchanged

sp_extendsegment

sp_who

sp_foreignkey

sp_column_privileges

sp_help

sp_databases

sp_helpconstraint

sp_datatype_info

sp_helpdb

sp_server_info

sp_helpdevice

sp_table_privileges

sp_helpgroup


Tony Esposito
ETL Developer
Information Services Programming
Region 10 Education Service Center
400 E Spring Valley Rd
Richardson, TX  75081
(Ph)  972-348-1284
(Fax) 972-348-1285
Reveal Data Analytics