"ikkyu" wrote:

> Thank you very much for your suggestion
>
> "Jasonymk" wrote:
>
> > Thank you Soooooo much for the suggestions, it works!!
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > You are accessing a SQL Server 7.0 or older, correct? Just install SP1 of RS
> > > 2000 and it will work.
> > >
> > > The workaround for RS 2000 without SP1 is as follows:
> > > Go to the "Data Options" tab of the "Dataset" dialog in report designer. On
> > > the Data Options tab you will see that all settings contain "Auto" (and
> > > report server would therefore try to auto-detect the collation settings from
> > > the database server).
> > > Replace the Auto-settings with the following settings (e.g. if your SQL 7.0
> > > database collation is "SQL_Latin1_General_CP1_CI_AS"):
> > > Collation = Latin1_General
> > > Case sensitivity = false
> > > Kanatype sensitivity = false
> > > Width sensitivity = false
> > > Accent sensitivity = true
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > >
> > > "Jasonymk" <Jasonymk@discussions.microsoft.com> wrote in message
> > > news:C17FA060-49F6-4965-83B3-8EA6D4989714@microsoft.com...
> > > > hi all, my report server is installed in machine 1 , after i made a report
> > > > which the source is from machine 2, the broswer hanged and report the
> > > > following error:
> > > >
> > > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > > Online Help
> > > > Query execution failed for data set '(myDB from machine2)'.
> > > > (rsErrorExecutingCommand) Get Online Help
> > > > 'DATABASEPROPERTYEX' is not a recognized function name.
> > > >
> > > > is it because the version of the sql server didnot support the new
> > > reporting
> > > > service?
> > > > cos my boss said sql server in machine2 does not support reporting service
> > > >
> > > > if no, any method to solve the problem?
> > > >
> > > > Thanks in advance.
> > >
> > >