Skip to Content
1
May 13, 2020 at 02:00 PM

Data server connection issue with Sybase DB

594 Views

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

Attachments

dataconnection.png (17.5 kB)
servererror.png (15.7 kB)