I am trying to access a mssql database. I have followed the steps for setting up the OdbcDatabase, and i can successfully connect to the database with isql
isql -v mysqlserverdb username password
However, I cannot get it to work with the ExternalData extension settings
in LocalSettings.php:
require_once "$IP/extensions/OdbcDatabase/OdbcDatabase.php";
$edgDBServerType['mydb'] = "odbc";
$edgDBServer['mydb'] = "mysqlserverdb";
$edgDBName['mydb'] = "Database";
$edgDBUser['mydb'] = "username";
$edgDBPass['mydb'] = "password";
$edgDBTablePrefix['mydb'] = "dbo";
in Wiki Page:
{{#get_db_data:
db=mydb
|from=Client
|data=Name=Name }}
When I navigate to the page, I get an error: Cannot access the database
Seems like I am missing something here, but not sure if the error is on the OdbcDatabase setup side, or the ExternalData setup
Thanks!