473,378 Members | 1,384 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

JSQLConnect MS SQL SERVER CONNECTION ISSUE

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

Jun 18 '07 #1
0 1595

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: JP SIngh | last post by:
Hi All Our server recently has started to play up and hangs every 7-10 days. Someone has suggested that the way we open database connections might be using too many server resources. Can...
1
by: David Gamble | last post by:
I am having problems with long timeouts when connecting to or executing commands in SQL Server 2000 SP3. I am writing an application that will be used on laptops within an environment that is...
3
by: ACP | last post by:
Hi all, Have a situation that my company has never run across before. Client is running NT4 for the domain server, using terminal services 2000 and running an application with a SQL Server...
4
by: Frodo | last post by:
I have a problem establishing a link between Visual Studio.NET 2003 and SQL Server 2000. Both are installed on a Windows Server 2003, standard version. Visual Studio.NET Issues...
5
by: Fred Zuckerman | last post by:
Hello All, After reading in this group about the preference for connecting to a SQL Server using a connection string instead of a DSN file, I have done just that. BUT, I cannot update my data....
3
by: Hermit Dave | last post by:
Hi, I am getting this SQLException: Sql Server does not exist or access denied Here is the situation: Build machine: VS 2003, Framework 1.1, Windows XP and SQL Server I have two sets of...
12
by: RKay | last post by:
I have a Win2k server running SQL Server 2000. On that box I built a working web service that pulls data from the database. One of the services available simply accepts an ado.net connection string...
6
by: Todd Brewer | last post by:
Windows Server 2000 ASP.NET 2.0 SQL Server 2000 (on a physically seperate server) I moved an ASP.NET 2.0 application from a development server to production, and am getting the following error:...
10
by: jimjim | last post by:
HI, We have shifted our database from sqlserver2003 to sqlserver2005. 1. connection strings stored in web.config <!-- Machine name to connection string keys --> <add key="*777*"...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.