Application error: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

September 6th, 2012

This article is about fixing the error listed above. The time I was working on this problem I was running into all sorts of posts and forum which described this error but none really were concrete enough to solve the issue for me. Finally when I was able to solve this issue for myself. I decided to list down all the issues that I was running into and steps I took to fix this problem.

*********************

Problem: Application error: The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine.

*********************

Solution: The Fix in my case was to “Enable 32-bit Applications” to “True", even though I had the 64 bit Driver version installed.

*********************

Links Tried:

*********************

SQL: To list all the user created table in a database.

September 6th, 2012

Acknowledgement:

I will like to first of all give my due reference to the original blog post for my search by Mr. Pinal Dave. Here is his original article which is my inspiration.

I ran this Query on SQL Server 2008 R2 and SQL Server 2012 and it ran, the link is from SQL Server 2005 and it work on all of them. So it is safe to say Query has been pretty generic or that Microsoft hasn’t make too many changes too their Schema design.

Aim:

To list all the tables in the database.

This is a very simple request and can be done very easily in multiple ways.

Queries:

Use [YourDBName]
Go
Select * from sys.Tables –Query 1
GO
Select * from sysobjects where xtype = ‘u’ –Query 2
Go

Result:

This will return all the tables in the database which user have created. The return resulset will include the following columns:
name, id, xtype, uid, info, status, base_schema_ver, replinfo, parent_obj, crdate, ftcatid, schema_ver, stats_schema_ver, type,  userstat, sysstat, indexdel, refdate, version, deltrig, instrig, updtrig, seltrig, category, cache

ozlu Sozler GereksizGercek Hava Durumu Firma Rehberi Tv de bugun E-okul Veli Firma Rehberi