oledb

what is the difference between OLE DB and ODBC data sources?

by

I was reading a MS Excel help article about pivotcache and wonder what they mean by OLE DB and ODBC sources …You should use the CommandText property instead of the SQL property, which now exists primarily for compatibility with earlier versions of Microsoft Excel. If you use both properties, the CommandText property’s value takes precedence. … Read more

Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine

by

I created a windows application developed in .NET 3.5 in a 32 bit Windows 2008 server. When deployed the application in a 64 bit server it shows the error “Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine “. So as a solution to this issue, i have changed the build property of the project … Read more