MyODBC 3.53 will be the next majour release (not 3.52) and it will support stored procedures so please hang on a bit. At the moment we are focusing on a backlog of MyODBC 3.51 bugs/issues.
Peter Harvey, Software Developer MySQL AB Office: +1 619 251-6923 Are you MySQL certified? www.mysql.com/certification -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 10:02 AM To: [EMAIL PROTECTED] Cc: MySQL Subject: Re: ODBC & Stored procedures Wow! the list is quiet today, I really expected someone to respond to this by now. Just in case you didn't understand the problem: He is connecting to a 5.0 database using ODBC version 3.51 and running a stored procedure. He is having problems getting return values from his stored procedures through the defined OUT parameters through the ODBC driver. The ODBC driver is having no problems with his IN parameters (it seems to create his temporary table just fine). If he tries it from the mysql client, everything works just fine. His questions: Is there anyone else using ODBC 3.51 that is able to get at the values of the OUT parameters of a MySQL stored procedure? How are you doing it? Will ODBC 3.52 support the OUT paramters of stored procedures? If so, when will it be available? Are there any other ideas that he can use? Well, I can't answer anything about the ODBC driver being able to handle SP parameters but I do have a suggestion. Instead of putting all of your return values into OUT parameters, can you return a recordset that has those values as column values? SELECT @outparam1 as outparam1, @outparam2 as outparam2 .... Then all you need to do is check the fields of the returned recordset to read your values. I know that if you are using ADO to access your ODBC driver, you have the ability to recieve multiple recordsets as the result of a single request (I know it works with Access and MS SQL Server through ADO/ODBC so I assume it will still work with MySQL). If your OUT parameters are in the first recordset, you can still get to any other returned records in the second. FWIW, Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] wrote on 07/30/2004 11:49:09 AM: > Hi, may be my english is poor, sorry for this. > > I'll be trying with odbc 3.51 and sp on 5.0 that returns out params and didn't > work (at least for me). In parameters works fine. > From mysql client command line out parameters works fine. > > The sp makes about 50 selects, this increase a lot the traffic on my > lan if I didn't use it. > > The way to do this work through odbc was create a temporary table > into the sp and > fill one record with the out values (this exists only for the > connection who call the sp). > From the odbc client, I call the sp then make a select over the temp > table and then drop it. > > Someone try out params with odbc and works? any other idea? odbc 3.52 > support out params? when odbc 3.52 will be released? > > Thanks, Alejandro > mailto:[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
