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]
