I have a two nodes cluster (sql2000 on Windows 2003) with 16 instances
(sql hotel) . I have two subnets on them, one GB net and one 100
Mb(for old moved databases where the aplication is not able to change
subnet).

If I use QA i can get all the reslut that i need but if i use a dsn in
an aplication or ASP page i will not be able to see all the tables in
the database. Is there anyone who know anything about this? If i
change to a real conectionstring on the ASP page i will have all the
result i wanted. (IIS runing on other machine on windows 2000)

We have found the problem with MSDTC not enabled to other server by
deafult and was thinking that this might be the same thing. Maybe we
need to enable soemthing that we are not aware of to make this work.

How come that the dsn conection not shows all the user tables (They
are all owned by DBO and the user is DBOwner)? It would be easier to
understand if i did not get connected at all but i do get a conection
but not all the tables.