Custom Crystal Reporting with ODBC

Yahoo Archive
1
Hello, We had the same problem (we use Crystal XI). What I did was
when creating the report within the "Data Expert" I select "Create New
Connection" then "ODBC(RDO)"
This brings up a screen where I select "Enter Connection String"
I then enter

Driver=Data Direct 4.20 32-BIT OpenEdge SQL v10.0B; DB=mfgsys80;
PORT=8050; HOST=xxxxx; UserID=xxxxx; PW=xxxxx;CMT=2

We had created a user for accessing the database called ODBCUser which
I used for the UID.

Hope this helps.
djj
2
I have a report that is initiated through Vangtage, but I have to setup
each client that accessing the report with ODBC and enter the registry
settings for a secured account in the Progress database.

Since the username and password for the Progress database is very
sensitive, how can I hide this information in the registry, so that any
user cannot see the password field?

I'm using the default sysprogress account to access the database. I'd
like to use a less privileged account, but when I create a new user, by
default it has access to all tables and fields.

Thanks,

--SF
3
> I'm using the default sysprogress account to access the database. I'd
> like to use a less privileged account, but when I create a new user, by
> default it has access to all tables and fields.

You can use the SQL GRANT statement to give access to the tables that you
wish. In fact, in the "ODBC Toolkit", I seem to remember that there is a file
that holds the GRANT commands for all of the tables. That should give you a
start.

Mark W.