Error Regarding file import through import wizard

Hi all,

when trying to ímport files to our database server from a client, I keep getting an error:

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source_txt" (1).
(SQL Server Import and Export Wizard)

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (175).
(SQL Server Import and Export Wizard)

... doing the same import when logged on the server, hasn't been giving me any errors, how come. I can from my client without trouble import tables from other DB servers but when ever it is files it won't do it.

I tried as mentioned in other threads rerun setup to re-install SSIS, but as it was already installed it wouldn't re-install. My next move would be to make a clean install, but not sure it would help, as I think this is a buck.

best regards

Musa Rusid

I have encountered the same error trying to import flat files created from Excel sheets. What is the solution? Thanks.

Error Regarding file import through import wizard

Hi all,

when trying to ímport files to our database server from a client, I keep getting an error:

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source_txt" (1).
(SQL Server Import and Export Wizard)

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (175).
(SQL Server Import and Export Wizard)

... doing the same import when logged on the server, hasn't been giving me any errors, how come. I can from my client without trouble import tables from other DB servers but when ever it is files it won't do it.

I tried as mentioned in other threads rerun setup to re-install SSIS, but as it was already installed it wouldn't re-install. My next move would be to make a clean install, but not sure it would help, as I think this is a buck.

best regards

Musa Rusid

I have encountered the same error trying to import flat files created from Excel sheets. What is the solution? Thanks.

Error on Install

I'm getting an error when trying to install the SQL Server 2005 Express. After it installs the Native Client & Support file, it goes through a configuration check.

I'm getting this error (complete) ::

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <machine name> Error: 2147746132 (0x80040154)

and then stops.

Suggestions would be great!!!

Check here:

http://support.microsoft.com/default.aspx/kb/201234

Buck Woody

|||

Re-registering WMI

I've been having some issues with WMI on my laptop over the past couple of weeks (the symptoms of which have been strange WMI repository messages, inability to run WMIC or scripts, machine running slower than usual etc.). I didn't really want to have to re-install or repair Windows to fix this. Fortunately I found this very helpful article on resetting and re-registering the WMI services.

This included the following commands to re-register all of the WMI components:

cd /d %windir%\system32\wbem

for %i in (*.dll) do RegSvr32 -s %i

for %i in (*.exe) do %i /RegServer

Published Friday, March 18, 2005 5:19 PM by smguest

I did this, worked for me.

Error on Install

I'm getting an error when trying to install the SQL Server 2005 Express. After it installs the Native Client & Support file, it goes through a configuration check.

I'm getting this error (complete) ::

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <machine name> Error: 2147746132 (0x80040154)

and then stops.

Suggestions would be great!!!

Check here:

http://support.microsoft.com/default.aspx/kb/201234

Buck Woody

|||

Re-registering WMI

I've been having some issues with WMI on my laptop over the past couple of weeks (the symptoms of which have been strange WMI repository messages, inability to run WMIC or scripts, machine running slower than usual etc.). I didn't really want to have to re-install or repair Windows to fix this. Fortunately I found this very helpful article on resetting and re-registering the WMI services.

This included the following commands to re-register all of the WMI components:

cd /d %windir%\system32\wbem

for %i in (*.dll) do RegSvr32 -s %i

for %i in (*.exe) do %i /RegServer

Published Friday, March 18, 2005 5:19 PM by smguest

I did this, worked for me.

sql

ERROR ON CLIENT

Hi I am working with SQL server 2000
all the clients work perfect but in one client I have the following error:
SQL Server OLEDB provider support error
X Unable to load SQL Server OLEDB provider resource DLL. The application
cannot continue
and asking me for OK
after many OK my application starts and works perfect.
Any ideas?
Hi
Have you run the MDAC component checked and made sure that the versions of
MDAC are consistent?
http://www.microsoft.com/downloads/r...splayLang= en
John
"pOWER lINE" wrote:

> Hi I am working with SQL server 2000
> all the clients work perfect but in one client I have the following error:
> SQL Server OLEDB provider support error
> X Unable to load SQL Server OLEDB provider resource DLL. The application
> cannot continue
> and asking me for OK
> after many OK my application starts and works perfect.
> Any ideas?
>
>

