on 2020 May 13 3:00 PM
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
Request clarification before answering.
Thanks a lot!!
Using jdbc:sybase:Tds:<IP>:<Port>/<Database>?ENCRYPT_PASSWORD=true as server URL
I am getting successful DB connection.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Experts,
Can we create a sybase separate custom DB instance in MII or not?
If Yes, then how can it be done?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.