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.