ERROR ON CLIENT

Hi I am working with SQL server 2000
all the clients work perfect but in one client I have the following error:
SQL Server OLEDB provider support error
X Unable to load SQL Server OLEDB provider resource DLL. The application
cannot continue
and asking me for OK
after many OK my application starts and works perfect.
Any ideas?Hi
Have you run the MDAC component checked and made sure that the versions of
MDAC are consistent?
http://www.microsoft.com/downloads/...La
ng=en
John
"pOWER lINE" wrote:

> Hi I am working with SQL server 2000
> all the clients work perfect but in one client I have the following error:
> SQL Server OLEDB provider support error
> X Unable to load SQL Server OLEDB provider resource DLL. The application
> cannot continue
> and asking me for OK
> after many OK my application starts and works perfect.
> Any ideas?
>
>

ERROR ON CLIENT

Hi I am working with SQL server 2000
all the clients work perfect but in one client I have the following error:
SQL Server OLEDB provider support error
X Unable to load SQL Server OLEDB provider resource DLL. The application
cannot continue
and asking me for OK
after many OK my application starts and works perfect.
Any ideas?Hi
Have you run the MDAC component checked and made sure that the versions of
MDAC are consistent?
http://www.microsoft.com/downloads/results.aspx?productID=&freetext=mdac&DisplayLang=en
John
"pOWER lINE" wrote:
> Hi I am working with SQL server 2000
> all the clients work perfect but in one client I have the following error:
> SQL Server OLEDB provider support error
> X Unable to load SQL Server OLEDB provider resource DLL. The application
> cannot continue
> and asking me for OK
> after many OK my application starts and works perfect.
> Any ideas?
>
>

error occured trying to render the report

