Error when retrieving varchar colum from SQL Server

[whatupabc]

Hi everyone,

Im' using ReportNet 1.1 with SQL Server 2000. I have an error when retrieving varchar column. Below is detais:
-In SQL Server:
+ Collation SQL_Denish_Pref_CP1_Cl_AS
+ Table structure:
create table TEST (
id int,
NAME varchar(10)
)
+ Store procedure
create procedure testStore(@intID int)
as
select id,NAME
from TEST
where id = @intID
-In ReportNet Framwork Manager:
When using the store procedure above, I got an error: QE-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-9'

If I change the store procedure or table to convert NAME column to nvarchar, there is no error in FM
ex: create procedure testStore(@intID int)
as
select id,cast(NAME as nvarchar(10))
from TEST
where id = @intID
I only have error with collation SQL_Denish_Pref_CP1_Cl_AS. Others is working well. (ie SQL_Latin1_General_CP1_Cl_AS)

Could someone have experience with this and how to let the Framework Manager works well with collation SQL_Denish_Pref_CP1_Cl_AS without changing anything in store procedure or table?

Thanks,
Cong