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

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.
Red_EyeAsked:
Who is Participating?
 
rafranciscoConnect With a Mentor Commented:
Try using impersonation in your ASP.NET application.
0
 
rafranciscoCommented:
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
 
Red_EyeAuthor Commented:
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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
rafranciscoCommented:
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
 
Red_EyeAuthor Commented:
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
 
Red_EyeAuthor Commented:
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
 
Red_EyeAuthor Commented:
Thanks that worked what I would like to know now is why?
0
 
rafranciscoCommented:
That is also a mystery with me.  We have always used impersonation to avoid this types of problems.
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.