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
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