cancel
Showing results for 
Search instead for 
Did you mean: 

Data server connection issue with Sybase DB

former_member338524
Participant
945

Hi Experts,

We have installed SAP MII 15.3 with sybase DB.

We are trying to create a data server connection from SAP MII(Data Services->Data Servers) to the sybase db.

While configuring data server connection with Sybase database it's showing : Error (java.lang.Throwable: Cannot create a connection to the database)

Below are the parameter details which we have given for connection set up.

User Name: user

Password: Pwd

JDBC Driver: com.sybase.jdbc4.jdbc.SybDriver

Server URL: jdbc:sybase:Tds:<Host>:<Port>/<Database Name>

Validation Query: SELECT GETDATE()

We have successfully deployed jconn4.jar file and its showing green status.

If anyone has worked with SAP MII on sysbase database can you please share on how we can connect to sysbase database? Do we need to create any separate instance in the sysbase database for MII? If Yes how can it be done ?

Thanks and Regards

Rudrakshma Bhowmick

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member338524
Participant

Thanks a lot!!

Using jdbc:sybase:Tds:<IP>:<Port>/<Database>?ENCRYPT_PASSWORD=true as server URL

I am getting successful DB connection.

eli_dealmeida
Explorer

Hi,

For you connect sybase DB, try do this:

  • JDBC Driver: com.sybase.jdbc4.jdbc.SybDriver
  • Server URL: jdbc:sybase:Tds:<IP>:<Port>/<Database>?ENCRYPT_PASSWORD=true

The tip might be: ENCRYPT_PASSWORD=true

And you dont need deploy a jar file.

BR,

Eli Soares De Almeida

former_member338524
Participant
0 Kudos

Hi Experts,

Can we create a sybase separate custom DB instance in MII or not?

If Yes, then how can it be done?