I am getting the following error message when previewing or trying to just
print using the client side activeX printing control after installing sp2
release:
An error occured trying to render the report.
(0x800040005)
? don't have the slightest clue what this could be. I have deleted the
activex installation from the downloaded files directory and tried
reinstalling to no avail. I am running windows server 2003 standard edition.I have the same problem, does anyone have any ideas?
/Magnus
"isamu" wrote:
> I am getting the following error message when previewing or trying to just
> print using the client side activeX printing control after installing sp2
> release:
> An error occured trying to render the report.
> (0x800040005)
> ? don't have the slightest clue what this could be. I have deleted the
> activex installation from the downloaded files directory and tried
> reinstalling to no avail. I am running windows server 2003 standard edition.|||good to hear i'm not the only one, i feel your pain.
bump.
"Magnus" wrote:
> I have the same problem, does anyone have any ideas?
> /Magnus
>
> "isamu" wrote:
> > I am getting the following error message when previewing or trying to just
> > print using the client side activeX printing control after installing sp2
> > release:
> >
> > An error occured trying to render the report.
> > (0x800040005)
> >
> > ? don't have the slightest clue what this could be. I have deleted the
> > activex installation from the downloaded files directory and tried
> > reinstalling to no avail. I am running windows server 2003 standard edition.|||Same problem here too. I get the first page & then the error on the second
page. I also only get the first page when printing & the error at the end.
I have checked my IE explorer settings & verified scripting is turned on.
Anything else to check?
"isamu" <isamu@.discussions.microsoft.com> wrote in message
news:1ECA681E-E40B-4EB7-BB82-DE6609D44651@.microsoft.com...
>I am getting the following error message when previewing or trying to just
> print using the client side activeX printing control after installing sp2
> release:
> An error occured trying to render the report.
> (0x800040005)
> ? don't have the slightest clue what this could be. I have deleted the
> activex installation from the downloaded files directory and tried
> reinstalling to no avail. I am running windows server 2003 standard
> edition.|||This is generally an issue with rendering the report. The
ReportServer<timestamp>.log file should have some information about the
failure.
If that doesn't help there is a way to turn on logging for the print
control. It is a registry setting on the client machine. I don't remember
the key off hand but can post it later if you don't find the issue from
looking at the report server log files.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark" <mis@.ifcfabricsnospam.com> wrote in message
news:%23Tvx52GTFHA.2768@.tk2msftngp13.phx.gbl...
> Same problem here too. I get the first page & then the error on the second
> page. I also only get the first page when printing & the error at the end.
> I have checked my IE explorer settings & verified scripting is turned on.
> Anything else to check?
> "isamu" <isamu@.discussions.microsoft.com> wrote in message
> news:1ECA681E-E40B-4EB7-BB82-DE6609D44651@.microsoft.com...
>>I am getting the following error message when previewing or trying to just
>> print using the client side activeX printing control after installing sp2
>> release:
>> An error occured trying to render the report.
>> (0x800040005)
>> ? don't have the slightest clue what this could be. I have deleted
>> the
>> activex installation from the downloaded files directory and tried
>> reinstalling to no avail. I am running windows server 2003 standard
>> edition.
>|||Here is the log file:
Exporting works without a problem.
Regards,
Mark
aspnet_wp!library!8a0!04/29/2005-08:13:14:: i INFO: Call to GetPermissions:/
aspnet_wp!library!8a0!04/29/2005-08:13:14:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!b40!04/29/2005-08:13:18:: i INFO: Call to
GetPermissions:/Axapta - Accounting Reports
aspnet_wp!library!b40!04/29/2005-08:13:18:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!a04!04/29/2005-08:13:24:: i INFO: Call to
GetPermissions:/Axapta - Accounting Reports/AR Analysis
aspnet_wp!library!a04!04/29/2005-08:13:24:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!a04!04/29/2005-08:13:25:: i INFO: Call to RenderFirst(
'/Axapta - Accounting Reports/AR Analysis' )
aspnet_wp!library!a04!04/29/2005-08:13:27:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!a04!04/29/2005-08:13:27:: i INFO: Processed report.
Report='/Axapta - Accounting Reports/AR Analysis', Stream=''
aspnet_wp!library!a04!04/29/2005-08:13:27:: i INFO: Call to RenderNext(
'/Axapta - Accounting Reports/AR Analysis' )
aspnet_wp!chunks!a04!04/29/2005-08:13:28:: i INFO: ###
GetReportChunk('RenderingInfo_HTML4.0', 2), chunk was not found!
this=5b89a6f0-9173-4be2-9c0f-5fe286779471
aspnet_wp!cache!a04!04/29/2005-08:13:29:: i INFO: Session live: /Axapta -
Accounting Reports/AR Analysis
aspnet_wp!webserver!a04!04/29/2005-08:13:29:: i INFO: Processed report.
Report='/Axapta - Accounting Reports/AR Analysis', Stream=''
aspnet_wp!webserver!a04!04/29/2005-08:13:29:: i INFO: Processed report.
Report='/Axapta - Accounting Reports/AR Analysis',
Stream='e8af5b9a-e473-49d3-9762-6e0036371c3b'
aspnet_wp!library!9f4!04/29/2005-08:13:33:: i INFO: Call to RenderFirst(
'/Axapta - Accounting Reports/AR Analysis' )
aspnet_wp!library!9f4!04/29/2005-08:13:35:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!a04!04/29/2005-08:13:35:: i INFO: Processed report.
Report='/Axapta - Accounting Reports/AR Analysis', Stream=''
aspnet_wp!library!ae0!04/29/2005-08:13:35:: i INFO: Call to RenderNext(
'/Axapta - Accounting Reports/AR Analysis' )
aspnet_wp!cache!ae0!04/29/2005-08:13:35:: i INFO: Item not cacheable: -
PersistStreams /Axapta - Accounting Reports/AR Analysis
aspnet_wp!chunks!ae0!04/29/2005-08:13:35:: i INFO: ###
GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found!
this=c67abfe3-6c6e-4867-97aa-9acf54f33413
aspnet_wp!webserver!a04!04/29/2005-08:13:36:: i INFO: Processed report.
Report='/Axapta - Accounting Reports/AR Analysis', Stream=''
aspnet_wp!library!a04!04/29/2005-08:13:37:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException:
The stream cannot be found. The stream identifier that is provided to an
operation cannot be located in the report server database., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException:
The stream cannot be found. The stream identifier that is provided to an
operation cannot be located in the report server database.
aspnet_wp!webserver!a04!04/29/2005-08:13:37:: e ERROR: Reporting Services
error
Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException:
The stream cannot be found. The stream identifier that is provided to an
operation cannot be located in the report server database.
aspnet_wp!cache!ae0!04/29/2005-08:13:39:: i INFO: Session live: /Axapta -
Accounting Reports/AR Analysis
aspnet_wp!library!8a0!04/29/2005-08:13:53:: i INFO: Call to RenderNext(
'/Axapta - Accounting Reports/AR Analysis' )
aspnet_wp!chunks!8a0!04/29/2005-08:13:54:: i INFO: ###
GetReportChunk('RenderingInfo_PDF', 2), chunk was not found!
this=5b89a6f0-9173-4be2-9c0f-5fe286779471
aspnet_wp!cache!8a0!04/29/2005-08:13:56:: i INFO: Session live: /Axapta -
Accounting Reports/AR Analysis
aspnet_wp!webserver!8a0!04/29/2005-08:13:56:: i INFO: Processed report.
Report='/Axapta - Accounting Reports/AR Analysis', Stream=''
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:uDEZXvHTFHA.3544@.TK2MSFTNGP10.phx.gbl...
> This is generally an issue with rendering the report. The
> ReportServer<timestamp>.log file should have some information about the
> failure.
> If that doesn't help there is a way to turn on logging for the print
> control. It is a registry setting on the client machine. I don't
> remember the key off hand but can post it later if you don't find the
> issue from looking at the report server log files.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Mark" <mis@.ifcfabricsnospam.com> wrote in message
> news:%23Tvx52GTFHA.2768@.tk2msftngp13.phx.gbl...
>> Same problem here too. I get the first page & then the error on the
>> second
>> page. I also only get the first page when printing & the error at the
>> end.
>> I have checked my IE explorer settings & verified scripting is turned on.
>> Anything else to check?
>> "isamu" <isamu@.discussions.microsoft.com> wrote in message
>> news:1ECA681E-E40B-4EB7-BB82-DE6609D44651@.microsoft.com...
>>I am getting the following error message when previewing or trying to
>>just
>> print using the client side activeX printing control after installing
>> sp2
>> release:
>> An error occured trying to render the report.
>> (0x800040005)
>> ? don't have the slightest clue what this could be. I have deleted
>> the
>> activex installation from the downloaded files directory and tried
>> reinstalling to no avail. I am running windows server 2003 standard
>> edition.
>>
>|||I'm getting the same error. Tried to uninstall /reinstall everything, doesn't
help.
Waiting for answer from MSFT. Thanks.
Lianghong
"isamu" wrote:
> good to hear i'm not the only one, i feel your pain.
> bump.
> "Magnus" wrote:
> > I have the same problem, does anyone have any ideas?
> >
> > /Magnus
> >
> >
> > "isamu" wrote:
> >
> > > I am getting the following error message when previewing or trying to just
> > > print using the client side activeX printing control after installing sp2
> > > release:
> > >
> > > An error occured trying to render the report.
> > > (0x800040005)
> > >
> > > ? don't have the slightest clue what this could be. I have deleted the
> > > activex installation from the downloaded files directory and tried
> > > reinstalling to no avail. I am running windows server 2003 standard edition.|||I saw this same error number for the printing control. Note the following:
1.This solution is for script in a web page. I do not think the control is
designed for using from a winform
2. The control needs to have been installed on the client. Your web page
needs to install this or you need to install it some other way. This is an
IIS thing. I am not doing it because I am using Report Manager. So, if you
use Report Manager and print once then it is installed on the client and the
below will work.
3. Look in readme.sp2Readme_EN.htm for information on using the control
4. Remember that Parameters are case sensitive.
&

