>Well, I was able to connect with Nwind by creating system DSN. But for some reason it returns an error (login fails) when I try to connect with my own database.

Hah?

>>
>>What's the value of intItemID in this case?
>>
>
>intItemID should be integer. When I concatenate it to string, should I convert it into char?

Integer is a type not value. :)