Hi,

Can anyone tell me what would be involved (code and sql change wise) in getting DNN to work with these 2 databases.

I know that the Firebird project was abandoned. Why was this?

I have just started with a new company who only use Firebird and Advantage Database Server therefore I cannot use MS-SQL at all, not even the express version.

I am willing to take on this project but I need more information as to what is involved.

It would be a shame if I have to abandon using DNN. I have used it for over 3 years now and it would be perfect for my companies web projects.

Regards

Mie

Sorry for the delay Sebastian.

I see what you mean. Even if I did get the core working, I would not be able to use any 3rd party modules without having the source code and updating them.

Looks like I am going to have to abandon DNN, at least until there is a possibility of using other databases e.g. if the core team decide to use Entity frameworks or at least an ORM.

I have invested a lot of time into it.

I think that any support of multiple databases must come from the core team as a means to drive 3rd party developers.

I was going to say some of what Sebastian said, properly designed modules shouldn't need any conversion.  Unfortunately, there might be 10% of the modules out there that are designed properly (mine sure aren't...).  I have seen one organization write their own provider several years ago, for DB2, but in the process they ended up rewriting most of DNN anyway.  There's probably no DNN left in their current app.

Future use of LINQ might provide an answer, but by now the DNN core is pretty strongly married to a MSSQL environment.  I converted two older Oracle databases to SQL and one of the reasons was to use DNN (the other was the Oracle guy left...), but that's not an easy solution for many people either.

Jeff