Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    16

    Unanswered: Data not showing for some users

    Hi there,

    Some users, when they select a table and try to "Return all rows" in Enterprise Manager, they get the word Binary instead of the data that should be there. The table has 4 columns, an ID column and three data columns. The ID field data is correct but the data in the other columns just show the word 'Binary'.

    I got the user to connect to the database using the 'sa' login and the problem is still there. I can connect from my machine and see the data fine. Only one user is experiencing these problems.

    The problem occurs with all the tables in the database. Any field that should have text data, e.g. nchar, nvarchar, etc., is showing 'Binary'. Fields that have numeric or date types show fine.

    If the users runs a select query from Query Analyser, then the data appears fine.

    Any help??

  2. #2
    Join Date
    Jul 2003
    Posts
    16

    Re: Data not showing for some users

    This problem seems to have occured since i tried to install a SQLBase odbc driver. The data in the database is fine but Enterprise Manager seems to be corrupted.

    Any help??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •