Re: Does anyone call stored procedure successfully in MS dotnet platform?

[Brad Howlett]

Hi,

I'm having a similar problem calling stored procedures using MySql 5.0.0-alpha-nt with mysql-connector-net-1.0.2 in a web service written in C#. I can successfully connect to the database and retrieve results using a standard text query, but when attempting to call a stored procedure I get the following exception:

MySql.Data.MySqlClient.MySqlException: Exception trying to retrieve parameter info for GetHardwareTypes: Invalid attempt to access a field before calling Read() ---> MySql.Data.MySqlClient.MySqlException: Invalid attempt to access a field before calling Read()

In addition to this, about 50% of the connection attempts when calling the web service from a Pocket PC device returns the following message:

The response did not contain and end of entry mark.

Any help in regards to these errors would be greatly appreciated.

Cheers,
Brad.