Software

Ask something
Discussion Locked

Oracle and Crystal 10 user access.????

0 helpful
3 replies

by brentc76

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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!!

3 replies

by sgt_shultz

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

by sgt_shultz

from How to Create a System ODBC Connection... from support.microsoft.com
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

Troubleshooting
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.

by brentc76

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

This discussion is closed to new replies.