ADO+Microsoft.Jet.OLEDB.4.0

[michaenh]

Hi.

I use ADO and Microsoft.Jet.OLEDB.4.0 provider to connect to a MSAccess2000 database.
Some of our customers have some problem to connect to the database with the program. (Only few computers).

I don't why... any clue? Is it because of MDAC? Some needed system files? Some needed driver or dll?

But it is strange because I tried it on a fresh Win98SE without any other software installed(no MDAC) and it worked...

The problem seems to occur in some few somputers and it is no matter if it is XP, Win98 or Win2000, etc.

cheers,
mha

 

[whosrdaddy]

you MUST have MDAC on your machine if want to use OLEDB provider. just install a recent version (2.7 or later)

http://www.damovo.com

 

[michaenh]

Hi.

It does not help with the latest MDAC.
It does not even help that the computer have office package installed..

1.databasefile-corrupt
No the database is not corrupt.. it is on a server and other clients work except for one special
computer
2.no permission to read file
full permission
3.no permission to write file
full permission
4.no permission to create file (msaccess lockfile for ex)
full permission
5.mdac not installed
newest mdac from Microsoft

I'll be back... for more info..

this is strange... by the way thanks..

cheers,
mha

 

[michaenh]

I will try this:

try InfoDB.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source.. '
with InfoDB do begin
Open;
if Connected then
Result := True
end;
except on e:exception do
ShowMessage('fail to connect to database'+e.message); //fail
end;

to see the error info on..

cheers,
mha

 

[VintageWine]

Try ComCheck. It is a Microsoft utility to check out installed version and integrity of MDAC

http://www.microsoft.com/downloads/...F6-4A21-4B43-BF53-14332EF092C9&displaylang=en

Simon

 

[michaenh]

Hi.

I will try that.. thanks..
Seems to be cool...

cheers,
mha