ODBC call <SQLConnect> for data source <X> failed: <[>. Notify your customer.

[Former Member]

Hi all,

We have been traying to connect Microsoft SQL Server from linux server throught odbc connection but when we trigger a job from designer tool we are  getting this issue. ODBC call <SQLConnect> for data source <X> failed:<[>. Notify your customer. We have SAP BODS 4.2 SP05 on Linux machine with DataDirect versión 7.1. I really appreciate any help you have to resolve this issue.

[Former Member · Accepted solution]

Hi all,

I've gotten the solution for my connection. I've added the following parameter in the ODBC configuration entry:

RebrandedLib=YES

Please check the below link for more informatión.

To configure DataDirect ODBC on Linux and Unix - Enterprise Information Management - SCN Wiki

Thank you all.

[former_member198401]

Excellent!!

Can you please use this option in the ds_odbc.ini and try connecting to Postgre SQL

RebrandedLib = TRUE is required when using the SAP BusinessObjects Rebranded Data Direct driver.

Regards

Arun Sasi

[Former Member]

Hello, Sagar, Raymundo.

I have the same problem in SAP Data Services 4.2 SP06, trying to connect PostgreSQL database. This is my configuration in ds_odbc.ini:

[PostgreSQL2]

Driver=$LINK_DIR/DataDirect/odbc/lib/DApsql27.so

Description=DataDirect 7.1 PostgreSQL Wire Protocol

AlternateServers=

ApplicationUsingThreads=1

ConnectionReset=0

ConnectionRetryCount=0

ConnectionRetryDelay=3

Database=XXXXXXXXXXX

DefaultLongDataBuffLen=2048

EnableDescribeParam=1

EncryptionMethod=1

ExtendedColumnMetadata=0

FailoverGranularity=0

FailoverMode=0

FailoverPreconnect=0

FetchTSWTZasTimestamp=0

FetchTWFSasTime=0

HostName=XXX.XXX.XXX.XXX

HostNameInCertificate=

InitializationString=

KeyPassword=XXXXXXXXXXX

KeyStore=$LINK_DIR/workspace/Certificados/mdesapbdsd01.p12

KeyStorePassword=XXXXXXXXXXX

LoadBalanceTimeout=0

LoadBalancing=0

LoginTimeout=15

LogonID=XXXXXXXXXXX

MaxPoolSize=100

MinPoolSize=0

Password=XXXXXXXXXXX

Pooling=0

PortNumber=5712

QueryTimeout=0

ReportCodepageConversionErrors=0

TransactionErrorBehavior=1

TrustStore=

TrustStorePassword=

You found any solution to this error?

ODBC call <SQLConnect> for data source <PostgreSQL2> failed: <[>. Notify Customer Support.

Thank you!!

[former_member224495]

Hi Raymundo,

Have you created ODBC connection on BODS Server(Where BODS is installed) or else some other server?

And from where you are trying to execute this job(Citrix(Client Application)?? or Same server??)

If its from citrix please ask citrix team to configure same ODBC at BODS Application level.

Thanks,

Sagar T

[Former Member]

Hi Sagar,

We have created odbc connection on BODS Server  under $LINK_DIR/bin/ds_odbc.ini as you can see below.

[Connection]

Driver=/usr/sap/SID/dataservices/DataDirect/odbc/lib/DAsqls27.so

Description=DataDirect 7.1 SQL Server Wire Protocol

AlternateServers=

AlwaysReportTriggerResults=0

AnsiNPW=1

ApplicationName=

ApplicationUsingThreads=1

AuthenticationMethod=1

BulkBinaryThreshold=32

BulkCharacterThreshold=-1

BulkLoadBatchSize=1024

BulkLoadFieldDelimiter=

BulkLoadOptions=2

BulkLoadRecordDelimiter=

ConnectionReset=0

ConnectionRetryCount=0

ConnectionRetryDelay=3

Database=<Database Name>

EnableBulkLoad=0

EnableQuotedIdentifiers=0

EncryptionMethod=0

FailoverGranularity=0

FailoverMode=0

FailoverPreconnect=0

FetchTSWTZasTimestamp=0

FetchTWFSasTime=1

GSSClient=native

HostName=<Hostname>

HostNameInCertificate=

InitializationString=

Language=

LoadBalanceTimeout=0

LoadBalancing=0

LoginTimeout=15

LogonID=

MaxPoolSize=100

MinPoolSize=0

PacketSize=-1

Password=

Pooling=0

PortNumber=<Port>

QueryTimeout=0

ReportCodePageConversionErrors=0

SnapshotSerializable=0

TrustStore=

TrustStorePassword=

ValidateServerCertificate=1

WorkStationID=

XMLDescribeType=-10

We have modified hostname, port number and database name with the information we have.

[former_member198401]

Please refer below SAP Note

2220296 - Error: CON-120302: |Dataflow <> ODBC call <>SQLDriverConnect for data source <> failed, SAP Data Services, 14.2.x

Regards

Arun Sasi

[Former Member]

Hi Arun. Thank you for your response.

I applied SAP note 2220296 and execute Job. I found the same error: ODBC call <SQLConnect> for data source <XXXXX> failed: <[>. Notify Customer Support.

In the SAP note following I understand that connection to PostgreSQL is possible if using a vendor driver. Is true? DataDirect doesn't work with PostgreSQL?

http://service.sap.com/sap/support/notes/2050826

Regards.

[former_member198401]

Hey Zuluaga,

Whats your Data Services version

If you are below 4.2 SP1 then refer below SAP Note

2037361 - DataDirectODBC Linux SQLSever Conn Issue, SAP Data Services 4.1

Also refer SAP Note

2050826 - Using Postgresql with Data Services 4.2

Regards

Arun Sasi

[Former Member]

Hello.

In my company, Data Services version is 4.2 SP06. I reviewed the SAP note 2050826 and I understand the solution.

Thank you for your collaboration.