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

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".