Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2016 at 07:04 PM

    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.

    😊

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2016 at 08:42 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2016 at 08:11 PM

    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!!

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 26, 2016 at 04:43 AM

    Excellent!!

    Former Member

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.