OBIA: ODBC error Connecting With SQL Server In Informatica 9.1 (Doc ID 1582178.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 10.1.3.4.1 [1900] and later
Information in this document applies to any platform.

Symptoms

Getting following error when connecting to SQL server from Informatica:

Severity: ERROR
Timestamp: 9/2/2013 5:01:05 PM
Node: node01_HQSTERIABIDEV2APP
Thread: READER_1_1_1
Process ID: 20840650
Message Code: RR_4036
Message: Error connecting to database [
[Informatica][ODBC 20101 driver]7503
Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [xxxxxx] and connection string [yyyyy].].

Connection is configured using ODBC6 in the odbc.ini as:

[XXXX]
Driver=/biapps/ref2/Informatica/9.0.1/ODBC6.0/lib/DWpsql24.so
Description=DataDirect 6.0 SQL Server Native Wire Protocol
AlternateServers=
AlwaysReportTriggerResults=0
AnsiNPW=1
ApplicationName=
ApplicationUsingThreads=1
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadOptions=2
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=Changepoint
EnableBulkLoad=0
EnableQuotedIdentifiers=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=1
GSSClient=native
HostName=10.1.10.136
HostNameInCertificate=
InitializationString=
Language=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=100
LogonID=
MaxPoolSize=10
MinPoolSize=0
PacketSize=100
Password=
Pooling=1
PortNumber=1433
QueryTimeout=0
ReportCodePageConversionErrors=0
SnapshotSerializable=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
WorkStationID=
XML Describe Type=-10

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms