I config a JDBC connnect resource to SQL server. Why do I see following error:[tibcosoftwareinc][SQLServer JDBC Driver]End of Stream detected on a read

I config a JDBC connnect resource to SQL server. Why do I see following error:[tibcosoftwareinc][SQLServer JDBC Driver]End of Stream detected on a read

book

Article ID: KB0085919

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:
Normally the error

[tibcosoftwareinc][SQLServer JDBC Driver]End of Stream detected on a read

is caused by the following :

1. the JDBC connection string is not correct - please check and make sure that the port number, machine name and databaseName are correct. Try to replace machine name with IP address to see if it works.
2. there are network connection problems from the BW machine to SQL server - make sure you are able to run query analyzer from the BW machine connecting to SQL server?
3. the version of SQL server is unsupported

Issue/Introduction

I config a JDBC connnect resource to SQL server. Why do I see following error:[tibcosoftwareinc][SQLServer JDBC Driver]End of Stream detected on a read