asked on

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server ""

Hi guys,
I need help!!! I created a linked server that connects to Access Database but when I call the page from the browser it shows me this error

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server ""

EXEC earth.dbo.sp_addlinkedserver
@server = N'FLEXPROACCESS',
@srvproduct=N'Ms Access',
@provider=N'Microsoft.Jet.OLEDB.4.0',
@datasrc=N'C:\ASP.net Projects\FlexPro DB.mdb'

What do I have to do??? I need this working.
Thanks
Carol

Aneesh

EXEC earth.dbo.sp_addlinkedserver
@server = N'FLEXPROACCESS',
@srvproduct = 'OLE DB Provider for Jet',
@provider=N'Microsoft.Jet.OLEDB.4.0',
@datasrc=N'C:\ASP.net Projects\FlexPro DB.mdb'

Carolinat

ASKER

Still shows me this error

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "FLEXPROACCESS".
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "FLEXPROACCESS" returned message "Unspecified error".

ASKER CERTIFIED SOLUTION

nmcdermaid

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Carolinat

ASKER

It was a security problems that was solved with this site

http://support.microsoft.com/?scid=kb;en-us;Q317012 “Process and request identity in ASP.NET”

Cannot initialize the data source object of OLE DB provider &quot;Microsoft.Jet.OLEDB.4.0&quot; for linked server &quot;&quot;

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server ""