Hi, I'm accessing the database in VB .net 2002/crystal 9, but it won't let me open a rowset. The crystal report can open the data, I can see the tables in visual studio, can query the tables in sqlnet against the oracle db, it only fails when I run the vb app calling the crystal report.
All other tests work (can open an Access db and other Oracle db using same scenario of crystal 9 in vb .net 2002).
The db has ownership using login "A", and I can read "A" tables, the tables I now need are with ownership "B" within same db (can see them in v studio, just can't read at runtime); all networking and db people advise it "must be visual studio". Seem to me it's a permissions issue. Has anyone else experienced something similar? If so, how can this be corrected to work?
All other tests work (can open an Access db and other Oracle db using same scenario of crystal 9 in vb .net 2002).
The db has ownership using login "A", and I can read "A" tables, the tables I now need are with ownership "B" within same db (can see them in v studio, just can't read at runtime); all networking and db people advise it "must be visual studio". Seem to me it's a permissions issue. Has anyone else experienced something similar? If so, how can this be corrected to work?