problem when changing default sqlite to mysql

hi all,      i installed rails 2.1.0 just now before i was working with rails 1.2.6. when i try to check the application enviroment link in the index page of the application it gave me       " MissingSourceFile in Rails/infoController#properties         no such file to load -- sqlite3RAILS_ROOT: D:/RadRails/Workspace/Varsha "      here i am using win XP, no sqlite installed.

i have mysql in my network so i changed (default db sqlite to mysql in )the app_enviroment.rb file of rails gem folder but it's raised an error like..

Errno::EBADF in Rails/infoController#properties Bad file descriptor - connect(2) RAILS_ROOT: D:/RadRails/Workspace/Varsha

Application Trace | Framework Trace | Full Trace C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/vendor/mysql.rb:111:in `initialize'                         ............                         ...........

plz. guide me to solve the above.

thanks in advance madhan.

Hi Madhan,

My guess is that Rails is trying to connect to your MySql server via a
socket, which - on Windoze - can be a tad problematic... try
configuring Rails so that it makes a TCP connection instead, by setting:

  host: THE_NAME_OF_YOUR_WINDOZE_BOX   port: 3306

... in your application's database.yml file.

Good luck,

Peter