ADS 11 adsenableencrytion Crw 11

[Former Member]

I cant decrypt  table or record information on Crystal reports XI.

I',m using crdb_ads.dll to acess data.

Is there some parameter that is missing in the connection string?

Regards

Antonio Ferreira

[Former Member]

Are you using a Data Dictionary or free tables?  I don't believe you can use Crystal reports to access encrypted free tables, but it should work just fine with encrypted tables that are part of a data dictionary.

One other alternative is to create a #TEMP table to hold the data and use that in the report instead of the actual encrypted table.

To do this, you need to pass the connection handle that created the #temp table to Crystal.

The help has quite a bit of information:  Providing an External Advantage Connection Handle to the Advantage Crystal Reports Driver

[Former Member]

I'm using free tables.

If the table its in the dictionary what is then the connection property to Crystal.

[Former Member]

You pass the Dictionary File as the connection path in Crystal.

FreeTable connection path = c:\some\path\to\folder
Dictionary connection path = c:\some\path\to\folder\dictionary.add

You will need to provide the username/password to authenticate to the dictionary.

Once the authentication is successful, the server can un-encrypt the tables for access.  When using a Data Dictionary there is no need to use AdsEnableEncryption as it is all handled automatically.

Edgar

[Former Member]

Ok Thanks for the info