SchemaExplorer and MS Access

I'm trying to write templates to write VB6 classes. I have to connect with a lot of MS Access databases at work, and I was trying to make a template to read the columns in an Access table.

More info:

System.Runtime.InteropServices.COMException (0x80004005): Could not find installable ISAM.
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.PopulateTablesListBox()

Why is it looking for an ISAM driver?

Finally figured out what was going on...

Gotta make sure that the connection string is specific for ADO.NET
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\yourpathhere\db1.mdb;

Make sure that it is "Data Source" and not "Database" like in classic ADO connection strings.

Great! Glad you got it figured out. I was going to help you out, but things have been really busy lately and I didn't have a chance to look up the exact connection string syntax for you.

Eric J. Smith

Hello, I have added an Access database in the Schema Explorer toolbox : Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\db1.mdb;Persist Security Info=False

When I click on tables in Schema Explorer toolbox I'm receiving the following message :

" Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))

An error of type "COMException" occured while attempting to populate schema information.  Please check your data source settings and try again. "

System.Runtime.InteropServices.COMException (0x8002801D): Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))
   at ADOX.TableClass.get_Properties()
   at SchemaExplorer.ADOXSchemaProvider.GetTables(String connectionString, DatabaseSchema database)
   at SchemaExplorer.DatabaseSchema.get_Tables()
   at b2.a(Object A_0)

 Can you help me with this?

Thx,Daniel

Hello,

You might want to see if the solution on the following website works for you. If not I would check the Excel newsgroups.

Thanks

-Blake