erro E_NOINTERFACE(0x80004002).

[TJS]

getting this error message when trying to open oledb connection to read a
delimited file

E_NOINTERFACE(0x80004002).

I have the schema.ini file in the folder with the delimited text file

what's missing ?

====code====
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>

.....
Dim oCon As OleDBConnection = new OleDBConnection
Dim Adapter as OleDBDataAdapter = new OleDBDataAdapter

Dim strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & vFolderPath & ";" & _
"Extended Properties=""text;HDR=YES;FMT=Delimited"""
oCon.ConnectionString = strConnect

Adapter.selectCommand= new OleDbCommand("SELECT * FROM [" & vFileName &
"]",oCon)
Adapter.selectCommand.Connection.Open

Dim ds As New DataSet()
Adapter.Fill(ds)

.....

 

[Natty Gur]

This KB is about the same problem in ADO it might help you :

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.
com:80/support/kb/articles/q224/1/92.asp&NoWebContent=1

Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)58-888377