The only adapter which will do what you want is a Dr Bott DVIator - which is an active adapter with a power supply, expensive as all heck, and not even that easy to find. You will also need a miniDVI to DVI adapter.

It would be far cheaper, quicker and easier to just get another monitor.