Re: FreeTDS does not work with Sybase SQL Anywhere 10, 11 or 12
Tony Esposito <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <197C3C50EA91BF4DBE52558A4007816B43511D0A@SN2PRD0202MB131.namprd02.prod.outlook.com> |
I have queried Sybase about your request (What replaces sp_datatype_info?). No word yet ... -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio Sent: Monday, October 08, 2012 3:17 PM To: FreeTDS Development Group Subject: Re: [freetds] FreeTDS does not work with Sybase SQL Anywhere 10, 11 or 12 2012/10/8 Tony Esposito <[email protected]>: > 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 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2441/5317 - Release Date: 10/08/12