I'm trying to connect to a MySQL database using System.Data.Common. I'm need some help trying to figure out the connection string. I've changed some of the connection infromation but basically this is what I have so far. I'm planning on distributing this so I'm thinking that OleDB might be the best way given that I won't have to worry about distributing an MySQL driver. I'm currently working in VB 2005.
factory = System.Data.Common.DbProviderFactories.GetFactory("System.Data.oledb")
cnPTracker = factory.CreateConnection
cnPTracker.ConnectionString = "Provider=****; " _
& "Data Source=****;"" )" _
& "Initial Catalog=PTracker;Uid=****;Pwd=****;" _
& "trusted_connection=true;encrypt=true; " _