Hi Experts, for configuring Data Provisioning data I'm trying to create DB connection between HANA DB and SLT server, I'm getting error as shown below

[Former Member]

Hi Experts,

             for configuring Data Provisioning data in HANA Studio, I'm trying to create DB connection between HANA DB and SLT server, I'm getting error as shown below.

"

SYSTEM: HAN ERROR: SQL not possible for this connection

SYSTEM: HAN ERROR: Cannot create SQL connection

SYSTEM: HAN ERROR: sql code:

SYSTEM: HAN ERROR: Error creating a secondary database connection

SYSTEM: HAN ERROR: Set up of a secondary connection to the database system failed. It is possible that the data required for setting up the connection via EXEC SQL                    (Native SQL) is faulty.

"

[Former Member · Accepted solution]

Hi,

    Problem is solved by installing 32 bit hdbclient tool.

Thanks,

Visali Raghava Raju

[rama_shankar3]

Please follow instructions from the SLT configuration guide (SAP HANA Installation Guide – Trigger-Based Data Replication). Please make sure that your environment is meeting the pre-reqs (support pack and revision levels).

Regards,

Rama

[Former Member]

Hi Vishali,

Where do you get this error ? Did you set up the web service on the SLT system using transaction LTR ?

Regards,

khadar