>We have 2 SQL7 servers. On one server we can drill down and see the tables using the "native" sql7 oledb provider while in Crystal Reports. The other serve allows us only to see the dbo class of objects. i.e. dbproperties table but no tables defined within the database. What am I missing on the second server.
>
>Thanks
Is the owner of the tables dbo? Could be your problem - insufficient security privelages.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown