Topic: Windows Server 2003 and SQL Server 2005
I'm using a remote SQL Server 2005 and RoR running on my desktop (WEBrick) to develop my application. To get RoR to work with SQL Server I followed the instructions on the RoR Wiki (http://wiki.rubyonrails.org/rails/pages tSQLServer). This works perfectly.
For testing I'd like to move the application to a server (Windows Server 2003). InstantRails (http://instantrails.rubyforge.org/) seemed like the easiest way to do this. I installed it as per the instructions and deployed my application. I started the application with Mongrel but I got the following error as soon as I tried to visit any page.
OLE error code:800A0E7A in ADODB.Connection
Provider cannot be found. It may not be properly installed.
HRESULT error code:0x80020009
It appears that the application is unable to connect to the database. Does anyone know what is going on here?
I also tried localhost as the host.