connect to dbf-file

[meester]

Is there a way to connect and read data from a dbf file with swfkit and ado.
I tried with this connectionscript,

conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\DPTest;Extended Properties='DBASE IV'");

var ds = new ActiveXObject("ADODB.Recordset");
ds.open("select * from dbfile.dbf", conn, 1, 2);

but with no luck so far.

the file I'm trying to read can be found http://www.oefeningen.net/dbfile.dbf

[SWFKit]

Can this file be opened in Microsoft Access? Does it have an index file?

[meester]

I think it was created with Clipper. Cause it has some other files with extension *.ntx in the same directory
It's been generated with an old program for keeping scores.
I' don't know which version of dbase driver i should specify.

if i convert the file with dbf-viewer 2000 to dbase3, i can read it.
But i'ld like to be able to skip this conversion and work with the original file

[SWFKit]

If you change the first byte of the dbf file from 0x25 to 0xF5, your code will work well, don't know why.

[meester]

Can this be done with swfkit.

[SWFKit]

Sure.

var f = new FileStream("c:\\dbfile.dbf", "w");
f.put(0xF5);
f.close();