View shortcut connection string

[OpenIT Solutions]

Hi,

I created a shortcut eap file sometime ago that connects to our SQL Server repository. I need to check the connection string being used. Is there a way to check a shortcuts connection string ?

Thanks,

Jon.

[qwerty]

In that case the EAP is a text file containing the connection string.

q.

[Geert Bellekens]

In that case the EAP is a text file containing the connection string.

q.

If you are lucky and the connection string hasn't been encrypted when saving the shortcut file.

Geert

[OpenIT Solutions]

Thanks both. It wasn't encrypted ! So don't have to fess up to the DBAs that i'd forgotten the password :-)

[qwerty]

In that case the EAP is a text file containing the connection string.

q.

If you are lucky and the connection string hasn't been encrypted when saving the shortcut file.

Geert

I have never seen it "encrypted" (probably obfuscated would be more correct). Do you know when that happens?

q.

[OpenIT Solutions]

I beleive you can check Encrypt password when you create the shortcut...

[qwerty]

There's no such question. When you create a shortcut file it contains the EAConnectString (file name of the real EAP) and some OpenActions. You need to know the password of the real EAP if it has security turned on.

q.

[OpenIT Solutions]

Yep sorry the question is 'Encrypt connection string'.

[Geert Bellekens]

I've seen it encrypted.
It looks like a bunch of random characters.

Geert

[qwerty]

Yet another secret to be unveiled.

q.

[Geert Bellekens]

My bet is that base64 encoding has something to do with it  

Geert

[qwerty]

You can easily proof that: select the text in Notepad++ and try Mime Tools/base64 decode.

The question still stays open: when do they encode it?

q.

[Geert Bellekens]

When you do Save Shortcut on a DBMS model and select the encrypt connectionstring.

On second thought, probably no base64 encoding as it contains all these special characters

Code: [Select]

EAConnectString:EA_Horizon --- DBType=1;ConnectEx=Mo0XR2;w%'IVnO#HM:PcM..U\)lKm4-lM{z80?LvWvM;>m-C[+)VE-h0uCZZQ^AOgjf0:jt\$fY11KL&KC}jbn5v(0{)gJ%6(+wiDt,KJD1"e5S_8-hp'wGDTZ+t?dPgu>gr[.-k_wN$d#[':TIXQ`u`?9
Geert

[qwerty]

Definitely not base64. Its length is not a multiple of 4. Further (IIRC) it uses chars which are not part of base64. I'll try once I've setup a local RDBMS.

Thanks.

q.