DB Connection String Problem

[bob]

Hi,

I am trying to encrypt my connection string in the app.config file. I am
using Base64 encryption, I just want to hide it from casual users. I keep
getting file not found error. However when I just use the connection string
in plain text I can connect fine. The only difference between the two is
the @ sign is used in front of the connection string (plain) when I view
them in the command window (see below). Any ideas?

? this.connectionString

"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\WINDOWS\\system32\csdm.dll;Jet OLEDBatabase Password=passwd;"

? this.connectionString

@"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\WINDOWS\\system32\csdm.dll;Jet OLEDBatabase Password=passwd;"

 

[Jianwei Sun]

Hi,

I am trying to encrypt my connection string in the app.config file. I am
using Base64 encryption, I just want to hide it from casual users. I keep
getting file not found error. However when I just use the connection string
in plain text I can connect fine. The only difference between the two is
the @ sign is used in front of the connection string (plain) when I view
them in the command window (see below). Any ideas?



"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\WINDOWS\\system32\csdm.dll;Jet OLEDBatabase Password=passwd;"

The way you use '\' is not consistent to me, sometimes, you use "\\",
sometimes you use "\".

I believe if you use @ , you should use single '\', otherwise, you use "\\".

 

[Peter Rilling]

Consider that base64 is not encryption but encoding.

 

[Jon Skeet [C# MVP]]

I am trying to encrypt my connection string in the app.config file. I am
using Base64 encryption, I just want to hide it from casual users. I keep
getting file not found error. However when I just use the connection string
in plain text I can connect fine. The only difference between the two is
the @ sign is used in front of the connection string (plain) when I view
them in the command window (see below). Any ideas?

"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\WINDOWS\\system32\csdm.dll;Jet OLEDBatabase Password=passwd;"
@"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\WINDOWS\\system32\csdm.dll;Jet OLEDBatabase Password=passwd;"

Yeah - don't use the debugger to show you the contents of strings. It
can be very confusing.

See http://www.pobox.com/~skeet/csharp/strings.html in particular, the
sections on literals and the debugger.