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?
>
Showing posts with label cant. Show all posts
Showing posts with label cant. Show all posts
Monday, March 12, 2012
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
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..
Labels:
cant,
connection,
database,
example,
microsoft,
mysql,
oledbconnectionstring,
oracle,
playing,
pull,
rda,
rdaoledbconnectionstring,
server,
sql
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.
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.
Subscribe to:
Posts (Atom)