Posted by Phoenix on 06/18/07 04:08

Hi 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=master/
user=sa/password=<Password>


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 “ No certification
authority found”
We don’t 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 

Thanks & Regards,

Sudhansu Tiwari

• Next in forum: mdac 2.8 and sql 2005 cursor performace issue
• Prev in forum: Re: Multi access in SQL Server
• Thread view: JSQLConnect MS SQL SERVER CONNECTION ISSUE

[Reply to this message]