General discussion


Oracle and Crystal 10 user access.????

By brentc76 ·
To Whom may provide any help.... I have installed Crystal Reports 10 Advanced Developer and Oracle Runtime on a users computer. He is an avid user of a system called Datastream. When he goes into Crystal Reports to create a new connection, the option "ORACLE SERVER" is not in his list of options. BUT, if I make him an Admin on the PC he can access the "ORACLE SERVER". I have made sure he is a poser user on the PC, as well as the folders that I am aware of for Crystal, that he has full permission on those. I have created the ODBC Connection with my Admin rights, and then with his "Temp" Admin rights. Again, when I take his Admin rights away, he cannot access the "ORACLE SERVER" selection under create new connection. Anyone have ideas? I am stuck.. I tried to contact Crystal, but they cannot provide support(cuz out company will not buy support) BLAH BLAH BLAH!!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to Oracle and Crystal 10 use ...

make sure you make a System odbc connection. otherwise it won't be available to other users.

Collapse -

by sgt_shultz In reply to

<snipped> from How to Create a System ODBC Connection... from
Create a System DSN in Windows XP
1. Click Start, point to Control Panel, double-click Administrative Tools, and then double-click Data Sources(ODBC).
2. Click the System DSN tab, and then click Add.
3. Click the database driver that corresponds with the database type to which you are connecting, and then click Finish.
4. Type the data source name. Make sure that you choose a name that you can remember. You will need to use this name later.
5. Click Select.
6. Click the correct database, and then click OK.
7. Click OK, and then click OK.

Back to the top

Make sure that you create a system DSN. ActiveX Data Objects (ADO) does not recognize user (or local) DSNs. Because they store settings in the registry, system DSNs offer slightly faster performance than file DSNs, which store connection parameters in a file on your hard disk.

Collapse -

by brentc76 In reply to

I have done this and even with the ODBC set up, the user still cannot access the part of the database connection he needs.

Related Discussions

Related Forums