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
CarolinatAsked:
Who is Participating?
 
nmcdermaidCommented:
Why are you linking the server every time from the page? Once it's linked once it should stay there permanently.

Therefore you should only have to run sp_AddLinkedServer once, which will create a linked server called FLEXPROACCESS

From then on you should be able to access your tables something like this:

SELECT * FROM FLEXPROACCESS...TableName


Regarding the actual error, try running Filemon to see if there is a permissions issue when trying to use the driver.


The JET driver needs to do some silly thing like create a temporary file in the windows folder and iften the user doesn't have access to do that (which is prettyy much the way you want it with a web user anyway)

0
 
Aneesh RetnakaranDatabase AdministratorCommented:

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'
0
 
CarolinatAuthor Commented:
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".
0
 
CarolinatAuthor Commented:
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”

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.