Only seeing Number fields

I created a view in SQL Server, inserted in the Universe, but when I look at the fields that it brought through it is only showing Numerical fields.

When I right click and choose ‘View Table Values’ I can see all the values - character, date etc. I can’t create objects for the ‘missing’ columns either.

I think it must be something to do with permissions but I don’t know what. I have been amending the sqlsrven.prm file to allow me to use ANSI_92 and outer joins but I can’t see how this has caused the problem.

How do I see all my fields again :confused:

Susan


suz_reid2 (BOB member since 2003-01-20)

What are the other types of fields?

BO cannot handle “n” fields (nchar, nvarchar, etc). It can handle them, it just can’t automatically create objects from them.


Steve Krandel :us: (BOB member since 2002-06-25)

Character columns, date columns. When I try to create an object on one of the missing columns, the list of those available only shows the Number columns.

Susan


suz_reid2 (BOB member since 2003-01-20)

I have another SQLServer database that is showing the nvarchar fields from the database as Long types in the Universe.

The universe against this current database seems to be ignoring all fields except thise of numerical type. Date and Character fields from the tables are ignored completely. It looks like there is some kind of filter on what I can see.

Can anyone shed any light??

Susan


suz_reid2 (BOB member since 2003-01-20)

I just had something like this happen last week. I turned out to be a security issue. When we changed database User IDs on the connection string it worked fine. It appeared that the user id had it’s privileges changed. When we fixed it up, it all worked OK.


Steve Krandel :us: (BOB member since 2002-06-25)