I had 4.0 installed and activated yet when I tried to go in and set the table for a script using a simple ADOXSchemaProvider pointing to an access db it is giving me the error "Unable to populate tables. Please check your data source properties and try again." the stack trace is:
System.Runtime.InteropServices.COMException (0x800A0E7A): Provider cannot be found. It may not be properly installed.
at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options)
at SchemaExplorer.ADOXSchemaProvider.GetCatalog(String connectionString)
at SchemaExplorer.ADOXSchemaProvider.GetTables(String connectionString, DatabaseSchema database)
at SchemaExplorer.DatabaseSchema.get_Tables()
at SchemaExplorer.Design.TableSchemaPickerUI.b()
I don't know how to fix this. I have already reinstalled, and upgraded to the latest version. I have verified the ADOXSchemaProvider is in the SchemaProviders directory. It did work fine when I was running versions 2.6 and 3.0.
Thanks in advance for any help.