---

ATL 7.0 test page for object RSClientPrint
function Print()
{
RSClientPrint.Print('http://yourservernamehere/reportserver',
'/DirectoryNameHere/ReportnameHere&ParameterNameHere=ParameterValueHere',
'ReportNameHere');
}
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lianghong" <Lianghong@.discussions.microsoft.com> wrote in message
news:A2069513-3ED0-400F-BDBC-24C6C8EAAD1E@.microsoft.com...
> I'm getting the same error. Tried to uninstall /reinstall everything,
doesn't
> help.
> Waiting for answer from MSFT. Thanks.
> Lianghong
> "isamu" wrote:
> > good to hear i'm not the only one, i feel your pain.
> >
> > bump.
> >
> > "Magnus" wrote:
> >
> > > I have the same problem, does anyone have any ideas?
> > >
> > > /Magnus
> > >
> > >
> > > "isamu" wrote:
> > >
> > > > I am getting the following error message when previewing or trying
to just
> > > > print using the client side activeX printing control after
installing sp2
> > > > release:
> > > >
> > > > An error occured trying to render the report.
> > > > (0x800040005)
> > > >
> > > > ? don't have the slightest clue what this could be. I have
deleted the
> > > > activex installation from the downloaded files directory and tried
> > > > reinstalling to no avail. I am running windows server 2003 standard
edition.|||I solved my problem, I had a hidden list that I removed, after that the
report Worked.
/Magnus
"Mark" wrote:
> Here is the log file:
> Exporting works without a problem.
> Regards,
> Mark
> aspnet_wp!library!8a0!04/29/2005-08:13:14:: i INFO: Call to GetPermissions:/
> aspnet_wp!library!8a0!04/29/2005-08:13:14:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!b40!04/29/2005-08:13:18:: i INFO: Call to
> GetPermissions:/Axapta - Accounting Reports
> aspnet_wp!library!b40!04/29/2005-08:13:18:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!a04!04/29/2005-08:13:24:: i INFO: Call to
> GetPermissions:/Axapta - Accounting Reports/AR Analysis
> aspnet_wp!library!a04!04/29/2005-08:13:24:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!a04!04/29/2005-08:13:25:: i INFO: Call to RenderFirst(
> '/Axapta - Accounting Reports/AR Analysis' )
> aspnet_wp!library!a04!04/29/2005-08:13:27:: i INFO: Initializing
> EnableExecutionLogging to 'True' as specified in Server system properties.
> aspnet_wp!webserver!a04!04/29/2005-08:13:27:: i INFO: Processed report.
> Report='/Axapta - Accounting Reports/AR Analysis', Stream=''
> aspnet_wp!library!a04!04/29/2005-08:13:27:: i INFO: Call to RenderNext(
> '/Axapta - Accounting Reports/AR Analysis' )
> aspnet_wp!chunks!a04!04/29/2005-08:13:28:: i INFO: ###
> GetReportChunk('RenderingInfo_HTML4.0', 2), chunk was not found!
> this=5b89a6f0-9173-4be2-9c0f-5fe286779471
> aspnet_wp!cache!a04!04/29/2005-08:13:29:: i INFO: Session live: /Axapta -
> Accounting Reports/AR Analysis
> aspnet_wp!webserver!a04!04/29/2005-08:13:29:: i INFO: Processed report.
> Report='/Axapta - Accounting Reports/AR Analysis', Stream=''
> aspnet_wp!webserver!a04!04/29/2005-08:13:29:: i INFO: Processed report.
> Report='/Axapta - Accounting Reports/AR Analysis',
> Stream='e8af5b9a-e473-49d3-9762-6e0036371c3b'
> aspnet_wp!library!9f4!04/29/2005-08:13:33:: i INFO: Call to RenderFirst(
> '/Axapta - Accounting Reports/AR Analysis' )
> aspnet_wp!library!9f4!04/29/2005-08:13:35:: i INFO: Initializing
> EnableExecutionLogging to 'True' as specified in Server system properties.
> aspnet_wp!webserver!a04!04/29/2005-08:13:35:: i INFO: Processed report.
> Report='/Axapta - Accounting Reports/AR Analysis', Stream=''
> aspnet_wp!library!ae0!04/29/2005-08:13:35:: i INFO: Call to RenderNext(
> '/Axapta - Accounting Reports/AR Analysis' )
> aspnet_wp!cache!ae0!04/29/2005-08:13:35:: i INFO: Item not cacheable: -
> PersistStreams /Axapta - Accounting Reports/AR Analysis
> aspnet_wp!chunks!ae0!04/29/2005-08:13:35:: i INFO: ###
> GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found!
> this=c67abfe3-6c6e-4867-97aa-9acf54f33413
> aspnet_wp!webserver!a04!04/29/2005-08:13:36:: i INFO: Processed report.
> Report='/Axapta - Accounting Reports/AR Analysis', Stream=''
> aspnet_wp!library!a04!04/29/2005-08:13:37:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException:
> The stream cannot be found. The stream identifier that is provided to an
> operation cannot be located in the report server database., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException:
> The stream cannot be found. The stream identifier that is provided to an
> operation cannot be located in the report server database.
> aspnet_wp!webserver!a04!04/29/2005-08:13:37:: e ERROR: Reporting Services
> error
> Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException:
> The stream cannot be found. The stream identifier that is provided to an
> operation cannot be located in the report server database.
> aspnet_wp!cache!ae0!04/29/2005-08:13:39:: i INFO: Session live: /Axapta -
> Accounting Reports/AR Analysis
> aspnet_wp!library!8a0!04/29/2005-08:13:53:: i INFO: Call to RenderNext(
> '/Axapta - Accounting Reports/AR Analysis' )
> aspnet_wp!chunks!8a0!04/29/2005-08:13:54:: i INFO: ###
> GetReportChunk('RenderingInfo_PDF', 2), chunk was not found!
> this=5b89a6f0-9173-4be2-9c0f-5fe286779471
> aspnet_wp!cache!8a0!04/29/2005-08:13:56:: i INFO: Session live: /Axapta -
> Accounting Reports/AR Analysis
> aspnet_wp!webserver!8a0!04/29/2005-08:13:56:: i INFO: Processed report.
> Report='/Axapta - Accounting Reports/AR Analysis', Stream=''
> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> news:uDEZXvHTFHA.3544@.TK2MSFTNGP10.phx.gbl...
> > This is generally an issue with rendering the report. The
> > ReportServer<timestamp>.log file should have some information about the
> > failure.
> >
> > If that doesn't help there is a way to turn on logging for the print
> > control. It is a registry setting on the client machine. I don't
> > remember the key off hand but can post it later if you don't find the
> > issue from looking at the report server log files.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "Mark" <mis@.ifcfabricsnospam.com> wrote in message
> > news:%23Tvx52GTFHA.2768@.tk2msftngp13.phx.gbl...
> >> Same problem here too. I get the first page & then the error on the
> >> second
> >> page. I also only get the first page when printing & the error at the
> >> end.
> >>
> >> I have checked my IE explorer settings & verified scripting is turned on.
> >>
> >> Anything else to check?
> >>
> >> "isamu" <isamu@.discussions.microsoft.com> wrote in message
> >> news:1ECA681E-E40B-4EB7-BB82-DE6609D44651@.microsoft.com...
> >>I am getting the following error message when previewing or trying to
> >>just
> >> print using the client side activeX printing control after installing
> >> sp2
> >> release:
> >>
> >> An error occured trying to render the report.
> >> (0x800040005)
> >>
> >> ? don't have the slightest clue what this could be. I have deleted
> >> the
> >> activex installation from the downloaded files directory and tried
> >> reinstalling to no avail. I am running windows server 2003 standard
> >> edition.
> >>
> >>
> >
> >
>
>|||Thanks for your quick reply.
I got this error when I trying to print/preview report from the
ReportManager. I've just installed SP2 to my other machine (second) and the
print/preview button works fine for it. The difference for these two machines
is that the first machine installed SP2 beta before. But I uninstalled RS on
both machines and reinstalled both. Another thing I've noticed is that after
the installation, the RSExecRole was not checked for the ASPNET account on
the first machine but it is checked on the second machine.
Anything else I need to check?
Thanks,
Lianghong
"Bruce L-C [MVP]" wrote:
> I saw this same error number for the printing control. Note the following:
> 1.This solution is for script in a web page. I do not think the control is
> designed for using from a winform
> 2. The control needs to have been installed on the client. Your web page
> needs to install this or you need to install it some other way. This is an
> IIS thing. I am not doing it because I am using Report Manager. So, if you
> use Report Manager and print once then it is installed on the client and the
> below will work.
> 3. Look in readme.sp2Readme_EN.htm for information on using the control
> 4. Remember that Parameters are case sensitive.
>
> &

