BorlandTalk.com

Jos · Guest

Hi,

I'm trying to connect to a Paradox db using ADO. In my situation it is
not possible to use BDE.
A search of the newsgroups learned me that it should be possible to
access a Paradox table using ADO. So I made a small program to
experiment with this. But all I'm getting is: 'External table is not
in the expected format'.
The Jet engine has the latest sp (SP8 - msjet40.dll =4.0.8015.0).

This is my source code:
try
outputdebugstring('0');
if ADOConnection1.Connected then
ADOConnection1.Close;
with ADOConnection1 do
begin
outputdebugstring('1');
Provider := 'Microsoft.Jet.OLEDB.4.0';
outputdebugstring('2');
Properties['Data Source'].Value := '.';
outputdebugstring('3');
Properties['Extended Properties'].Value := 'Paradox 5.x';
outputdebugstring('4');
Open;
outputdebugstring('5');
end;
ADOTable1.TableName := 'SCM.db';
outputdebugstring('6');
ADOTable1.Open;
outputdebugstring('7');
except
on E: Exception do
ShowMessage(E.Message);
end;

The last debugstring I see is Nr 6, so opening the table results in
the error.
When I run this program on a computer with BDE installed it works just
fine,
but that is propably because the BDE takes over.

Can anybody help me?

Greetinx,

Jos