ODBC Paramater Problem

[microsoft.public.dotnet.languages.csharp]

I am getting an error: ERROR [07002] [Microsoft][ODBC Microsoft Access
Driver] Too few parameters. Expected 1 with the following code:

public static string GetTitle(int CatID)
{
OdbcConnection conn = new
OdbcConnection(ConfigurationSettings.AppSettings["ConnString"]);
OdbcCommand command = new OdbcCommand("SELECT Category FROM Categories
WHERE CategoryID = @CID", conn);
conn.Open();
command.Parameters.Add(new OdbcParameter("@CID", OdbcType.Int));
command.Parameters["@CID"].Value = CatID;
OdbcDataReader reader =
command.ExecuteReader(CommandBehavior.CloseConnect ion);
reader.Read();
string s = Convert.ToString(reader["Category"]);
conn.Close();
return s;
}

I have to use a DSN and the ODBC Connection. Is it a problem with my
parameter?

Thanks,
Marty
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Eki Y. Baskoro]

G'Day,

What's the value of ConfigurationSettings.AppSettings["ConnString"]
variable? That's where the error should be.