?
Solved

Linked Jet (Access) database problem Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'

Posted on 2005-04-14
8
Medium Priority
?
435 Views
Last Modified: 2008-02-01
I have and JET DB setup as a linked server in SQL server. I then access the Data via a website written in ASP.Net using the sql data client. Now this has worked on my test machine and on one other server however I can't get it to work on my new server. I keep getting the following error.
System.Data.SqlClient.SqlException: Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'.
Thats it no mention of why!
I have checked the file permissions and set the folder permission that the mdb file is in to everyone has full control. I have check the permissions in SQL Server and they are the same as my test machine and the old server. I have even run the same sql query in sql analyser on my test machine (I have remote access to the server) an it returns the data no problem. So I don't know what to try next.
0
Comment
Question by:Red_Eye
  • 4
  • 4
8 Comments
 
LVL 28

Expert Comment

by:rafrancisco
ID: 13781832
What's the operating system of your new server?  Was it an upgrade or a new install?

Just want to verify, so you also tried to run the SQL query in Query Analyzer on the new server and you got the result you wanted, right?
0
 

Author Comment

by:Red_Eye
ID: 13782087
Windows 2003 server standard edition brand new install. When I ran the query in query analyzer it returned the result set I was expecting. I
0
 
LVL 28

Expert Comment

by:rafrancisco
ID: 13782614
Have to tried to issue a SELECT on an SQL Server table from your application?  If you have the Northwind database, try selecting from the customers table and see if you will get the same error.

Also, are you using impersonation?  

What was the OS of the machine where it was working?  I am assuming it is not Windows 2003 server.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Red_Eye
ID: 13782712
I am running window xp. Yes I have tried running a query on the sql table from the app and it runs fine. So I know that the instance of sql server is working. The query I am using to get a results set back from the linked table is.
select * from <name of linked server> ...security
0
 
LVL 28

Accepted Solution

by:
rafrancisco earned 2000 total points
ID: 13782814
Try using impersonation in your ASP.NET application.
0
 

Author Comment

by:Red_Eye
ID: 13783012
Thanks for the suggestion but why would this work. I have set the folder permission to allow everyone access to the folder the mdb file is in aslo I haven't needed to use this on the other server which is windows 2003.
I will try it though.
0
 

Author Comment

by:Red_Eye
ID: 13788986
Thanks that worked what I would like to know now is why?
0
 
LVL 28

Expert Comment

by:rafrancisco
ID: 13790608
That is also a mystery with me.  We have always used impersonation to avoid this types of problems.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question