i can connect with a design time hard coded string but not with one i
get from console input at runtime.

	//works fine:
	bstr_t strCnn = "Provider='sqloledb';Data
Source='OKSANA\\OKSANA';Initial Catalog='pubs';Integrated
Security='SSPI';User ID=bla;Password=bla";

//works when myString was assigned hard coded connect string.
const _bstr_t strCnn(myString.c_str());	

the above line will not work if myString got it's value from console
input with or without the const at the beginning of the line. I've
tried char arrays and char *, nothing works if i don't hard code the
string.

---

Clarification of Question by yagiroy-ga on 02 Jun 2004 19:57 PDT

i found the problem, the double backslash needs to be replaced with a
single backslash when passing from the command line because in this
case the string doesn't need to be parsed and because of this escaping
the backslash is wrong.