Hi Howard,
I've tested it here against MSSQL 2005 and seems to be working ok. Which exact errors are you getting? (with DEBUG_DEVELOPER and ADO debug enabled?).
Note that, in order to use MSSQL properly from Moodle as auth plugin, you should have everything installed like if you were going to use MSSQL as Moodle database, i.e Installing MSSQL for PHP and then select the mssql_n driver (db auth plugin) in order to get proper UTF-8 chars from the DB.
I haven't tried other mssql alternatives, so I cannot say how they are behaving...
Ciao
I've tested it here against MSSQL 2005 and seems to be working ok. Which exact errors are you getting? (with DEBUG_DEVELOPER and ADO debug enabled?).
Note that, in order to use MSSQL properly from Moodle as auth plugin, you should have everything installed like if you were going to use MSSQL as Moodle database, i.e Installing MSSQL for PHP and then select the mssql_n driver (db auth plugin) in order to get proper UTF-8 chars from the DB.
I haven't tried other mssql alternatives, so I cannot say how they are behaving...
Ciao
Hi Eloy,
Well it sort of works. I'm about twice removed from the customer so I only have limited information. Authentication definitely works so I am confident that the mssql connection is fine. However, the profile fields fail to get copied over and the logs show an sql syntax error from mssql_query().
I'm trying the get the actual sql that caused the problem, but I thought the version might be an issue. I'll press on
Well it sort of works. I'm about twice removed from the customer so I only have limited information. Authentication definitely works so I am confident that the mssql connection is fine. However, the profile fields fail to get copied over and the logs show an sql syntax error from mssql_query().
I'm trying the get the actual sql that caused the problem, but I thought the version might be an issue. I'll press on