MySQL and OleDB.Net provider

[nathanwdavi]

I noticed in the latest newsletter that they said you can only connect to MySQL with the ODB.Net provider. But, I thought it was also possible to connect via the OleDB.Net provider??

Using OleDB.Net would be faster right??

If anyone knows if it is possible to connect with OleDB.Net , can you give a sample connection string?

Thanks,
Nate[8D]

Nathan W. Davis
Web Developer
www.nathanwdavis.com

[bruce]

Yes. Ole would be faster than ODBC.

We weren't able to find a standard Ole data provide for mySQL. Let us know if you know of any.

For best performance, you can use the native .net data provider. There are several of them out there. Review this article, http://kb.discountasp.net/article.aspx?id=10081


[b]quote:Originally posted by nathanwdavi

I noticed in the latest newsletter that they said you can only connect to MySQL with the ODB.Net provider. But, I thought it was also possible to connect via the OleDB.Net provider??

Using OleDB.Net would be faster right??

If anyone knows if it is possible to connect with OleDB.Net , can you give a sample connection string?

Thanks,
Nate[8D]

Nathan W. Davis
Web Developer
www.nathanwdavis.com
</blockquote id="quote"></font id="quote">