Oracle 9i to MySQL

[Aiden Leech]

Hi All,

I am looking to migrate my existing personal web application to use MySQL, which I am completely new to. The application I have is very small at the moment and my main motive for moving to MySQL is so I can get the application hosted more easily and cost effectively. I have a number of packages and stored procedures that are called from a VB DLL and passed to an ASP interface.

Specific questions I have are:

1. Does MySQL facilitate stored procedures or would I need to use MaxDB by MySQL for this? Does this go for packages / user-defined data types?

2. What are the most important considerations for setting up connection to and manipulating data in MySQL using VB? (I realise this is more of a data connection consideration rather than Oracle.)

3. Would it be better to forget about creating VB DLLs and just connect to MySQL within my ASP using the API methods provided?

Any useful information would be marvellous.

Kind regards,

Aiden