« ASP split function
get_class() »

Database Connection When Using Stored procedure

Database Connection When Using Stored procedure

Stored procedure Database Connection
When We using Stored procedure , We must connect database with some additional parameters (connection flags).
Because of values returning from procedure, we get “PROCEDURE database_name.procedure_name can’t return a result set in the given context”.

To avoid this, Make connection as,

Mysql_connect (’host’,'user’,'pass’,1,65536)

This entry was posted on Wednesday, January 17th, 2007 at 12:31 pm and is filed under mysql database development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.

All material @ copyrighted by chrisranjana.com. If you want to link to this article you are welcome to do so. Unauthorized publication is strictly prohibited. This developer tutorial website contains articles by Php programmers , Software developers, Mysql programmers and asp c# programmers. This website also contains ajax tutorials and advanced mysql sql stored procedures and functions tutorials and sample codes.