Editor component and Sybase ASA support
Editor component and Sybase ASA support
Link to test case: NA
Debugger code (debug.datatables.net): NA
Error messages shown: NA
Description of problem:
Hello,
I asked a question a long time ago (see below) about Sybase ASA database support with the Editor component.
At the time, it didn't exist, and I had started working in PHP to ensure Sybase compatibility (in PHP).
Today, eight years later, I wanted to know if Sybase could be supported with version 2.4.x of Editor, and especially since the C# version of the component.
If not, what modifications would need to be made to hopefully have support for this DBMS?
Thank you in advance for your response, and I wish you a pleasant day.
See my very old post here: https://datatables.net/forums/discussion/40098/editor-sybase-database-support
Answers
Hi,
Your own post and this one I think are the only two requests I've had to support Sybase, so I'm afraid it isn't something I have prioritised.
The way the Editor libraries for .NET work are very similar to the PHP ones, in that I have "drivers" for each supported database (you can see them here).
This requires a database adapter for .NET which works with
DbProviderFactory. It looks like that is possible through their SQL Anywhere provider.So in theory, yes it would be possible to create a "driver" and thus add support for Sybase in the .NET libraries for Editor. I'd suggest having a look at the other drivers and seeing what you think.
Allan