---

>
> ATL 7.0 test page for object RSClientPrint
>
>
>
> CLASSID="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3">
>
> function Print()
> {
> RSClientPrint.Print('http://yourservernamehere/reportserver',
> '/DirectoryNameHere/ReportnameHere&ParameterNameHere=ParameterValueHere',
> 'ReportNameHere');
> }
>
>
>
>
>

---

>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lianghong" <Lianghong@.discussions.microsoft.com> wrote in message
> news:A2069513-3ED0-400F-BDBC-24C6C8EAAD1E@.microsoft.com...
> > I'm getting the same error. Tried to uninstall /reinstall everything,
> doesn't
> > help.
> > Waiting for answer from MSFT. Thanks.
> >
> > Lianghong
> >
> > "isamu" wrote:
> >
> > > good to hear i'm not the only one, i feel your pain.
> > >
> > > bump.
> > >
> > > "Magnus" wrote:
> > >
> > > > I have the same problem, does anyone have any ideas?
> > > >
> > > > /Magnus
> > > >
> > > >
> > > > "isamu" wrote:
> > > >
> > > > > I am getting the following error message when previewing or trying
> to just
> > > > > print using the client side activeX printing control after
> installing sp2
> > > > > release:
> > > > >
> > > > > An error occured trying to render the report.
> > > > > (0x800040005)
> > > > >
> > > > > ? don't have the slightest clue what this could be. I have
> deleted the
> > > > > activex installation from the downloaded files directory and tried
> > > > > reinstalling to no avail. I am running windows server 2003 standard
> edition.
>
>|||I checked the security on the database & the RSexec role is checked.
It still does not print or print preview past the first page.
I am using standard report manager with the sample reports.
The report manager is set to an Intranet site with the LOW security setting
in IE.
Another odd item is the page counter on the preview will keep going up in
pages even if the report on has 1 page.
Anything else to check?
Regards,
MB
"Lianghong" <Lianghong@.discussions.microsoft.com> wrote in message
news:2AA1C4EF-D7A0-4796-A86A-07E5B65C5A14@.microsoft.com...
> Thanks for your quick reply.
> I got this error when I trying to print/preview report from the
> ReportManager. I've just installed SP2 to my other machine (second) and
> the
> print/preview button works fine for it. The difference for these two
> machines
> is that the first machine installed SP2 beta before. But I uninstalled RS
> on
> both machines and reinstalled both. Another thing I've noticed is that
> after
> the installation, the RSExecRole was not checked for the ASPNET account on
> the first machine but it is checked on the second machine.
> Anything else I need to check?
> Thanks,
> Lianghong
> "Bruce L-C [MVP]" wrote:
>> I saw this same error number for the printing control. Note the
>> following:
>> 1.This solution is for script in a web page. I do not think the control
>> is
>> designed for using from a winform
>> 2. The control needs to have been installed on the client. Your web page
>> needs to install this or you need to install it some other way. This is
>> an
>> IIS thing. I am not doing it because I am using Report Manager. So, if
>> you
>> use Report Manager and print once then it is installed on the client and
>> the
>> below will work.
>> 3. Look in readme.sp2Readme_EN.htm for information on using the control
>> 4. Remember that Parameters are case sensitive.
>>
>> &

