How to solve TIBCO ActiveMatrix Adapter for Database6.3 instance start failure with the error, "Error in AlternateServers near".

book

Article ID: KB0093022

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Description:
TIBCO ActiveMatrix Adapter for Database 6.3 instance start failure with the error, "Unable to create a connection with the target database using the dsn XXXX". It then terminates. When using the dbtest tool to test the DB connection, the following error may be seen:

DBError: 5
ErrorCode: HY000
ServerCode: 6099
Message: [TIBCO][ODBC Oracle Wire Protocol driver]Error in AlternateServers near .

Environment

Product: TIBCO Adapter for ActiveDatabase Version: 6.3.0 OS: UNIX --------------------

Resolution

If modifying the odbc.ini file in a Windows environment, it will be shown in a Windows DOS format instead of a Unix format. There will be special characters appended to every line. We cannot see these special characters in the Windows environment. Since AlternateServers= is the first line, it will treat the special character as the value of AlternateServers. To resolve, use the dos2unix command to convert the odbc.ini from DOS to Unix format.

Issue/Introduction

How to solve TIBCO ActiveMatrix Adapter for Database6.3 instance start failure with the error, "Error in AlternateServers near".