Error 8577: Failed getting rowset(s) from data source

Glyn Armstrong

unread,

May 15, 2002, 10:54:04 AM5/15/02

to

I have an application which contains a data report. The
datasource of this report is set to a recordset which is
returned by an ActiveX object. When the object is a DLL
the application works fine, but when I convert it to an
EXE (using the csame class module as before) then viewing
or printing the report raises an error 8577: Failed
getting rowset(s) from data source.

Has anyone seen anything similar?
Can anyone suggest a workround?

Scot Rose

unread,

May 15, 2002, 3:27:32 PM5/15/02

to

have you checked that there is in fact a recordset being returned by the
object (Bind it to a grid and make sure there is a recordset available.)

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : sc...@online.microsoft.com <Remove word online. from address>

Want to know more? Check out the MSDN at msdn.microsoft.com or the
Microsoft Knowledge Base at support.microsoft.com

This posting is provided “AS IS”, with no warranties, and confers no rights.

--------------------
>Content-Class: urn:content-classes:message
>From: "Glyn Armstrong" <glyn_ar...@keane.uk.com>
>Sender: "Glyn Armstrong" <glyn_ar...@keane.uk.com>
>Subject: Error 8577: Failed getting rowset(s) from data source
>Date: Wed, 15 May 2002 07:54:04 -0700
>Lines: 10
>Message-ID: <3db101c1fc20$5b37a150$3bef2ecf@TKMSFTNGXA10>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcH8IFs3v3mSYjbzS4miDfW04Szrew==
>Newsgroups: microsoft.public.vb.dataenvreport
>NNTP-Posting-Host: TKMSFTNGXA10 10.201.226.38
>Path: cpmsftngxa07!cpmsftngxa08
>Xref: cpmsftngxa07 microsoft.public.vb.dataenvreport:7067
>X-Tomcat-NG: microsoft.public.vb.dataenvreport

Glyn Armstrong

unread,

May 16, 2002, 4:32:11 AM5/16/02

to

Thanks for your reply Scot,
Yes, there is a recordset being returned.
I checked this by looking at the data (and navigating
through it) using the immediate window in debug mode. The
data all seems to be visible and correct.

>.
>

Scot Rose

unread,

May 20, 2002, 1:21:08 PM5/20/02

to

For your connection property are you setting the Connection.Cursorlocation
to aduseclient or using the default Server cursors?

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : sc...@online.microsoft.com <Remove word online. from address>

Want to know more? Check out the MSDN at msdn.microsoft.com or the
Microsoft Knowledge Base at support.microsoft.com

This posting is provided “AS IS”, with no warranties, and confers no rights.

--------------------
>Content-Class: urn:content-classes:message
>From: "Glyn Armstrong" <glyn_ar...@keane.uk.com>
>Sender: "Glyn Armstrong" <glyn_ar...@keane.uk.com>

>References: <3db101c1fc20$5b37a150$3bef2ecf@TKMSFTNGXA10>
<e3bsRaE$BHA.1528@cpmsftngxa08>
>Subject: RE: Error 8577: Failed getting rowset(s) from data source
>Date: Thu, 16 May 2002 01:32:11 -0700
>Lines: 62
>Message-ID: <3d7e01c1fcb4$2c79d7e0$b1e62ecf@tkmsftngxa04>

>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300

>Thread-Index: AcH8tCx3LUDofmIIRcC+mwv5sdbRVQ==
>Newsgroups: microsoft.public.vb.dataenvreport
>NNTP-Posting-Host: TKMSFTNGXA04 10.201.232.163
>Path: cpmsftngxa07!cpmsftngxa06!cpmsftngxa08
>Xref: cpmsftngxa07 microsoft.public.vb.dataenvreport:7075
>X-Tomcat-NG: microsoft.public.vb.dataenvreport

Glyn Armstrong

unread,

May 21, 2002, 5:09:08 AM5/21/02

to

Scot,

Thanks for your reply.
I was using the default cursor location.
When I set the location to aduseclient the exe works
correctly.
Is this behaviour by design or is it a bug?

Glyn.

>>>>the applicationÍ{ wÀ D Ä\ÖCtH ÌS´
> ìT works fine, but when I convert it to an

Scot Rose

unread,

May 28, 2002, 2:58:12 PM5/28/02

to

Bug or By design.... Hmmmm thats one of those questions for the ages... In
my opinion, serverside cursors are a bug waiting to happen, in this
particular case however, depending on a wide range of things. What database
are you using? If SQ Server, there are instances where Serverside is
preferable, others where Client is, and those times are not documented. If
Access? Well thats a Flat file database so there isn't a 'Server' there
anyway so ado tries to figure it out. Oracle? Doesn't have any support for
Serverside cursors and again ado attempts to figure it out...

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : sc...@online.microsoft.com <Remove word online. from address>

Want to know more? Check out the MSDN at msdn.microsoft.com or the
Microsoft Knowledge Base at support.microsoft.com

This posting is provided “AS IS”, with no warranties, and confers no rights.

--------------------
>Content-Class: urn:content-classes:message
>From: "Glyn Armstrong" <glyn_ar...@keane.uk.com>
>Sender: "Glyn Armstrong" <glyn_ar...@keane.uk.com>
>References: <3db101c1fc20$5b37a150$3bef2ecf@TKMSFTNGXA10>
<e3bsRaE$BHA.1528@cpmsftngxa08>

<3d7e01c1fcb4$2c79d7e0$b1e62ecf@tkmsftngxa04>
<w7FdCLCACHA.1528@cpmsftngxa08>

>Subject: RE: Error 8577: Failed getting rowset(s) from data source

>Date: Tue, 21 May 2002 02:09:08 -0700
>Lines: 122
>Message-ID: <56b601c200a7$29f4e950$19ef2ecf@tkmsftngxa01>

>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"

>Content-Transfer-Encoding: quoted-printable

>X-Newsreader: Microsoft CDO for Windows 2000

>Thread-Index: AcIApyn0JRIORHfuSPWizx/mP7e0lA==

>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300

>Newsgroups: microsoft.public.vb.dataenvreport
>NNTP-Posting-Host: TKMSFTNGXA01 10.201.232.160
>Path: cpmsftngxa07!tkmsftngxs02!cpmsftngxa08
>Xref: cpmsftngxa07 microsoft.public.vb.dataenvreport:7113
>X-Tomcat-NG: microsoft.public.vb.dataenvreport

>>>>>the applicationÍ{ťwŔ D Ä\ÖCtH ĚS´
>> ěT works fine, but when I convert it to an