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

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
 
E

Evan Camilleri

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

Evan Camilleri
 
V

Val Mazur \(MVP\)

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
 
E

Evan Camilleri

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
 
V

Val Mazur \(MVP\)

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
 
E

Evan Camilleri

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
Please Enter MS JET OLE DB Initialization information 5
OLE DB Provider for Jet 4.0 2
Problem connecting to an Access DB 1
entry point of OLE DB Provider 2

Top