Which License of MySQL Should We Buy?
hi, I'm working in a company which wants to have a client/server application on MySQL DBMS. our company uses MyODBC and MySQL Connector/.Net. We want to sell our application which license should we buy? Should we buy MySQL Network license? or there are seperate licenses for connectors? and should our customers buy MySQL license so that they can use our application on a MySQL DBMS? or they can just download it and use it with our application?(They should have at least one MySQL Server so that our app. can work on it.) Thanks in advance Chagh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
return result set in SPs and using MyODBC
hi all, how can we have a select satement in an SP?(i want to return a result set from the SP). i want to migrate from SQL Server to MySQL and i don't know what to do with these SPs. it can be done in MySQL client, but it gives the error:procedure foo can't return a result set in the given context MySQL in the application. can i set a cursor out put parameter and return it?(just like Oracle) or it has another solution? and another question: is MyODBC 3.51 tested with MySQL 5.x? can we call an SP from Delphi via MyODBC? (i tried to do so (using ADO an a data provider for OLEDB) but i think somewhere in passing the call statement it had put {} around call sp() statement so that mysql returned an error about the syntax.) Thanks in advane Chagh - Start your day with Yahoo! - make it your home page
Prepared statements in MySQL
hi, i've got some questions: what happens when we deallocate a prepare statement? can we use same name for 2 prepared statements in a SP by deallocating first one before defining second one? can we use a prepare statement in a loop? can we use more than 1 prepared statement in a single SP? Thanks in advance Chagh - Start your day with Yahoo! - make it your home page