JSQLConnect MS SQL SERVER CONNECTION ISSUE
am 18.06.2007 06:08:25 von phoenixHi Masters ,
Please have a look on the following issue :
We have a MS - SQL Server 2005 Server which is accessed through
many client machines . We use JSQLConnect to communicate with
the server from client machine. Problem is when we enable SECURITY
on the server machine , the communication fails with the following
error :
Log:Cannot connect to database,
reason:com.jnetdirect.jsql.JSQLException:
Failed Logon:com.jnetdirect.jsql.JSQLException: DBComms.error reading
input. Context:Read packet header, Unexpected end of stream,
readBytes:-1, negative read result, PktNumber:0, ReadThisPacket:0,
PktDataSize:4096 url:jdbc:JSQLConnect://localhost/database=3Dmaster/
user=3Dsa/password=3D
Any Idea why it is failing ? Do I need to install a certificate on my
SQL Server , if
Yes KINDLY LET ME KNOW THE PROCEDURE. I tried installing certificate
Through MMC but an erro message appears saying â=9C No certification
authority foundâ=9D
We donâ=99t have a certification authority , so please let me know an
alternate solution for
This.
My Environment is as follows :
JDK 1.5
Platform : HP-UX & Windows 2000
JSQLConnect 5.5
Thanks to you all in advance , Any response is most welcome ï=8A
Thanks & Regards,
Sudhansu Tiwari