I have written a generalised database access component which construct
the connection string after decrypting its value using DPAPI
methodology.
But as i assign the enitre connection string to <sql connection
object>.conecti onstring property, i get an error always specifing -
"Format of the initialization string does not conform to specification
starting at index _ "
My string is something like
"Server=SQLSERV ER;Database=Nor thwind;UID=user ;PWD=password;T rusted_Connecti on=False"
The index number always point beginning of "PWD" in above case i get
error like -- "Format of the initialization string does not conform to
specification starting at index 45"
However if I hardcode the same string i don't get an error.
Please let me know y this above error popsup evethough i have tried
using stringbuilder also.
any help is welcomed.
james
the connection string after decrypting its value using DPAPI
methodology.
But as i assign the enitre connection string to <sql connection
object>.conecti onstring property, i get an error always specifing -
"Format of the initialization string does not conform to specification
starting at index _ "
My string is something like
"Server=SQLSERV ER;Database=Nor thwind;UID=user ;PWD=password;T rusted_Connecti on=False"
The index number always point beginning of "PWD" in above case i get
error like -- "Format of the initialization string does not conform to
specification starting at index 45"
However if I hardcode the same string i don't get an error.
Please let me know y this above error popsup evethough i have tried
using stringbuilder also.
any help is welcomed.
james