---

>>
>> ATL 7.0 test page for object RSClientPrint
>>
>>
>>
>> > CLASSID="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3">
>>
>> function Print()
>> {
>> RSClientPrint.Print('http://yourservernamehere/reportserver',
>> '/DirectoryNameHere/ReportnameHere&ParameterNameHere=ParameterValueHere',
>> 'ReportNameHere');
>> }
>>
>>
>>
>>
>>

---

>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Lianghong" <Lianghong@.discussions.microsoft.com> wrote in message
>> news:A2069513-3ED0-400F-BDBC-24C6C8EAAD1E@.microsoft.com...
>> > I'm getting the same error. Tried to uninstall /reinstall everything,
>> doesn't
>> > help.
>> > Waiting for answer from MSFT. Thanks.
>> >
>> > Lianghong
>> >
>> > "isamu" wrote:
>> >
>> > > good to hear i'm not the only one, i feel your pain.
>> > >
>> > > bump.
>> > >
>> > > "Magnus" wrote:
>> > >
>> > > > I have the same problem, does anyone have any ideas?
>> > > >
>> > > > /Magnus
>> > > >
>> > > >
>> > > > "isamu" wrote:
>> > > >
>> > > > > I am getting the following error message when previewing or
>> > > > > trying
>> to just
>> > > > > print using the client side activeX printing control after
>> installing sp2
>> > > > > release:
>> > > > >
>> > > > > An error occured trying to render the report.
>> > > > > (0x800040005)
>> > > > >
>> > > > > ? don't have the slightest clue what this could be. I have
>> deleted the
>> > > > > activex installation from the downloaded files directory and
>> > > > > tried
>> > > > > reinstalling to no avail. I am running windows server 2003
>> > > > > standard
>> edition.
>>|||Bruce,
Why are not you answering the question. I am waiting for almost 1 year now. i will talk to Bill Gates about it
From http://www.developmentnow.com/g/115_2005_4_0_0_510966/error-occured-trying-to-render-the-report.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Error modifying maintenance plans

