Prev: Transaction Log Backup Failure
Next: How to setup Database Mail for SQLS 2005
From: jack.smith.sam on 1 Nov 2006 06:35
Hi,

I wrote a Java program which connects to SQL Serve 2005 and used
prepared statements. I got the following error:

com.microsoft.sqlserver.jdbc.SQLServerException: No TDS_RET_STATUS was
found for
the stored procedure output parameters.


Do you have any idea?

Thanks a lot.

From: Dan Guzman on 1 Nov 2006 07:53
Are you using the latest version of the jdbc driver? Apparently, there was
an issue with WRITETEXT that was fixed in that version
(http://blogs.msdn.com/angelsb/archive/2006/08/22/713417.aspx). Also, make
sure that you are retrieving all results returned from the proc before you
access the OUTPUT parameters.


--
Hope this helps.

Dan Guzman
SQL Server MVP

<jack.smith.sam(a)gmail.com> wrote in message
news:1162380938.897963.204830(a)e3g2000cwe.googlegroups.com...
> Hi,
>
> I wrote a Java program which connects to SQL Serve 2005 and used
> prepared statements. I got the following error:
>
> com.microsoft.sqlserver.jdbc.SQLServerException: No TDS_RET_STATUS was
> found for
> the stored procedure output parameters.
>
>
> Do you have any idea?
>
> Thanks a lot.
>

 | 
Pages: 1
Prev: Transaction Log Backup Failure
Next: How to setup Database Mail for SQLS 2005