SchemaExplorer and MS Access

Last post 05-28-2008 11:52 AM by blake05. 5 replies.

Page 1 of 1 (6 items)
	Sort Posts: Previous Next

08-26-2003 9:30 PM

slartibartfast
Joined on 08-26-2003
Springville, Utah
Posts 23
Points 380

SchemaExplorer and MS Access

Reply Contact

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.

Does SchemaExplorer support MS Access?

- Hector

So as a rule you can recognize genuinely smart people by their ability to say things like "I don't know," "Maybe you're right," and "I don't understand x well enough."

Post Points: 35

08-28-2003 4:41 PM In reply to

slartibartfast
Joined on 08-26-2003
Springville, Utah
Posts 23
Points 380

RE: SchemaExplorer and MS Access

Reply Contact

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?

So as a rule you can recognize genuinely smart people by their ability to say things like "I don't know," "Maybe you're right," and "I don't understand x well enough."

Post Points: 5

08-29-2003 5:59 PM In reply to

slartibartfast
Joined on 08-26-2003
Springville, Utah
Posts 23
Points 380

RE: SchemaExplorer and MS Access

Reply Contact

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.

So as a rule you can recognize genuinely smart people by their ability to say things like "I don't know," "Maybe you're right," and "I don't understand x well enough."

Post Points: 5

08-29-2003 6:42 PM In reply to

ejsmith
Joined on 12-27-2002
Dallas, TX USA
Posts 2,185
Points 922,065

RE: SchemaExplorer and MS Access

Reply Contact

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

Eric J. Smith
CodeSmith Tools, LLC
Chief Software Architect

Post Points: 35

05-04-2008 8:17 AM In reply to

dadib
Joined on 05-04-2008
Posts 1
Points 35

Re: RE: SchemaExplorer and MS Access

Reply Contact

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? Tongue Tied