Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

CCX 8.5 ODBC Connection PASSED but JDBC Connection keeps failing with SQL 2005

Hi All,

I have searched this partucular thread in supportforums butnot found the workaround.

In my setup, I have SQL 2005 Standard Edition (SP3), UCCX 8.5.

I have installed JDBC Driver 1.2.5 and it is successfully installed but the JDBC connection keeps on failling.

I have 2 databases and 2 users.

However I have tested the ODBC Connection/DSN connection from my PC and it is working absolutely fine.

URL :  jdbc:jtds:sqlserver://192.168.11.161:1433/demo

Please refer the enclosed screen shots for failed JDBC and passed ODBC connection.

Please advice for the workaround!

Many Thanks!

Manish

5 REPLIES
New Member

CCX 8.5 ODBC Connection PASSED but JDBC Connection keeps failing

Try adding the following to your to your JDBC URL

jdbc:jtds:sqlserver://192.168.11.161:1433/demo;domainname=

This is what I have in mine and it works

New Member

CCX 8.5 ODBC Connection PASSED but JDBC Connection keeps failing

Hi,

Thanks for your reply.

I do not have domain in my setup.

Please advice workaround, thanks!

Manish

New Member

CCX 8.5 ODBC Connection PASSED but JDBC Connection keeps failing

Try replacing the with the name of the Server.

New Member

CCX 8.5 ODBC Connection PASSED but JDBC Connection keeps failing

Hi ,

The issue resolved.

Every setps was right, but apparantly the server were connected trhough Wireless and some how there were some port blocking in that.

Tried on Switch, worked absolutely fine.

Thanks all, for the replies!

Manish Gupta

New Member

CCX 8.5 ODBC Connection PASSED but JDBC Connection keeps failing

How install JDBC software on server, where SQL located???

873
Views
0
Helpful
5
Replies
CreatePlease to create content