Page 1 of 1

Using ADODB with SQL Server

Posted: Thu Jun 05, 2008 3:14 pm
by 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

Re: Using ADODB with SQL Server

Posted: Thu Jun 05, 2008 3:21 pm
by calguy1000
CMS Made Simple Doesn't support SQL server.

Re: Using ADODB with SQL Server

Posted: Thu Jun 05, 2008 7:40 pm
by mikebol
Doesn't it support ADO or ADODB Lite?

Mike

Re: Using ADODB with SQL Server

Posted: Thu Jun 05, 2008 7:43 pm
by calguy1000
Yes, we use adodb and adodb_lite, but we don't support SQL server.

Re: Using ADODB with SQL Server

Posted: Thu Jun 05, 2008 7:50 pm
by Nullig
You should check out php.net to see how to include the mssql drivers in your PHP version.

Nullig

Re: Using ADODB with SQL Server

Posted: Thu Jun 05, 2008 7:52 pm
by 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

Re: Using ADODB with SQL Server

Posted: Thu Jun 05, 2008 7:54 pm
by mikebol
Nullig wrote: 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

Re: Using ADODB with SQL Server

Posted: Thu Jun 05, 2008 8:41 pm
by 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).