Issue
After correctly following the process outlined in Setup External Log Storage using MSSQL., EcoStruxure Building Operation (EBO) server fails to connect to the external database, generating the following System Alarms:
- Unable to connect to data source
- Login failed for user
The system alarm specifically details an issue with the ODBC SQL Driver as below:
- "The driver doesn't support the version of ODBC behavior that the application requested..."
- "Invalid connection string attribute"
Product Line
EcoStruxure Building Operation
Environment
- Building Operation Enterprise Server
- Building Operation Enterprise Central
- Building Operation Automation Server Premium (AS-P)
- External Log Storage [MSSQL]
Cause
The system alarm details indicate an issue with the ODBC SQL Driver, specifically:
- "The driver doesn't support the version of ODBC behavior that the application requested..."
- "Invalid connection string attribute"
This suggests a compatibility or configuration issue with the ODBC driver or connection string.
Resolution
The following has been seen to correct the issue:
- Verify User Credentials
Ensure that the username and password used for the ODBC connection are correct.
Note: SQL Server credentials are case-sensitive, so double-check for any discrepancies in letter casing. - Remove any uppercase for the username.
In some cases, using only lowercase letters for the username in the ODBC connection string has resolved the issue, e.g,. Instead of "My_User" use "myuser"
