Re: FreeTDS does not work with Sybase SQL Anywhere 10, 11 or 12 -- sp_datatype_info()

Thanks Frediano!  This would be a great help as we are trying to connect to Sybase SQL Anywhere...we use to connect to Sybase ASE and it worked.

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio
Sent: Wednesday, February 06, 2013 12:59 PM
To: FreeTDS Development Group
Subject: Re: [freetds] FreeTDS does not work with Sybase SQL Anywhere 10, 11 or 12 -- sp_datatype_info()

I hope somebody use with Microsoft SQL Server too !!

I'll see if this call lead to some traffic on network.

Frediano

2013/2/6 Tony Esposito <[email protected]>:
> Last time I looked this was the only sp that was being used that did not exist in SQL Anywhere 10-12.  That's the issue -- the sp for SQLGetTypeInfo does not exist in SQL Anywhere so it needs to be replaced in FreeTDS -- i.e. FreeTDS needs to not be dependent on that sp in order for it to be used with SQL Anywhere.  Just need to find out what it does.
>
> Otherwise, FreeTDS only works with Sybase ASE.  I would see this as a limitation to the product.
>
> HTH and thanks for your efforts...
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio
> Sent: Wednesday, February 06, 2013 10:16 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] FreeTDS does not work with Sybase SQL Anywhere 10, 11 or 12 -- sp_datatype_info()
>
> 2013/2/4 Tony Esposito <[email protected]>:
>> All,
>>         Has anyone had a chance to look into this issue (referred to in the link below)?
>>
>>         http://permalink.gmane.org/gmane.comp.db.tds.freetds/14717
>>
>>         It appears to be the only issue stopping FreeTDS from working with Sybase SQL Anywhere 10, 11 and 12.
>>
>>         Thanks.
>>
>> 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
>>
>
> Hi,
>   yesterday I tried to install a SQL Anywhere and see what's' the calls but it seems that ODBC version they use do not use TDS protocol but CMDSEQ (and also encrypted!).
>
> So I where no able to understand where SQL Anywhere ODBC driver get the data for SQLGetTypeInfo.
>
> 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: 2013.0.2897 / Virus Database: 2639/6081 - Release Date: 02/04/13
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
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: 2013.0.2897 / Virus Database: 2639/6081 - Release Date: 02/04/13