ODBC or Oledb

Hi guys,

Please give me some recommendation
which is best connection method to connect to MySql using VB & ADO?
Is it ODBC or OledDB Provider?

need some light over here

anyone can correct me if i'm wrong but i think the best way to do a connection nowadays is oledb, i just dont know whats best for MySQL

Hi,,,,
If your mysql database is good for one PC only then OLEDB would be fine....If your mysql database is located on a remote server, ODBC(data sources) would be an advantage...

:) :) :)

please explain what advantage using ODBC on remote access

I'm not sure but is there an OleDb Provider for MySql?