ASP connection to MySQL

What is the best connection type? Why?

[Night_Hawk]

I want to connect to MYSQL database from ASP.
Which connection type should i use and why?
I am looking for speed and less strain on the server.
Thanks.

AJ

[wardbekker]

Night_Hawk,

I don't know about performance, but you could use the mySql ODBC driver. Visit [mysql.com...] for the driver.

[duckhunter]

Night_Hawk,
If you have ADO with an OLEDB provider, that is the way to go. ODBC adds a layer of overhead. You'll find connection pooling runs smoother using OLE vs ODBC too.

Something like this: strConnect = "Provider=MySQLProv;Data Source=mySQLDB;User Id=myUsername;Password=myPassword;"

I use SQL and my provider is SQLOLEDB. I'm trying to find the MySQL one.