Data doesn't display on my ASP page

[nbozic]

Hi,

I asked the same question on another forum without any success...

I'm importing an Access database to SQL Server 2000.
The issue I ran into is pretty frustrating... All Memo fields that get copied over (as Text fields) appear to be fine and visible in SQL Server Enterprise Manager... except when I display them on the web via ASP - everything is blank (no content at all).

I didn't have that problem with Access, so I ruled out the possibility that there's something wrong with the original data.

Is this some sort of an encoding problem that arose during database import and now doesn't display properly on my ASP page?
I would appreciate any pointers.

Thanks.

[mattglet]

If I remember correctly, you might need to change your CursorType when opening your recordset.

[devguru.com...]

Try changing it to adOpenDynamic and see if that works.

[nbozic]

Good idea, I'll give it a try.

Thanks for your help.