Re: [PATCH] Support for MS-SQL and Sybase via FreeTDS

Sybase and MS-SQL engines use the same data format to communicate  
(TDS, Tabular Data System). This is probably because MS-SQL is in fact  
(almost) a re-branded Sybase engine.

FreeTDS does support both, so (theoretically, I didn't tried it) this  
code should work on a Sybase DB as well.

Please note the "should" part, I don't currently have a Sybase engine  
to try it (I'll try to get some demo version or something when I have  
a minute).

Adding Sybase's ct-lib support instead of FreeTDS should be fairly  
easy as well: FreeTDS implements the same interfaces and structures as  
ct-lib does, so the code (again, "should") work with little or no  
modifications at all with ct-lib (a couple of ifdefs here and there  
should be enough).

Regards,
--
Alejandro Guerrieri
[email protected]



On 30/04/2009, at 15:36, Alexander Malysh wrote:

>
> Am 30.04.2009 um 15:06 schrieb Alejandro Guerrieri:
>
>> Of course the freetds dependency only applies if you use the --with- 
>> mssql switch (I know you know ;) ).
>
> yep, I know ;)
> Ok, seems MS-SQL support is possible only with FreeTDS... But you  
> wrote about Sybase support as well. Does this patch also adds Sybase
> support? I just don't see any config switch for sybase or I'm  
> missing something?
>
>> Speaking of dependencies, just a note: when running the ./ 
>> bootstrap.sh (to rebuild the configure script and other stuff) I've  
>> noticed the gettext development packages are needed. Maybe we  
>> should put a note somewhere about it? (Or maybe it is and I've  
>> missed it)
>
> maybe in README ;)
>
>>
>> Regards,
>> --
>> Alejandro Guerrieri
>> [email protected]
>>
>>>>
>>>> P.S. I'm not against FreeTDS but try to avoid avoidable  
>>>> dependencies ;)
>>>>
>>>> Am 28.04.2009 um 22:08 schrieb Alejandro Guerrieri:
>>>>
>>>>> Hi,
>>>>>
>>>>> I've createad a patch that implements dbpool support for MS-SQL  
>>>>> and Sybase DB's by using the ct-lib layer on FreeTDS libraries.  
>>>>> I've also implemented it on Sqlbox and works like a charm (I've  
>>>>> tried on OS X 10.5 and Linux Fedora Core 10 32-bit). I've only  
>>>>> tested it with MS-SQL Express on Windows XP, but it should  
>>>>> theoretically work with any ct-lib compatible DB Engine.
>>>>>
>>>>> Here's the patch with full description, installation  
>>>>> instructions and sample configuration.
>>>>>
>>>>> http://www.blogalex.com/archives/99
>>>>>
>>>>> Yes, I'll write the userguide patch if this has any chances of  
>>>>> getting into the main tree ;)
>>>>>
>>>>> Regards,
>>>>> --
>>>>> Alejandro Guerrieri
>>>>> [email protected]
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>