Re: Stored Procedures and Excel

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Jose,

Are you on the latest ADO? I've had problems with it that were solved by
installing Internet Explorer 5.5, which installs the latest ADO .dll's if
you select the Dynamic HTML Data Binding option.  Actually, that was an
accidental solution.  I believe you can download the latest ADO .dll's
directly from MS without having to mess with IE.

hth,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: "Rodriguez, Jose Amable" <jarodriguez@grupom.com.do>
To: <MIDRANGE-L@midrange.com>
Sent: Saturday, June 23, 2001 11:24 AM
Subject: Stored Procedures and Excel


> I am wondering if anyone has ever had success in retrieving a resultset
when
> running a stored procedure from within Excel (I am using Microsoft DAO).
I
> can run the stored procedure, but I get no result set.
>
> The stored procedure works fine via Crystal Reports.  I am using the same
> ODBC DSN to call the stored procedure.
>
> I have also tried ADO, but I haven't gotten ADO to work correctly yet
(with
> ODBC).
>
> Any help will be greatly apprciated.
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---