Index problem

[matthieu99]

Hi.

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.

This is the message I get when I try to connect to a FoxPro DBF through the Web. The error is caused when I open my recordset. Ex: Rs.Open "select * from tran", Conn

It must be noted that this DBF file is indexed with a CDX file. When I delete the CDX file it works fine.

It is also to note that the FOXPRO DBF file resides on the Web Server.

My connection string looks like this:
Conn.ConnectionString = "Driver=Microsoft Visual FoxPro Driver; SourceType=DBF;SourceDB=e:\ndata;Exclusive=No;BackgroundFetch=No;"

Thanks,

Matthieu

 

[rgbean]

What version OLEDB provider are you running? The one that came with VFP 7.0, 8.0 Beta, or 8.0?

Rick

 

[mkrausnick]

And what are the definitions of the tags defined in the CDX file?



Mike Krausnick