CMS Made Simple Forums

For political reasons, I need to get CMSMS to talk to MS SQL databases, of which we have reather a lot on our site. Looking at lib.adodb_lite, I see there's no provision for MS SQL, despite the fact that the comments suggest it's supported.

I've looked on sourceforge and downloaded the current stable version 1.4.2. Looking at the two directories, there quite a lot more there than in lib/adodb_lite.

Is this just because vanilla CMSMS just comes with an older version? Or have some CMSMS-specific patches been applied?

Basically, if I just parachute adodb_lite v 1.4.2 over cmsmadesimple/lib/adodb_lite, am I going to trash the entire system? Or should it basically work?

Thanx in adv.

It should work fine, current versions of CMSMS (1.0.x) use an unmodified version of ADOdb Lite.
When you use Full ADOdb (instead of Lite) some modules could start giving issues because of differences in the way the Data Dictionary handles DATETIME values.

Regards,
D



Changing to a newer version of ADOdb shouldn't bring up any issues, but CMSMS won't install on MS SQL "out of the box":
http://forum.cmsmadesimple.org/index.ph ... 0.html#new

You can either modify the install script to be able to select mssql during install, or do something like described here:
http://forum.cmsmadesimple.org/index.ph ... l#msg47777

Create a CMSms installation normally with mysql.
2. Export CMSms database
3. Import database into MSSQL (is it possible?)
5. change $config['dbms']

Hello:

Dee wrote: Create a CMSms installation normally with mysql.
2. Export CMSms database
3. Import database into MSSQL (is it possible?)
5. change $config['dbms']

I made the suggested process.  All fine with any issues.

Thanks a lot

Madelyn