MODx, ADODB and MSSQL (Re-Opening Topic)

If I have data in MSSQL, ¿How can I extract it using MODx framework? MODx is compatible using any DB ORM layer, like ADODB, to extract data from another DBMS (MSSQL, Oracle, SAP, etc.)?

We’re considering use MODx to develop a mayor Intranet project, some corporate data is in MSSQL. We don’t want to duplicate data in MSSQL and MySQL.

Sorry. "My english is not very good looking..." (© Celia Cruz)

You can use PHP’s PDO configured with MSSQL drivers to access data in a MSSQL database. Or you can use ADODB if you really want to, though the overhead with something like this will be much larger. Regardless, since MODx allows PHP scripts as snippets, anything is possible. Just be aware that accessing multiple databases means more overhead (multiple connections) and less performance if that is an issue...

Quote from: OpenGeek at Sep 22, 2009, 10:36 PM

You can use PHP’s PDO configured with MSSQL drivers to access data in a MSSQL database. Or you can use ADODB if you really want to, though the overhead with something like this will be much larger. Regardless, since MODx allows PHP scripts as snippets, anything is possible. Just be aware that accessing multiple databases means more overhead (multiple connections) and less performance if that is an issue...

It’s overhead and less performance, but at least is what we can do with our client’s data. For now we will use MSSQL, we will force them to migrate to MySQL in the future.

Thank’s for your support man.

Hello,

And what about database session management offered by ADODB in MODx CMS (R)Evolution ?
Anybody has tested these integration ?

I need to handle multiple days sessions...
Storing them as file on the filesystem is not ok, so I look at database handling with managed lifetime.

Technical suggestions are welcome.
Thanks!

Revolution supports this with the out-of-the-box database session handler that is included.

Hello OpenGeek,

Yes of course, but I have started a client projet with Evolution and I don’t want to migrate until Revolution provides a stable release for production environments (GA).

So that’s why I’ve been looking for workarounds with well known libs.

Thanks.

I think you missed the release last week. Revolution 2.0.0-pl (Public Launch) is available. This is equivalent to "GA".