cancel
Showing results for 
Search instead for 
Did you mean: 

MII 14.0 Data server connection with Sybase DB issue

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member211944
Active Participant
0 Kudos

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.

Former Member
0 Kudos

Hi Rohit,

Thanks for quick response. Issue was with query only. I kept it as "SELECT count(*) FROM dbo.sysobjects" and it working fine and shown status running. Thanks

Regards,

Praveen Reddy

Former Member
0 Kudos

Hi Praveen,

Can you please share the URL to download proper JAR file for jtds driver.

Actually I have downloaded one, but seems like it is not the proper jar file as the logs show driver related errors. Please see the screenshot below

Thanks & Regards,

Anuj

Answers (0)