To read csv file from .net I am using following code
Dim strOleDbConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & path & ";Extended Properties=""Text;HDR=" & header & ";FMT=Delimited"""
it is working fine when I am debugging inside visual studio 2008 on Windows Server 2008 R2 64 bit machine
but when I build and configure it on IIS 7.5 it is giving following error
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
I tried installing following thing on the server
Microsoft Access Database Engine 2010 Redistributable
2007 Office System Driver: Data Connectivity Components
but still I am getting the same error.