Showing posts with label cant. Show all posts
Showing posts with label cant. Show all posts

Monday, March 12, 2012

RDLC Object datasource can't get System.Web through webform reportviewer

I am running an RDLC with a object datasource. In the object I try to
access System.Web.Httphandler to get the session, but it is nothing.
The reportviewer running my rdlc from a webform, and it seems as though
there is a setting or something to enable the object datasource access
to the session but I cannot figure it out.
Can someone help?Currently I get this error when it tries to access
System.Web.Httphandler.Current
Microsoft.Reporting.WebForms.AspNetSessionExpiredException|||lotta typos today, I am accessing:
System.Web.HttpContext.Current.Session("PhysicalWebPath")
and Current is Nothing|||This is not too surprising. The web control uses web services. I am not sure
it has a physical web path. What are you trying to determine?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg" <gfricke@.gmail.com> wrote in message
news:1132681439.261358.193190@.g43g2000cwa.googlegroups.com...
> lotta typos today, I am accessing:
> System.Web.HttpContext.Current.Session("PhysicalWebPath")
> and Current is Nothing
>|||Just trying to grab a session value, so if its a web service that the
web control uses, is there an EnableSession true setting I cause use in
my object datasource like I do in a standard webservice to share the
session?|||Sorry, can't help you there. I have been using the winform control.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg" <gfricke@.gmail.com> wrote in message
news:1132689249.764262.282850@.f14g2000cwb.googlegroups.com...
> Just trying to grab a session value, so if its a web service that the
> web control uses, is there an EnableSession true setting I cause use in
> my object datasource like I do in a standard webservice to share the
> session?
>|||On a side note, can I see these webservices? Like does it create a
asmx file or something I can connect to in IE for the object
datasources the reportviewer communicates with?|||The webservices are documented and you can use them yourself. Prior to 2005
people would (and still can) roll there own, not using the control. The
previous control (really a sample) used URL integration and so had some
difficulties.
In Books Online look for web services and you will see lots of
documentation.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg" <gfricke@.gmail.com> wrote in message
news:1132690648.480837.290540@.o13g2000cwo.googlegroups.com...
> On a side note, can I see these webservices? Like does it create a
> asmx file or something I can connect to in IE for the object
> datasources the reportviewer communicates with?
>

Saturday, February 25, 2012

RDA oleDBConnectionString problem

hi there,
can anyone please show me an example of RDAoleDBConnectionString? i was playing around with RDA, but i cant pull data with my connection string, with an error message
failure to open SQL Server with given connct string. [ connect string =
Data Source = JUN; Initial Catalog = SmartShopper; Integrated Security =True ]
i need a sample of connection string to connect to SQL server 2005, i was using VB 2005 to deploy my project

You need to specify a provider in the OleDb connection string. See http://www.connectionstrings.com/ for examples.

But if you want to connect to a SQL Server, you should probably use the Sql-specific types instead of OleDb.

|||thanks for your reference site...i get quite a lot info there..

Monday, February 20, 2012

Rare behavior

Hi!
My SQL Server has a rare behavior ... some times I can't find database objects like sp's, relations, etc (objects missing). So, I think in scenes:
* security
* virus (like slammer)
* SQLServer becomes "crazy"
Dou you have been in this problem? How did you solve it?
Thanks so much in advance
Note: The SQL server has not installed any service pack. It exists a firewall too.
What does "can't find" mean? Can you show an example, including syntax used
to create objects, syntax used to "find" objects, and what error messages
you receive?
"Han" <anonymous@.discussions.microsoft.com> wrote in message
news:B97DD589-BE7E-4BB6-8824-C7FE40399BC0@.microsoft.com...
> Hi!
> My SQL Server has a rare behavior ... some times I can't find database
objects like sp's, relations, etc (objects missing). So, I think in scenes:
> * security
> * virus (like slammer)
> * SQLServer becomes "crazy"
> Dou you have been in this problem? How did you solve it?
> Thanks so much in advance
> Note: The SQL server has not installed any service pack. It exists a
firewall too.
>
|||Sorry! I meant when a check my db I notice disappearance of objects (some relations, sp's etc.). Usually I use SQL Server Entreprise Manager.