I'm working off of a local Acquia Dev Desktop installation where I've installed the Data and Schema modules.
I want to connect to a cloud based SQL Server database and I've tried adding connection information to sites/default/settings.php.
$databases = array (
'database' => ‘MYSQLSERVERDATABASE’,
'username' => 'DrupalUser',
'password' => ‘xxxxxxx’,
'host' => ’18.104.22.168’,
'port' => '6433',
'driver' => 'sqlsrv',
'prefix' => '',
Regardless of whether I comment out the above, when I try to go to admin/config, I get the following error:
Fatal error: Call to undefined method DatabaseSchema_mysql::EngineVersion() in /Users/Henry/Sites/devdesktop/superior1-dev/docroot/profiles/acquia/modules/sqlsrv/sqlsrv.install on line 37
How can I resolve this error as well as connect to an external SQL Server database in a way where I can leverage the Data module to adopt tables and use views to present the data?