Using ADODB with SQL Server

[mikebol]

Hello gang!

I'm wanting to install and run the CMSMS 1.2.5 on my Windows Server with the backend DB being SQL Server. I currently have SugarCRM, phpBB3 and a few other PHP sites running on this server all using SQL as the backend DB.  So far so good.

I've installed CMSMS on the server, the first step of the install shows all green checkboxes.  I complete step 2 fine, but step 3 shows:

No valid database drivers appear to be compiled into your PHP install. Please confirm that you have mysql, mysqli, and/or postgres7 support installed, and try again.

What am I missing? I'm updated the ADODB_Lite with the latest.
Why wouldn't I at least get an ADO option to connect to my DB?

I'm clearly missing something. Thanks for any guidance.

Mike

[calguy1000]

CMS Made Simple Doesn't support SQL server.

[mikebol]

Doesn't it support ADO or ADODB Lite?

Mike

[calguy1000]

Yes, we use adodb and adodb_lite, but we don't support SQL server.

[Nullig]

You should check out php.net to see how to include the mssql drivers in your PHP version.

Nullig

[mikebol]

How would I make the intstall use ADODB or ADODB lite to allow a SQL Server connection? I'm Ok going throught the SQL code and fixing any SQL specific syntax changes. I'm just trying to get the connectivity part working. Could you help me at least get to that point?

Mike

[mikebol]

You should check out php.net to see how to include the mssql drivers in your PHP version.

Nullig, I have the mssql drivers working with phpBB and SugarCRM, I'm just not familiar with the configuration on ADODB\ADODB_lite. Any pointers there are greatly appriciated.

Mike

[Wiedmann]

You can add mssql to the list in "install/lib/classes/CMSInstallerPage3.class.php".

But there is no guarantee for a correct function (cause some query in CMSMS / modules are still MySQL style, even they use an abstraction layer).