Friday, February 24, 2012

Connection string problems

I've got a problem with a connection string that is dynamically generated at runtime. The password for the connection string is encrypted and then put in the connection string. Some of the passwords encrypt to weird chararcters, but, they have always worked in regular ADO (I'm porting this behavior from a VB6 program) and the password works when I copy it over and login via Query Analyzer. The error I get is:

"Format of the initialization string does not conform to specification starting at index 113"

I'm thinking that ADO.NET encodes it incorrectly. I've run across this: http://support.microsoft.com/?kbid=823679 kb article but I'm not sure if this is my problem. Has anyone else been able to figure out what is wrong with it?It could be. If so, re-download the 1.1 sdk. It could be that your encryption is dumping a bad value.

System.Diagnostics.Debug.WriteLine(ConnectionObject.ConnectionString);
Find out how it's being passed in.|||The connection string is a valid connection string... the problem is that the sqlconnection object is choking on a valid connection string based on some weird characters. I need to know if it's possible to get around this.|||those weird characters.. are they entered as such in sql server? and what version framework are you using?

No comments:

Post a Comment