The 'ASEOLEDB' provider is not registered on the local machine ( windows 64 bit )

I was facing below error in my ASP.net website hosted in IIS 7, windows 2008 (64 bit) . I spent nearly 2 days searching for the solution but could not find the right one that could save my hours of work.

System.InvalidOperationException: The 'ASEOLEDB' provider is not registered on the local machine. at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

So for you guys who are facing same issues just save your time checking below solution. Hope it works for you

In IIS go to your website and find out the application pool that it is using and go to Application pools and right click on the same and click on Advanced settings

Then Select Enable 32-Bit Applications to True

That's it it should work for you no matter what you are using for database either access, Sql server, Oracle or sybase it is the quickest fix.

Read more!

Date functions for Ruby on Rails

d = Date.today # 2008-08-12
d.strftime(‘%b %d, %Y’) # will print August 12, 2008
The following date format is derived from this site.

Date Format Meaning
%a The abbreviated weekday name (“Sun’’)
%A The full weekday name (“Sunday’’)
%b The abbreviated month name (“Jan’’)
%B The full month name (“January’’)
%c The preferred local date and time representation
%d Day of the month (01..31)
%H Hour of the day, 24-hour clock (00..23)
%I Hour of the day, 12-hour clock (01..12)
%j Day of the year (001..366)
%m Month of the year (01..12)
%M Minute of the hour (00..59)
%p Meridian indicator (“AM’’ or “PM’’)
%S Second of the minute (00..60)
%U Week number of the current year, starting with the first Sunday as the first day of the first week (00..53)
%W Week number of the current year, starting with the first Monday as the first day of the first week (00..53)
%w Day of the week (Sunday is 0, 0..6)
%x Preferred representation for the date alone, no time
%X Preferred representation for the time alone, no date
%y Year without a century (00..99)
%Y Year with century
%Z Time zone name

time = Time.new

# Components of a Time
puts "Current Time : " + time.inspect
puts time.year # => Year of the date
puts time.month # => Month of the date (1 to 12)
puts time.day # => Day of the date (1 to 31 )
puts time.wday # => 0: Day of week: 0 is Sunday
puts time.yday # => 365: Day of year
puts time.hour # => 23: 24-hour clock
puts time.min # => 59
puts time.sec # => 59
puts time.usec # => 999999: microseconds
puts time.zone # => "UTC": timezone name

Read more!