You need to use the IMEX command in the connection string. MSDN has all the details.
I had the same problem a while back and posted the detailed solution on this page. Search here and you should find it. (Search for IMEX.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon