MySQL StoredProcedure from ADO, DAO, RDO error

[Henning]

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

--
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.

[Paul Clement]

On Fri, 24 Nov 2006 02:36:09 +0100, "Henning" <comput...@coldmail.com> wrote:

¤ 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)

[Henning]

"Paul Clement" <UseAdddressA...@swspectrum.com> skrev i
meddelandet news:fgmom2dkccu51bch0...@4ax.com...

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