MySQL StoredProcedure from ADO, DAO, RDO error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henning - 24 Nov 2006 01:36 GMT

Hi,

This is annoying. I'm trying to call a SP in a MySQL database that has one
INOUT parameter. Whatever I use to call it I get error: "OUT or INOUT
argument 1 is not a variable". I am calling with ODBC User DNS.

I've tried ADO, DAO and RDO, same thing in all.

Anyone got an idea, or a codesnippet from a working app. to call a SP?

/Henning

Signature

Time is present only to prevent everything from happening at once.
Still it seems that everything happens at once.
Then there must be a bug in time.
To find the bug in time, isn't that what we all hope for.

Reply to this Message

Paul Clement - 28 Nov 2006 15:50 GMT

¤ Hi,
¤
¤ This is annoying. I'm trying to call a SP in a MySQL database that has one
¤ INOUT parameter. Whatever I use to call it I get error: "OUT or INOUT
¤ argument 1 is not a variable". I am calling with ODBC User DNS.
¤
¤ I've tried ADO, DAO and RDO, same thing in all.
¤
¤ Anyone got an idea, or a codesnippet from a working app. to call a SP?

You may want to check and see if the following applies. It looks like there is a fix.

http://bugs.mysql.com/bug.php?id=15635

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

Henning - 28 Nov 2006 18:33 GMT

> ¤ Hi,
> ¤
[quoted text clipped - 13 lines]
> ~~~~
> Microsoft MVP (Visual Basic)

Hi,

I have tried it with
mysql-connector-odbc-3.51.14-win32
mysql-5.0.27-win32
It still doesn't work as expected :(

I've done a workaround with an extra table, used as an sort of index-table.

The reason for SP's was to reduce network traffic. I need to findout if a
value exits in any of, at the moment, 10 columns In production that will be
80 columns. My workaround 'only' adds 4 extra calls to the server, so till
it's fixed I can continue the project. Since I havn't been able to test
responce-times of an SP, it might in the end turn in favor of the extra
table.

Thanx for your time, and the link!

/Henning

Reply to this Message

VB Forum / Database Access / November 2006

MySQL StoredProcedure from ADO, DAO, RDO error