What I'm trying to do is encrypt the password first before I "insert" it in the connectionstring. I've got the password encrypted but don't know how to insert it into the connectionstring.
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!
Thanks Scirocco for the reply...
Yes, I am using ADO. I had the connectionstring working before encryption but must encrypt for security reasons. I am decrypting the password and then passing the decrypted password to the connectionstring so I am not sure what you mean by "it should work as long as the server can un-encrypt the password. "
I am not able to get the following working:
cn->Properties("Password")->Value = sPassword
I get the following errors when I complile
error C2064: term does not evaluate to a function
error C2227: left of '->Value' must point to class/struct/union