Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5791
  • Last Modified:

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
0
Carolinat
Asked:
Carolinat
  • 2
1 Solution
 
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
 
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
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now