SqlException: Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'

  • Thread starter Thread starter Evan Camilleri
  • Start date Start date
E

Evan Camilleri

I am accesing an SQL Server through a stored procedure which (this stored
procedure) accesses a linked-server (an access database).

Fom Win2000/XP PCs I am having no problems.

From 98 PCs I am having SqlException: Could not create an instance of OLE DB
provider 'Microsoft.Jet.OLEDB.4.0'. I thought that the clients do not take
care of the 'Jet' since the SQL Server should provide it! I installed even
MDAC 2.8 on the clients but still have this problem.

Any ideas?

Evan Camilleri
 
The only problem is that there is ONLY service packs for Jet and NOT jet!

Evan Camilleri
 
Hi,

Each service pack installation is a full Jet installation and you should not
worry about this side. But you should install version for the proper
platform

--
Val Mazur
Microsoft MVP

http://xport.mvps.org
 
no it did not work!

in any case, the strange thing is that i though that ole db must be
installed ONLY on the server and not on all clients since this is a linked
server.

Evan
 
Strange. Service pack should install everything. You need to install it on a
client, because even in a case of linked server, your client works locally
through the provider.

--
Val Mazur
Microsoft MVP

http://xport.mvps.org
 
I did NOT manage to solve it! I even tried to install Access 2000 runtime
just-in-case but in vain! The problem was only on 2 PCs at a client! A
Win98 on my network worked OK!

MAybe it was rights then?

In any case, I did a woraround! What I did was to recreate the
linked-server from Access to an SQL database (importing all data) and it
worked!

Evan
 
Back
Top