Can't install 2.1.2. Get no collation option

Hi sotwell and BobRay ... thanks for your previous help; I think I'm getting somewhere...

So an update to my former issue. I've now installed ModX on our production web server instead to see whether the same issues were arising as my development server.

I created a table within my modxrevolution database and was able to connect to it and read data from the table, displaying it on screen thru a PHP page. So, success for a connection via PHP.

However, I am still only getting thru to the "Connection Information, Database connection and login information" page ... and when I click the "Test database server connection and view collations." it just sits there with "Connecting to database server:".

Any further pointers...?

Thanks for your help,
Simon

Quote from: simondarcey at Oct 01, 2013, 03:24 AM

Hi sotwell and BobRay ... thanks for your previous help; I think I'm getting somewhere...

So an update to my former issue. I've now installed ModX on our production web server instead to see whether the same issues were arising as my development server.

I created a table within my modxrevolution database and was able to connect to it and read data from the table, displaying it on screen thru a PHP page. So, success for a connection via PHP.

However, I am still only getting thru to the "Connection Information, Database connection and login information" page ... and when I click the "Test database server connection and view collations." it just sits there with "Connecting to database server:".

Any further pointers...?

Thanks for your help,
Simon

PS: this may help narrow it down; I can successfully connect using the ADO connection object:
$conn = new COM ("ADODB.Connection") or die("Cannot start ADO");

Yet can't connect using:
$dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");

How can I get around this for the MODX DB set up screen?

Quote from: simondarcey at Oct 01, 2013, 03:36 AM

Quote from: simondarcey at Oct 01, 2013, 03:24 AM

Hi sotwell and BobRay ... thanks for your previous help; I think I'm getting somewhere...

So an update to my former issue. I've now installed ModX on our production web server instead to see whether the same issues were arising as my development server.

I created a table within my modxrevolution database and was able to connect to it and read data from the table, displaying it on screen thru a PHP page. So, success for a connection via PHP.

However, I am still only getting thru to the "Connection Information, Database connection and login information" page ... and when I click the "Test database server connection and view collations." it just sits there with "Connecting to database server:".

Any further pointers...?

Thanks for your help,
Simon

PS: this may help narrow it down; I can successfully connect using the ADO connection object:
$conn = new COM ("ADODB.Connection") or die("Cannot start ADO");

Yet can't connect using:
$dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");

How can I get around this for the MODX DB set up screen?

Sorry for the multiple posts, guys ... I've been at this for 2 days now, just trying to get it going!

I have now managed to get a PHP connection using:
$dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");

So SQL server is playing ball properly. But I still can't get passed the "Connection Information" page on the MODX installation page.

Help please....
Thanks,
Simon

Are you setting the database type to mssql during Setup (I think it's under "advanced" for a new site)? It defaults to MySQL.

Hi BobRay - thanks for your reply.

I'm setting it to 'sqlsrv' from the 'Database type' drop-down list on the 'Connection Information' screen. See attached screen shot; there doesn't appear to be an 'Advanced' option for a new site. I've tested the displayed database variables in a PHP connection and they all work fine.

Other thoughts? Thanks again.

Take a look at the first line of the core/config/config.inc.php file (assuming that Setup got far enough along to write to the file).

Thanks BobRay. Nope, set up didn't get that far (ie. the file hasn't been written to). The file has write permissions.

Sorry, I'm out of ideas.

Thanks for your help, BobRay.

Anyone else able suggest anything?

I've even turned off Windows Firewall to test whether that was preventing the connection; but alas still not able to get passed the Database Information screen.