Solution: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine - Added on Fri 27 Jan 2012 11:18
At present, I'm working on a program that takes a CSV file, reads the data and does something with the data, at present it's a 64bit solution - in my case it needs to be a 64bit solution due to the solution in question which can't run in 32bit mode
I'm using the Microsoft Jet OLEDB provider because i need to keep it simple, although Microsoft want people to use Jet, Microsoft recommends using Microsoft SQL Server Express Edition or Microsoft SQL Server Compact Edition when developing new, non-Microsoft Access applications requiring a relational data store, it's over kill for this solution...
You can get a Jet Like Provider for 64Bit Programs by:
Scoins-Cass-Wedding.co.uk - Added on Mon 23 Jan 2012 22:32
For those who don't know, I'm getting married on May 5th 2012... Check out the website...
Getting Session State in HttpHandlers (ASHX files) - Added on Wed 11 Jan 2012 10:58
A reminder to myself and others, when you want to get access to your Session State from an ASHX or HttpHandler, you need to implement IReadOnlySessionState:
Example:
public class DownloadHandler : IHttpHandler, IReadOnlySessionState
At present, I'm working on a program that takes a CSV file, reads the data and does something with the data, at present it's a 64bit solution - in my case it needs to be a 64bit solution due to the solution in question which can't run in 32bit mode
I'm using the Microsoft Jet OLEDB provider because i need to keep it simple, although Microsoft want people to use Jet, Microsoft recommends using Microsoft SQL Server Express Edition or Microsoft SQL Server Compact Edition when developing new, non-Microsoft Access applications requiring a relational data store, it's over kill for this solution...
You can get a Jet Like Provider for 64Bit Programs by:
- Download Microsoft Access Database Engine 2010 Redistributable (of course you'll need to choose the right bit for your server), and install it on your server
- Change your connection string in your code or configuration file from:
"Provider=Microsoft.Jet.OLEDB.4.0;"
to
Provider=Microsoft.ACE.OLEDB.12.0;
Scoins-Cass-Wedding.co.uk - Added on Mon 23 Jan 2012 22:32
For those who don't know, I'm getting married on May 5th 2012... Check out the website...
Getting Session State in HttpHandlers (ASHX files) - Added on Wed 11 Jan 2012 10:58
A reminder to myself and others, when you want to get access to your Session State from an ASHX or HttpHandler, you need to implement IReadOnlySessionState:
Example:
public class DownloadHandler : IHttpHandler, IReadOnlySessionState