RE: [sqr-users] Error: No Accessible Columns

["Nachman Kreitman" <Nachman.Kreitman@corp.idt.net>]

After I connect to the database, I click on an environment.  I hang for
about 5 minutes and then no objects come back.

-----Original Message-----
From: sqr-users-bounces+nachman.kreitman=corp.idt.net@sqrug.org
[mailto:sqr-users-bounces+nachman.kreitman=corp.idt.net@sqrug.org]On
Behalf Of Knapp, Richard
Sent: Thursday, October 21, 2004 11:31 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Error: No Accessible Columns



So, you probably have SQLPlus installed on your desktop, right?  If not,
I recommend it.  It's a great way to do some basic db things like test
connections/access privs, get table structures, create and alter tables,
etc..  If you already have this, try connecting to the same db using the
user and password stored in the dsn file.  Then try to describe (desc)
some of the tables you are having problems with.  If you can see all the
fields, this has to be an SQR Developer 8.1.0 problem.  Is that Brio (I
mean Hyperion) or PS?

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Nachman Kreitman
Sent: Thursday, October 21, 2004 10:20 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Error: No Accessible Columns

I am using Oracle (8.0).  Yesterday a gentleman walked me through
creating a
dsn/vsc file.  When I do it, it does not seem to work.

-----Original Message-----
From: sqr-users-bounces+nachman.kreitman=corp.idt.net@sqrug.org
[mailto:sqr-users-bounces+nachman.kreitman=corp.idt.net@sqrug.org]On
Behalf Of Knapp, Richard
Sent: Thursday, October 21, 2004 10:34 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Error: No Accessible Columns



What is the RDBMS you are querying?  What other query tools do you have?

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Nachman Kreitman
Sent: Thursday, October 21, 2004 9:21 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Error: No Accessible Columns

I am still having problems with Service Request 2-4069085.  I can create
my
connection but no database objects return.  I am not sure if I am using
the
proper driver.  Please assist.

Thank you.


Original Problem (Service Request 2-4069085)
I am new to SQR.  I recently installed SQR Developer 8.1.0.  After I
connected to the database, I am able to see the database objects.  My
problem arises when I select a table or view from the list.  When I
click on
the object, I see very few columns or no columns (this happens most of
the
time).  I get the message "There are no accessible columns".  There are
over
a hundred columns in these tables/views.  How can I obtain the full
database
object's information?  Thank you for your assistance.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users