Hi
Please can someone give us a hand with setting up an external DBASE to moodle We are having a problem when authenticating users from an external sql 2008r2 server.
In Moodle in the config page we have entered the following:
|
Host |
XXXX-SERVER |
|
ODBC_mssql |
|
|
Use sybase quotes |
Yes |
|
DB name |
|
|
DB user |
dbase username |
|
Password |
dbase password |
|
Table |
xxx.xxxx.M32$_WEBUSERS |
|
Username field |
USERNAME |
|
Password field |
PASSWORDSTR |
|
Password format |
MD5 |
|
External db encoding |
|
|
SQL setup command |
|
|
Debug ADOdb |
Yes |
|
Password-change URL |
|
|
Cron synchronization script |
|
|
Removed ext user |
Keep internal |
when a user logs in we get the following error message on the dbug screen.
(odbc_mssql): SET CONCAT_NULL_YIELDS_NULL OFF
IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified xxxx-server: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
(odbc_mssql): SELECT * FROM dbasename.DBO.table WHERE USERNAME = 'xxxxx' AND PASSWORDSTR = 'xxxxxxxx'
IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Many thanks
Andy