Using my client (Microsoft SQL Server Management Studio), I am unable to
open/modify maintenance plans. Something is wrong with my client as I'm able
to open them from the server. I've uninstalled Sql2000 client as well.
I installed the Sql2005 client components, SP1 and the DTS 2000 components.
The error states: "Value cannot be null. Parameter name: component
(Sytem.Design)"
also - Microsoft SQL Server Management Studio is unable to load this document.
Has anyone experienced this or know of a solution?
Thanks.
Ron
Ron,
I am having an identical issue. I can modify plans when running Management Studio on the server,
but not from my client computer. I have 2005 Developer Edition on my computer, and I am able to
create and modify plans on my local SQL Server instance without a problem. As my computer is new,
I have never had any SQL Server 2000 components installed.
Any luck finding a solution to this one?
Joe|||No nothing yet. I'm guessing it's something not clearing out in the registry
or since I thought I was the only one, that it might have been my laptop.
Since I have a workaround (go to the server), I haven't been in a rush for a
solution.
"jkiefer580" wrote:

> Ron,
> I am having an identical issue. I can modify plans when running
> Management Studio on the server,
> but not from my client computer. I have 2005 Developer Edition on my
> computer, and I am able to
> create and modify plans on my local SQL Server instance without a
> problem. As my computer is new,
> I have never had any SQL Server 2000 components installed.
> Any luck finding a solution to this one?
> Joe
>
> --
> jkiefer580
>

