Jump to content

Topic on Extension talk:OdbcDatabase/Flow

Cannot access mssql database

1
Jbellizzi (talkcontribs)

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!

Reply to "Cannot access mssql database"