Re: stored procedures with out parameters

Nagesh Sharvari-A21337 wrote:

> Hey, 
>     I was searching in the net for a solution for this problem and found
> this link :
> http://archives.neohapsis.com/archives/mysql/2004-q3/1719.html
> It says, my-ODBC 3.51 does not support stored procedures yet. Is this
> the reason, my code is failing?? 
>   

The very latest version of MyODBC-3.51.x which was posted here a while 
ago ( direct link: 
ftp://ftp.mysql.com/pub/mysql/hidden/connectors/odbc/mysql-connector-odbc-3.51.13-win32.msi 
) does actually allow you to activate a stored procedure from MyODBC. Be 
warned, however, that it was remarkably unstable on my system, and 
what's worse, it was remarkably difficult to uninstall and replace with 
a previous version. I was getting MS Access crashes every 30 seconds or 
so, no matter what I did. It might be more stable with other 
applications. For those wondering, yes I reported all issues I had, 
submitted crash logs, SQL logs, etc. I've been a good beta tester, at 
least when I can find something beta to test.

Reading back over your original post, it seems you're using MyODBC with 
unixODBC. I don't think there are Linux / Unix binaries for 3.51.13 yet. 
If you can track down the source to MyODBC-3.51.13, you might be able to 
get somewhere further.

> If so, is there a solution for this? or should I wait for 3.53 to be
> released?
>   

Yes. The consensus is that we wait. We wait until hell freezes over, we 
wait until the cows come home, we wait until George Dubya finds WOMD in 
Iraq, and we wait until a meadow of four-leaf clovers covers Antarctica.

> When is myODBC 3.53 getting released? It seems, this discussion happened
> in 2004 July. and yet I couldn't find MyODBC 3.53. 
> regards
>   

That's right. There has been talk of a release for almost half a decade 
now. In the meantime, I'm busy porting stuff to Postgres, which has 
client libraries that are being actively developed. Seriously, they 
release drivers! Lord knows how, but they do it.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@xxxxxxxxxxxxxxxxxxxx
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx