rsClientPrint Active X question

After loading the object clause for rsClientPrint on my ASPX page, I get the
message at the client that Microsoft is blocking the software because the
publisher is unknown. Can anyone tell me what I might need to do to get past
that.
--
Thanks,
CGWFound my problem.
--
Thanks,
CGW
"CGW" wrote:
> After loading the object clause for rsClientPrint on my ASPX page, I get the
> message at the client that Microsoft is blocking the software because the
> publisher is unknown. Can anyone tell me what I might need to do to get past
> that.
> --
> Thanks,
> CGW|||Hi, how did you fix your problem? I have the same problem, that is
preventing me from using a program download (from american greetings.com)
that I've been using all along. I need a new Active-X plugin, but the
publisher is unverifiable. Thanks much!
Mary
"CGW" wrote:
> Found my problem.
> --
> Thanks,
> CGW
>
> "CGW" wrote:
> > After loading the object clause for rsClientPrint on my ASPX page, I get the
> > message at the client that Microsoft is blocking the software because the
> > publisher is unknown. Can anyone tell me what I might need to do to get past
> > that.
> > --
> > Thanks,
> >
> > CGW|||I wish I could remember. We ended up taking a different approach and I didn't
keep my work on that. I know I googled around for an answer and it seems that
it had to do with getting the cab file in the right location. Sorry. If I
remember, I'll send it to you. And from now on, when I find a solution, I'll
mention what it was while it's still fresh on my mind.
--
Thanks,
CGW
"Mary" wrote:
> Hi, how did you fix your problem? I have the same problem, that is
> preventing me from using a program download (from american greetings.com)
> that I've been using all along. I need a new Active-X plugin, but the
> publisher is unverifiable. Thanks much!
> Mary
> "CGW" wrote:
> > Found my problem.
> > --
> > Thanks,
> >
> > CGW
> >
> >
> > "CGW" wrote:
> >
> > > After loading the object clause for rsClientPrint on my ASPX page, I get the
> > > message at the client that Microsoft is blocking the software because the
> > > publisher is unknown. Can anyone tell me what I might need to do to get past
> > > that.
> > > --
> > > Thanks,
> > >
> > > CGW

rs.MoveNext triggers "Operation is not allowed when the object is closed"

Wait, please don't ignore this one ... I've already tried all the obvious stuff.

I am currently on a contract assignment, and so cannot post the exact code (at least not at this time), but I should be able to layout the problem enough anyway.

I have a section of code that hits a remote database (same network, same subnet, but different city than the primary SQL database) to retrieve information logged by a digital phone system for display on an intranet screen.

The code is your typical recordset iteration, and looks basically like this.

Note: the connection is created and opened inside the PhoneCenter class. SQL statement used has been verified correct in SQL Server Management Studio.

<snip>

....

Dim rs as adodb.recordset = objPhoneCenter.Conn.execute(SQL)

If rs.recordcount > 0 then

while not rs.eof

.... Data processed here

rs.MoveNext

end while

end if

....

</snip>

This code runs flawlessly, every time, on the development platform but fails at "rs.MoveNext" when pushed out to the production server. What mystifies me is that the "Operation is not allowed when the object is closed" should not occur on code inside an rs.eof test, since the recordset must be open and have data in order to enter such a block.

This is, however, exactly what is happening. In 7 years working with SQL Server and ADO, I've never seen anything quite like this. Does anyone have any insight into what might be going on here?

P.S. I am in the process of attempting to gather more detailed information about this error, which I will post as it arrives if needed. At the moment, the above message is all I have to go on.

This is a wild guess since the information is not sufficient, but could you try specifying the cursor location like
objPhoneCenter.Conn = ADODB.CursorLocationEnum.adUseClient

and see if there are any changes in behavior?|||

Ok, I didn't provide much info, I'll grant that. The connection is already using the above cursor. What other information would you like to see to make a more educated guess?

The current connection is defined by the following lines of code:

objPhoneCenter = New ADODB.Connection

objPhoneCenter.CursorLocation = ADODB.CursorLocationEnum.adUseClient

objPhoneCenter.Open("Provider=SQLOLEDB.1;Persist Security Info=True;Password=" & password & ";" & _

"User ID=" & username & ";Data Source=" & servername & ";" & _

"Network Library=dbmssocn;Initial Catalog=" & database & ";")

objPhoneCenter.IsolationLevel = ADODB.IsolationLevelEnum.adXactReadUncommitted

objPhoneCenter.CommandTimeout = 300

Servername is the actual machine name, not an IP address, and is resolved by an internal DNS server.

Does this help any?

rs.MoveNext triggers "Operation is not allowed when the object is closed"

Wait, please don't ignore this one ... I've already tried all the obvious stuff.

I am currently on a contract assignment, and so cannot post the exact code (at least not at this time), but I should be able to layout the problem enough anyway.

I have a section of code that hits a remote database (same network, same subnet, but different city than the primary SQL database) to retrieve information logged by a digital phone system for display on an intranet screen.

The code is your typical recordset iteration, and looks basically like this.

Note: the connection is created and opened inside the PhoneCenter class. SQL statement used has been verified correct in SQL Server Management Studio.

<snip>

....

Dim rs as adodb.recordset = objPhoneCenter.Conn.execute(SQL)

If rs.recordcount > 0 then

while not rs.eof

.... Data processed here

rs.MoveNext

end while

end if

....

</snip>

This code runs flawlessly, every time, on the development platform but fails at "rs.MoveNext" when pushed out to the production server. What mystifies me is that the "Operation is not allowed when the object is closed" should not occur on code inside an rs.eof test, since the recordset must be open and have data in order to enter such a block.

This is, however, exactly what is happening. In 7 years working with SQL Server and ADO, I've never seen anything quite like this. Does anyone have any insight into what might be going on here?

P.S. I am in the process of attempting to gather more detailed information about this error, which I will post as it arrives if needed. At the moment, the above message is all I have to go on.

This is a wild guess since the information is not sufficient, but could you try specifying the cursor location like
objPhoneCenter.Conn = ADODB.CursorLocationEnum.adUseClient

and see if there are any changes in behavior?|||

Ok, I didn't provide much info, I'll grant that. The connection is already using the above cursor. What other information would you like to see to make a more educated guess?

The current connection is defined by the following lines of code:

objPhoneCenter = New ADODB.Connection

objPhoneCenter.CursorLocation = ADODB.CursorLocationEnum.adUseClient

objPhoneCenter.Open("Provider=SQLOLEDB.1;Persist Security Info=True;Password=" & password & ";" & _

"User ID=" & username & ";Data Source=" & servername & ";" & _

"Network Library=dbmssocn;Initial Catalog=" & database & ";")

objPhoneCenter.IsolationLevel = ADODB.IsolationLevelEnum.adXactReadUncommitted

objPhoneCenter.CommandTimeout = 300

Servername is the actual machine name, not an IP address, and is resolved by an internal DNS server.

Does this help any?

RS Web Service to programmatically render reports

Hello, when I call the render method of a ReportService() object with the
following...
data = rs.Render("/OnlineInvoice", "PDF", Nothing, Nothing, paramaters,
Nothing, Nothing, encoding, mimeType, parametersUsed, warnings, streamIds)
with the argument paramaters being...
Dim paramaters(2) As ParameterValue
paramaters(0) = New ParameterValue
paramaters(0).Name = "P_ClientID"
paramaters(0).Value = 815
paramaters(1) = New ParameterValue
paramaters(1).Name = "P_InvoiceID"
paramaters(1).Value = 22230
I get the error...
System.Web.Services.Protocols.SoapException: The value of parameter
'Parameters' is not valid. Check the documentation for information about
valid values. --> The value of parameter 'Parameters' is not valid.
Any Ideas? thank you for the help!
--See if you need to use 1 instead of 2 in array declaration:
Dim paramaters(1) As ParameterValue
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:edWp1rjoEHA.1712@.tk2msftngp13.phx.gbl...
> Hello, when I call the render method of a ReportService() object with the
> following...
> data = rs.Render("/OnlineInvoice", "PDF", Nothing, Nothing, paramaters,
> Nothing, Nothing, encoding, mimeType, parametersUsed, warnings, streamIds)
> with the argument paramaters being...
> Dim paramaters(2) As ParameterValue
> paramaters(0) = New ParameterValue
> paramaters(0).Name = "P_ClientID"
> paramaters(0).Value = 815
> paramaters(1) = New ParameterValue
> paramaters(1).Name = "P_InvoiceID"
> paramaters(1).Value = 22230
> I get the error...
> System.Web.Services.Protocols.SoapException: The value of parameter
> 'Parameters' is not valid. Check the documentation for information about
> valid values. --> The value of parameter 'Parameters' is not valid.
> Any Ideas? thank you for the help!
>
>
> --
>
>

RS 2005: Use a Custom Class as DataSource?

Hi,
Is it possible to use a Custom Class/Object as a DataSource/DataSet for a
report?
I have now for instance my object MyCompany, and it woudl be nice to just
use a MyCompany-instance as the DataSource...
Any hints/help woudl be really appreciated,
Thanks a lot in advance,
PieterI thought that the objectDatasource control was only used by ASP.NET
applications.
A SSRS report is not an ASP.NET application unless you use the new
reportViewer component and there you can use an ObjectDataSource
Med bouchenafa
"Pieter" <pietercoucke@.hotmail.com> a écrit dans le message de news:
%23w1cPSlIGHA.668@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Is it possible to use a Custom Class/Object as a DataSource/DataSet for a
> report?
> I have now for instance my object MyCompany, and it woudl be nice to just
> use a MyCompany-instance as the DataSource...
> Any hints/help woudl be really appreciated,
> Thanks a lot in advance,
> Pieter
>|||Hi,
You can bind windows applications to objects also.
Ken
--
"Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
news:OhXZe$lIGHA.2896@.TK2MSFTNGP09.phx.gbl...
>I thought that the objectDatasource control was only used by ASP.NET
>applications.
> A SSRS report is not an ASP.NET application unless you use the new
> reportViewer component and there you can use an ObjectDataSource
> Med bouchenafa
> "Pieter" <pietercoucke@.hotmail.com> a écrit dans le message de news:
> %23w1cPSlIGHA.668@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> Is it possible to use a Custom Class/Object as a DataSource/DataSet for a
>> report?
>> I have now for instance my object MyCompany, and it woudl be nice to just
>> use a MyCompany-instance as the DataSource...
>> Any hints/help woudl be really appreciated,
>> Thanks a lot in advance,
>> Pieter
>|||That's right, my mistake
I should have said applications and not only ASP.NET applications
I meant a SSRS report is a standalone xml file
Thanks for correcting
Med bouchenafa
"Ken Tucker [MVP]" <vb2ae@.bellsouth.net> a écrit dans le message de news:
OPOUq3mIGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hi,
> You can bind windows applications to objects also.
> Ken
> --
> "Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
> news:OhXZe$lIGHA.2896@.TK2MSFTNGP09.phx.gbl...
>>I thought that the objectDatasource control was only used by ASP.NET
>>applications.
>> A SSRS report is not an ASP.NET application unless you use the new
>> reportViewer component and there you can use an ObjectDataSource
>> Med bouchenafa
>> "Pieter" <pietercoucke@.hotmail.com> a écrit dans le message de news:
>> %23w1cPSlIGHA.668@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> Is it possible to use a Custom Class/Object as a DataSource/DataSet for
>> a report?
>> I have now for instance my object MyCompany, and it woudl be nice to
>> just use a MyCompany-instance as the DataSource...
>> Any hints/help woudl be really appreciated,
>> Thanks a lot in advance,
>> Pieter
>>
>|||Ok thanks, but how do I have to do it? I can't find any information about
it?
How do I tell my report (when designing it) that it has to use property's of
a certain class? and how can I give an instance of that class as a parameter
before refreshing the reportviewer?
"Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
news:ubgLk$oIGHA.3492@.TK2MSFTNGP09.phx.gbl...
> That's right, my mistake
> I should have said applications and not only ASP.NET applications
> I meant a SSRS report is a standalone xml file
> Thanks for correcting
> Med bouchenafa
> "Ken Tucker [MVP]" <vb2ae@.bellsouth.net> a écrit dans le message de news:
> OPOUq3mIGHA.1180@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> You can bind windows applications to objects also.
>> Ken
>> --
>> "Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
>> news:OhXZe$lIGHA.2896@.TK2MSFTNGP09.phx.gbl...
>>I thought that the objectDatasource control was only used by ASP.NET
>>applications.
>> A SSRS report is not an ASP.NET application unless you use the new
>> reportViewer component and there you can use an ObjectDataSource
>> Med bouchenafa
>> "Pieter" <pietercoucke@.hotmail.com> a écrit dans le message de news:
>> %23w1cPSlIGHA.668@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> Is it possible to use a Custom Class/Object as a DataSource/DataSet for
>> a report?
>> I have now for instance my object MyCompany, and it woudl be nice to
>> just use a MyCompany-instance as the DataSource...
>> Any hints/help woudl be really appreciated,
>> Thanks a lot in advance,
>> Pieter
>>
>>
>