on 07-19-2013 12:43 PM
Hi Experts,
we have installed MII 14.0 with latest version of sybase DB has backend. While Configuring data server connection with Sybase database its showing stopped status.
So please let me know where i did wrong. Below are the parameters details which i have mentioned for connection.
User name: User
Passwrd: Pass
JDBC Driver: net.sybase.jtds.jdbc.Driver
Server URL: jdbc:jtds:sybase://<IP Address>:<Port>/<Server Name>
Validation query: SELECT GETDATE()
Even i have deployed JDBC Driver(i.e.jtds-1.3.1 ) and its showing in green color.
If possible can anyone share the JDBC drive path and url for sybase connection.
Thanks & Regards,
Praveen Reddy M
Hi Praveen,
I think the problem is with the validation query.
This may not be the correct validation query for sybase data source.
Try to use this "SELECT * FROM DUAL" or "SELECT count(*) FROM dbo.sysobjects".
Regards,
Rohit Negi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
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.