Error messages in Client

Hi
I am running a software package that access SQL Server files. I am getting
these messages:
* "Invalid pointer operation"
* "The RPC server is unavailable"
* "Access violation at address 40006834 in module 'rtl60.bpl'. Read of
address FFFFFFFF" when deleting an event
* "Access violation at address 40006834 in module 'rtl60.bpl'.
Anyone know what may cause these
Thanks
c
I would ask the vendor of the software package as these sound like
application errors, not SQL Server errors.
Andrew J. Kelly SQL MVP
"cds" <cdsaus2001@.yahoo.com.au> wrote in message
news:42be882f$0$14822$afc38c87@.news.optusnet.com.a u...
> Hi
> I am running a software package that access SQL Server files. I am getting
> these messages:
> * "Invalid pointer operation"
> * "The RPC server is unavailable"
> * "Access violation at address 40006834 in module 'rtl60.bpl'. Read of
> address FFFFFFFF" when deleting an event
> * "Access violation at address 40006834 in module 'rtl60.bpl'.
>
> Anyone know what may cause these
>
> Thanks
> c
>

error message?

I'm catching a primary constraint error in SQL and don't want to return the SQL error message back to the client. Is there any way to stop this. ThankyouCan you define "client" for me? Is the originator of the whole activity or the bit of code that's talking to SQL?|||Its returning the sql error message back to .net page, sorry!|||Do you have a data component or is the page talking to the Db directly?|||directly|||I figured it out thanks anyway!