Question linking to paradox

[kristof]

Hi,

I try to read a paradox database from VB.NET. My code used to work fine on my previous PC (winXP, 32bit). I now have a Win7, 64 bit laptop and the same code yields this error message (trying to access the same data):

"External table is not in the expected format"

These are some lines of my code:
selectSQLStr = "SELECT * FROM logitPrm"
connectionStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & tablepath & ";Extended Properties=Paradox 5.x"
mAdapter = New OleDb.OleDbDataAdapter(selectSQLStr, connectionStr)

mAdapter.Fill(ds, tableName)



I changed the platform of my project to 'x86' in order to compile the code as 32bit, but that does not seem to help.

Does anyone have any other suggestions?

Thanks in advance!
Kristof

 

[kristof]

Problem solved, I've found a workaround. Just in case anyone else ever runs into a similar problem: the database my code tries to access is managed by another program; apparently this other program does 'something' different (I didn't bother to investigate this in more detail) with the database on a 64-bit machine than it did before on a 32-bit. Running this other program in compatibility mode for 'win XP' solved all my worries (well, actually it led to another error which I manage to avoid by disabling the UAC - told you it was a workaround ).