Re: Differentiate Sybase from SQL Server

> On Jul 28, 2018, at 11:11 PM, Igor Korot <[email protected]> wrote:
> 
> Hi,
> 
> On Sun, Jul 29, 2018 at 12:13 AM, John Kendall <[email protected]> wrote:
>> Igor,
>> Would
>> 
>>  select @@version
>> 
>> work for you?
> 
> It probably will, but I'm curious if there is something inside the tds
> structure or the statement/connection
> structure that will help.
> 
> Unless Frediano has some other idea.
> 
> Thank you.

The TDS version is reliable.  If it's 5, it's Sybase.  Otherwise it's MS.
That's used in src/apps/defncopy.c (line 231):


https://github.com/FreeTDS/freetds/blob/master/src/apps/defncopy.c#L231


> 
>> John
>> 
>> 
>> 
>> 
>> 
>>> On Jul 28, 2018, at 10:04 PM, Igor Korot <[email protected]> wrote:
>>> 
>>> Hi,
>>> Is there a way to differentiate between Sybase and SQL Server
>>> other than by the TDS protocol version?
>>> 
>>> I need an implementation of SQLDescribeCol(), but the information
>>> about column is located in a different table for those DBMSes.
>>> I can probably check what TDS version is used for a connection,
>>> but it is not very reliable way of doing things.
>>> 
>>> Thank you.
>>> _______________________________________________
>>> FreeTDS mailing list
>>> [email protected]
>>> https://url.emailprotection.link/?a95lm_Yz0z4VwVi9HMyQSLtTmToR48n_2Es8x43dIoxidNPkdt4wWeUhbwN1QnbrzawQmZ1BjbOu5bK1zLGmRSw~~
>> 
>> _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> https://url.emailprotection.link/?a95lm_Yz0z4VwVi9HMyQSLtTmToR48n_2Es8x43dIoxidNPkdt4wWeUhbwN1QnbrzawQmZ1BjbOu5bK1zLGmRSw~~
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> https://url.emailprotection.link/?a95lm_Yz0z4VwVi9HMyQSLtTmToR48n_2Es8x43dIoxidNPkdt4wWeUhbwN1QnbrzawQmZ1BjbOu5bK1zLGmRSw~~