Re: crystal reports dll and oracle

i did publish this question on a delphi newsgroup but it looks like a dead newsgroup.

the version i wrote: 9i
the connection string is: PROVIDER=ORAOLEDB.ORACLE;;DATA SOURCE=DT_SRC;;USER ID=USER_NAME;;PASSWORD=BLAH;;LOCALE IDENTIFIER=1037;;OLE DB SERVICES=-5] if USER_NAME as DBA rights, it goes to the first DBA user schema (alphabetically) which has the certain table and takes the data from there.
if USER_NAME is not a DBA then everything is ok.

amos_at_cvidya.com (amos) wrote in message news:<39801319.0410180020.3757de54_at_posting.google.com>...
> DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1098065020.441618_at_yasure>...
> > amos wrote:
> >
> > > hi
> > >
> > > i have installed crystal reports and im using its activex import in
> > > delphi in order to create a report.
> > >
> > > i have a connectionstring which connects to a certain database with a
> > > certain user_id.
> > >
> > > the problem is as follow:
> > > 1) if the user has no dba rights, everything is ok.
> > > 2) if the user has DBA rights, the data comes from the first user's
> > > schema (alphabetically ordered) which is a DBA and has the table from
> > > which we do the "select".
> > >
> > > i have never seen such a behavior and have no explanation how this can
> > > be.
> > >
> > > anyone has ideas?
> > >
> > > thanks
> >
> > What does this have to do with Oracle?
> > And if it does ... what version?
> >
> > You should be asking this question at Business Objects Crystal Tech Support.
>
> the answer is easy, as i said the problem occurs in oracle (9i) and in
> sqlserver for example, it doesnt happen. i thought mayb someone else
> has encountered this problem as well.
Received on Tue Oct 19 2004 - 08:26:19 CDT