Procs with paramters

Hi,

I am trying to run stored procedures that take parameters.
Seems that the MySQLCommand is not passing on the parameters to the MySQL
engine or the connector is not passing on the parameters --
I traced my code line by line and until the execution time, the commnd
object contained the parameters set - correctly, but at the execution time -
the parameters were not passed to the stored procedure - hence 0 arguments
exception raised.

Any body able to run SPs with parameters?

Thanks.

----- Original Message -----
From: "Daniel da Veiga"
To: "MySQL Win32 List"
Sent: Tuesday, November 15, 2005 4:05 PM
Subject: Re: Connection Mysql Administrator


In order to help you, I'll have to give more info, the simple fact
that Administrator gives you a connection error is not enough, I can't
seem to notice any problem if you are able to connect using mysql at
command line, the only problem I can think is the approuch you're
using and your server specific configs. I'm using Administrator to
deal with 5 databases in 5 different servers, some win, some lin and
never had problems.

Maybe a DNS problem?! Check your HOSTS file to see if there's an entry
there that looks like:

127.0.0.1 localhost

If not, add it and try again, if you're still unable to connect, post
your MySQL config file and your server ipconfig and route outputs.

On 11/13/05, Diego Burbano wrote:
>
>
> Hello Friends,
>
> First I was problems with this error: root@localhost
> acess denied, but I solve this with your help in this
> list.
>
> I have another problem with connection at Mysql Server
> by Mysql Administrator:
>
> Store connection : First
> Server Host: localhost
> user: root
> port: 3306
> pass: domenica
>
> I have Windows xp home, I download the lastest version
> 5.0.15 Server and Administrator.
>
> The error:
>
> Could not conect to the especific instance.
> Mysql error number 2003
> Can´t connect to Mysql Server on localhost (10061)
>
> I don´t have problems with the connection to Mysql
> Server when I use Mysql Command Line Client, I only
> introduce the password and ready.
>
>
> Regrads,
> Diego Burbano
> Quito-Ecuador
>
>
>
>
> ______________________________________________
> Renovamos el Correo Yahoo!
> Nuevos servicios, más seguridad
> http://correo.yahoo.es
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=billionm@iprimus.com.au


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org