MonitorWare Knowledge Base

I am unable to use the SQL Server. According to the log, the DSN opens, it sends the username correctly, then sends the password incorrectly with "Create new DBConn!" attached to the password. How can I correct this?

CActionConfigODBC::openDBConn()
DSN=SysLog;UID=Username;PWD=PasswordCreate new DBConn!
Waking up worker thread.
Waking up worker thread.
Waking up worker thread.
ODBC Error: SQLDriverConnect failed
ODBC ERR MSG: 'ODBC Error Code: '08001'
ODBC Error Description: '[Microsoft][ODBC SQL Server Driver]Client unable to establish connection'.'
Error Message set: 'ODBC Error Code: '08001'
ODBC Error Description: '[Microsoft][ODBC SQL Server Driver]Client unable to establish connection'.'
Error while applying an action - skipping this action. Error is 'ODBC Error Code: '08001'
ODBC Error Description: '[Microsoft][ODBC SQL Server Driver]Client unable to establish connection'.'.
matching.

Actually, this is just a glitch in the debug log. The "Create new DBCon!" should be on a line by its own. So the password is set correctly.

As such, the error is most probably not password related. The 08001 ODBC error says "Error connecting to data source", which most probably means there is a typo in the database server name or a network connection problem.

You may also want to have a look at the Windows Application Event Log. Some additional descriptions may be logged there.

I hope this helps,
Rainer Gerhards
Adiscon