Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Posts
    5

    Unanswered: Issue with views in sql server 2005 express

    Hello there!

    Hope you are all doing well!
    To get down to my problem, I am using sql server 2005 EXPRESS with classic ASP. When I run a SELECT statement in the SQL server management studio it retrieves correct data from this view in question. But when I run the same query through ASP it doesn't retrieve any kind of data for one nvarchar(MAX) type field although it returns data for other fields.
    But it all works fine when I use sql server 2005.
    Please help. Thanks in advance.

    Best regards,
    Asela
    Last edited by asela; 08-05-09 at 03:27.

  2. #2
    Join Date
    Dec 2008
    Posts
    5
    HI Guys!

    Fixed the problem by changing the underlying data type to "text", but any idea what's wrong with nvarchar(MAX) ?

    Thanks,
    Asela

Posting Permissions

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