"No More Data Available To Read" KILLING ME!!!

[The Net Werx]

I have a CFMX 6.1 server that is using a DSN to a SQL Server 2000 database. I have several sites that use the same DSN and we are consistently seeing the following error message:

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]No more data available to read.

I have tried updating to the latest database drivers and even using the JDBC drivers directly (by way of FusionReactor wrapper.)

I can't seem to find any useful information anywhere on what the possible causes of this might be.

Someone please help!! I know somebody must have come up against this.

[Newsgroup_User]

Found these using Google:

http://kb.adobe.com/selfservice/viewContent.do?externalId=1a3c2ad0&sliceId=1

http://www.petefreitag.com/item/194.cfm


--
Ken Ford
Adobe Community Expert - Dreamweaver
Fordwebs, LLC
http://www.fordwebs.com


"The Net Werx" <webforumsuser@macromedia.com> wrote in message
news:fm6ca2$3ue$1@forums.macromedia.com...
>I have a CFMX 6.1 server that is using a DSN to a SQL Server 2000 database.
>I
> have several sites that use the same DSN and we are consistently seeing
> the
> following error message:
>
> Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]No more
> data available to read.
>
> I have tried updating to the latest database drivers and even using the
> JDBC
> drivers directly (by way of FusionReactor wrapper.)
>
> I can't seem to find any useful information anywhere on what the possible
> causes of this might be.
>
> Someone please help!! I know somebody must have come up against this.
>

[The Net Werx · Accepted solution]

Thanks for the suggestions Ken. I found my answer elsewhere.

By installing the latest Microsoft JDBC drivers for SQL 2005 (even though I am connecting to a SQL 2000 server), I am no longer experiencing "no more data to read" errors.