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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

An OLE DB Provider was not specified in the ConnectionString 6
Ole DB Jet 4.0 Provider corrupts recipient Excel database predicta 3
"Could not execute query against OLE DB provider 'MSIDXS'" 0
Provider=Microsoft.Jet.OLEDB.4.0 1
Problem connecting to an Access DB 1
OLE DB Provider for Jet 4.0 2
How do I Connect TO MS Access Database using OLEDb.NET/ADO.NET? 1
ADODB connection creates error; using Microsoft.Jet.OLEDB.4.0 as data provider 2

Back
Top