Does anyone know how to pass a variable (in my case value of password) to the connectionstring?

I was hoping it would have been as easy as the following:

spCON->ConnectionString = L"driver={sql server};SERVER=SEW01178;uid=user;pwd=" & pword & ";Database=TestlDB;";

but of course it wasn't. Any help would be appreciated!

Thx
Eric2000

Did you really name your login "user" for this test??? That sounds like a receipe for a disaster to me!

-PatP

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.
thx
eric2000

No, that id was just a sample one I used for this post...

Are you using ADO? It should work as long as the server can un-encrypt the password. Try doing the same but without encrypting this time to see if the encryprion is the problem.

Another way is to use the properties of the ADO Connection Object as follows:

cn.Properties("Password").Value = sPassword

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

thx again
eric2000

Look here for a .Net solution to encrypting a password in a connection string.
My Blog