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: Tony Esposito <Tony.Esposito AT region10.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc: Tony Esposito <Tony.Esposito AT region10.org>
  • Subject: Re: [freetds] FreeTDS does not work with Sybase SQL Anywhere 10, 11 or 12
  • Date: Mon, 8 Oct 2012 20:29:36 +0000

I have queried Sybase about your request (What replaces sp_datatype_info?).
No word yet ...

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] 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 <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
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
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





Archive powered by MHonArc 2.6.24.

Top of Page