Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(3 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

"RR_4036 : Error connecting to database [523 92[Informatica][ODBC SQL Server Legacy Driver][libssclient25]ConnectionOpen (()).[Informatica][ODBC SQL Server Legacy Driver][libssclient25]206112061120611" while running a PowerCenter session
Problem Description

The following error occurs when running a PowerCenter session that connects to Microsoft SQL Server through an ODBC connection:

RR_4036 : Error connecting to database 

[523 92[Informatica][ODBC SQL Server Legacy Driver][libssclient25]ConnectionOpen (()).[Informatica][ODBC SQL Server Legacy Driver][libssclient25]206112061120611


Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [username] and connection string [ODBC_CON].].
ERROR : (1234 | READER_1_1_1) : (IS | IS) : node01 : BLKR_16001 : Error connecting to database...

Cause

This error will occurs when the address field in the odbc.ini file configuration is set incorrectly:

[ODBC_CON]
Driver=/opt/powercenter9/Informatica/9.1.0/ODBC6.1/lib/DWmsss25.so
Description=DataDirect 6.1 New SQL Server Wire Protocol
address=MY_HOST\INSTANCE_NAME, MY_PORT
Database=MY_DATABASE_NAME

Example

Driver=/opt/powercenter9/Informatica/9.1.0/ODBC6.1/lib/DWmsss25.so
Description=DataDirect 6.1 New SQL Server Wire Protocol
address=
ukdb9\uksql2k8
, 1433
Database=support

uksql2k8 corresponds to the instance name and should not be informed as part of the hostname.

Solution

 

To resolve this issue, update ODBC.ini to match the following: 

[ODBC_CON]
Driver=/opt/powercenter9/Informatica/9.1.0/ODBC6.1/lib/DWmsss25.so
Description=DataDirect 6.1 New SQL Server Wire Protocol
address=MY_HOST, MY_PORT
Database=MY_DATABASE_NAME_INSTANCE

Example

Driver=/opt/powercenter9/Informatica/9.1.0/ODBC6.1/lib/DWmsss25.so
Description=DataDirect 6.1 New SQL Server Wire Protocol
address=
ukdb9
, 1433
Database=support

More Information
Applies To
Product: PowerCenter
Problem Type:
User Type:
Project Phase:
Product Version: PowerCenter; PowerCenter 9.1.0
Database: Microsoft SQL Server
Operating System: UNIX; Linux; SUSE Linux ES; Redhat Linux; AIX; Solaris; HP-UX
Other Software:

Reference
Attachments
Last Modified Date:10/27/2015 10:42 PMID:136316
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)