CODEWITHSUNDEEP
ms-accessreporting-servicesdataset
smutzel
smutzel

Reputation: 11

SSRS Dataset Business object cannot be created

I'm attempting to create a SSRS dataset pointing to an Access Database(I know... Access, users choice). I created the DataSource fine as below. When I create the dataset I get the following error:

Business Object cannot be created.

Any help would be appreciated. 

Provider=MS Remote; Remote Server=\\MYSERVERNAME; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source= \\MYSERVERNAME\C:\SHARE\OVERVIEWS.mdb;

Thank You

Steve

Upvotes: 1

Views: 137

Answers (1)

JonTout
JonTout

Reputation: 640

If the share exists, the correct path would be along the lines of

Data Source= \\MYSERVERNAME\SHARE$\OVERVIEWS.mdb

Upvotes: 2

Related Questions