First, set a breakpoint at line conn.Open();, execute the line and check conn.State. It should be Open (or ConnectionState.Open) if your connection string is ok. Otherwise, recheck connection string...

AFAIK with SQL Server 2000 you need to use textcopy utility. Check this MS forum's thread if it helps:
using textcopy to import image file (jpg) to sql server DB in SQL Server Programming...

What programming language you're using? If VB.NEt, you may try Daniweb's site search. I've answered the same or at least very similar question few times. A pretty good search phrase is "image SQL...

Since you have two different Availability values, you'll get two rows no matter what you do. Drop the dbo.RoomRates.Overflow = 1 check.

Or use that query as a sub query:
SELECT DISTINCT...

I didn't test this but if I remember right the syntax goes:

Imports System.Data.OleDb

Dim strSQL As String
Dim oConn As OleDb.OleDbConnection
Dim oCmd As OleDb.OleDbCommand

oConn = New...