MyODBC 3.5.12 and Stored Procedures

Hello,

I am currently feeding a Voice Response system from a MySQL database
and it would be a lot less of a hassle if I could use Stored
Procedures that return result sets. Now from a recent post by Peter I
deduced that the latest version of MyODBC (3.5.12) was changed in such
a way that an SP could return a result set.

However: when I try to do this 'at home' I get the error that the
"PROCEDURE cannot return a resultset in the given context". I wrote to
the list and to Peter about this, but either my mail got bounced, or
Peter is just too busy, or my question just too stupid. So I am trying
my luch again, but now with a new post/thread. Has anyone be succesful
in retrieving resultsets from an SP? If so: how did you succeed? Do
you have any pointers?

[My setup: Win2003 Server, MySQL 5.0.15, MyODBC 3.5.12-2 (binary package)]

Regards,

Frank

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: MyODBC 3.5.12 and Stored Procedures

Frank Maas wrote:

>Hello,
>
>I am currently feeding a Voice Response system from a MySQL database
>and it would be a lot less of a hassle if I could use Stored
>Procedures that return result sets. Now from a recent post by Peter I
>deduced that the latest version of MyODBC (3.5.12) was changed in such
>a way that an SP could return a result set.
>
>
>
You think as I do :)

>Has anyone be succesful
>in retrieving resultsets from an SP?
>
>
No. I was trying, but not getting anywhere. To make matters worse, I
Win2k installation bombed out, and when I installed everything and did a
Windows Update, it screwed with some msjet dll and now I can't even
attach tables. I'm waiting on MyODBC-5. Apparently there will be another
alpha release soon, and maybe this will fix both our problems.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC 3.5.12 and Stored Procedures

Daniel Kasak wrote:

> Frank Maas wrote:
>
>> Hello,
>>
>> I am currently feeding a Voice Response system from a MySQL database
>> and it would be a lot less of a hassle if I could use Stored
>> Procedures that return result sets. Now from a recent post by Peter I
>> deduced that the latest version of MyODBC (3.5.12) was changed in such
>> a way that an SP could return a result set.
>>
>>
>>
> You think as I do :)
>
>> Has anyone be succesful
>> in retrieving resultsets from an SP?
>>
>>
> No. I was trying, but not getting anywhere. To make matters worse, I
> Win2k installation bombed out, and when I installed everything and did
> a Windows Update, it screwed with some msjet dll and now I can't even
> attach tables. I'm waiting on MyODBC-5. Apparently there will be
> another alpha release soon, and maybe this will fix both our problems.
>
c/odbc v3.51.12 has a bug in SQLDriverConnect. A fix can be found in a
release you can download at;

ftp://ftp.mysql.com/pub/mysql/hidden/connectors/odbc/

This fix will be in c/odbc v3.51.13.


--
Peter Harvey, Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC 3.5.12 and Stored Procedures

Peter,

On 2005/11/10 you wrote:
>
> c/odbc v3.51.12 has a bug in SQLDriverConnect. A fix can be found in a
> release you can download at;
>
> ftp://ftp.mysql.com/pub/mysql/hidden/connectors/odbc/
>
> This fix will be in c/odbc v3.51.13.

Sorry, it took me a while to go and look for it, but the only version
I could find was 3.51.12-2, dated Oct 25, 2005. I installed this
version, but the problem remains. I'll wait for 3.51.13 - any ideas on
a release date?

regards,

frank

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg