Missing "Organisation Unit" Table

Hi,

I'm trying to perform a msquery using the latest odbc for all OU's that have 
zen applications associated against them. I cannot see a table called
"OU" 
or "Organisation Unit". Does this table exist or is it mixed into some
super 
class.

Regards

Hudson 

Hi

Yes, it's there as Organizational Unit.

Thank you
Susan 

Hi Susan

Looks like the netware client 4.91 SP2 is causing this issue and some other 
issues with the ODBC connector. 4.90 sp1 works fine. Would you be able to 
replicate this and see if you have the same results. XP Service Pack 2 by 
the way.

Thanks


"Susan Perrin" <devsup@novell.comSusanPerrin> wrote in message 
news:1Pqbg.47$Mr.1@prv-forum2.provo.novell.com...
> Hi
>
> Yes, it's there as Organizational Unit.
>
> Thank you
> Susan
> 

Hi

I am using Novell Client for Windows 4.91 SP2 4.91.2.20051209.  I'm on XP 
with SP2 and all updates as far as I know.

I don't have MS Query but I think I can get it.  What I did was go to the 
data source administrator and configure a user defined table for 
organizational unit.  And I ran the following vbscript:

Set Connection = CreateObject("ADODB.Connection")

Connection.Open "Default NDS Database"

SQLStmt = "SELECT  ou from ""organizational
unit"""

Set RS = Connection.Execute(SQLStmt)
Do While Not RS.EOF
 wscript.echo RS.fields("ou") RS.MoveNext
Loop
Connection.close
set Connection = Nothing

So since I'm not seeing a problem, please tell me exactly what you are doing 
with MS Query, and how I can reproduce the problem, and what the error is 
that you are seeing.  Also, do you see the organizational unit table listed 
in the database administrator/configure/user defined tables setup?

Thanks
Susan 

Also, I forgot to mention, Zen introduces a lot of aux classes, all of which 
must be applied to the objects because there's no explicit association. 
When it happens that the eDir tree contains a lot of aux classes, some 
tables are not found (usually at the bottom of an alphebetized list). 
Please try setting up a user defined table with the attributes you want, and 
query against the user defined table to see if that corrects the problem.

Thank you
Susan