.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
sivanagamahesh
Post New Web Links

datasource no connection

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server
 
I open my report builder 2.0 to create a report based on a stored procedure.  I add a datasource and dataset and cannot see the stored procedure to select in the dataset.  Why isnt the datasource connecting to the dbase with the stored procedure.  the url is correct and does not send me error (http://[servername]/reportserver


View Complete Post


More Related Resource Links

How can I programatically set a connection string in a datasource

  
I am thinking of putting a drop down list to choose a couple of options.  Depending on what is selected I want to then specify a specific connection string.  I use the ConnectionString="<%$ ConnectionStrings:SomeConnectionString %>" format.  How can I handle this in the .aspx page?

changing datasource connection

  
hi...i've 50 crystal reports which is connected to the database directly without using any dataset..and the connection string is vsspl-002\\sqlexpress..now my problem is i've shifted the database to another location..and my connection string is vsspl-008\\sqlexpress..now i dont want to change the connection string for each report individually..is there any solution that to change only once and it apply to all the reports...please help me it urgent....

setting datasource connection string globally

  
hi.... to all can anybody help me it urgent please.. hi i have 10 seperate crystal reports for an employee database.. it is working good.. now the main problem is i've shifted my database to another location.. now i want to change the datasource connection string for all the crystal reports.. it is very complicated.. instead of changing the connection string for each report can anybody tell me how to keep the connection string global. if i change the connection string in global then it should be applied to all the reports.. is there any solution..reply me fast..

Infopath bug in windows 7 to convert datasource to data connection library in sharepoint?

  
Any ideas about this bug: Windows 7, infopath 2007, did not check in the data connection file when converting a data source? Also it did not set title and kept the file checked out so that you can not even update the items by SharePoint UI. I did everything successfully with Infopath 2007 on a windows xp machine. Is the OS related in this case? Thanks,

Cannot create a connection to datasource 'DataSource'. (rsErrorOpeningConnection)

  

I've been chasing my tail on this issue for a while, and I figured I would see if I could find any answers. None of the 'solutions' I've found work for my setup.  I'm new to this, so here is the setup:

SERVER1 - Has SharePoint 2007 & SQL 2008 Reporting Services
SERVER2 - Has the data warehouse, report databases and cubes (SQL 2008 cluster, thus I couldn't load reporting services on it)

As myself, domain admin, I have no issues running any reports from anywhere. All works.

As a user, they get the message:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource'. (rsErrorOpeningConnection)
The connection either timed out or was lost.
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host 

To be more specific, the user only gets this message when running a report off of the cubes, they can successfully launch reports from the data warehouse data source (even though it's on the same server as the cubes).

To make things more complicated (or maybe not), if the user directly logs on to SERVER1 and runs the reports, they run fine. All on same domain. To be clear, the user is a local machine admin. If I login on SERVER1

Cannot create a connection to data source ''

  

I copied an old report and changed the data sources. The report works fine in the designer and on the report server. But when I run it from the server on which the database is located it gives me the following error. Works fine when I use 'Store credentials in report server'. tried anonymous login too. Doesnt work.

  • An error has occurred during report processing.
    • Cannot create a connection to data source '<name of my datasource>'.
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors
      •        
      •                                   
      • Please help.     &nb

Shared Datasource Connection String Keeps Getting Wiped Out

  

I originally reported this on the TechNet site, but one of the moderators asked me to post here. Here's the link to that thread: http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/a4c54e10-3d59-4d30-8264-bfc250b4cfbe

I have a report that has a main report query based off an OLAP cube. It also uses a shared datasource for other queries. There are times when I make a seemingly innocuous change to the report, like adding a border to a table cell, and when I go to preview the change, the report comes back to tell me:

[rsInvalidReportDefinition] The report definition is not valid. Details: The report definition element 'ConnectionProperties' is empty at line 13, position 9. It is missing a mandatory child element of type 'DataProvider'.
Build complete -- 1 errors, 0 warnings

I then have to go into the Datasource Properties window, just opening it and then hitting "OK" to close it again, to reinstate the connection string (even though it shows properly when I open the dialog box). The kicker is that it seems totally random. Sometimes the small change will require this action and other times it doesn't. Version information can be found on the TechNet posti

using connection strings in the report server than the datasource in 2005

  

Hi!

I am using a datasource in the report server where all the reports use that shared datasource while calling the reports from asp.net pages.

Now, as asp.net pages uses the connection string for the databases which is assigned in the web.config file, i want the reports also use the same connection string because you don't need to change on both places( web.config and report server datasource).

Any idea plz


Using connection string instead of datasource in report server 2005

  

Hi!

I am using a datasource in the report server where all the reports use that shared datasource while calling the reports from asp.net pages.

Now, as asp.net pages uses the connection string for the databases which is assigned in the web.config file, i want the reports also use the same connection string because you don't need to change on both places( web.config and report server datasource).

Any idea plz

i am working on VS2005 and ssrs 2005

 


Do not feel regret.... just try to improve..... its far better

how to change database connection of infopath datasource

  

hi,

my question is. i have created a form with a sql server database connection. now if i want to open these form on another machine, with the same database but another server name

how can i change the database connection for the datasource for this form?

thank you


Hide a repeater in ASP.NET C# if the DataSource contains no items?

  
I have an ASP.NET page that uses a repeater nested within another repeater to generate a listing of data. It's to the effect of the following:
In the (C#) code-behind I'm basically using LINQ to pull a listing of information from an XML document and bind that information to the first repeater.

Searching for the answer to this, it seems the method is to determine whether the data for the nested repeater is empty. If it is, then you set the visibility of the repeater to false.

SQL Connection String

  
We can learn or know how can we connect the database from our .net. This will help for freshers or .NET beginners!

Manually sorting and paging Gridview without using datasource control

  
Many a times while working with Gridview we want to work with the paging and sorting functionality without using any datasource control. Gridview is flexible enough to perform these tasks without the use of any datasource control and only a few lines of code.

abstract away the source of the connection string using a class with a static property.

  
ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.

The element of a web.config file is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application to perform work. The items inside appSettings are items that need to be configurable depending upon the environment, for instance, any database connection strings will change as you move your application from a testing and staging server into production.

Encapsulation
Let's abstract away the source of the connection string using a class with a static property.

connection string question from a newbie

  

when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"


Dynamic Data, Domain datasource, Poco and lookups

  

Mr. Edward,

Excuse my question but: it is necessary to involve in our projects something more than just Dynamic Data or should we make use of all other features available in VS2010 (which will make assume taht they had been left out of the Dynamic Data framework) like: wef, poco, azure, wcf, cloud, mvc, silverllight, ajax, odata, agile, workflow, etc.?

Sorry my ignorance, I'm just transcribing names as they come to my mind and of which I don't know anything about

 

Carlos Porras (El Salvador)


localhost is not set up to establish a connection on port 51624 with this computer

  

I'm trying to run asp.net locally, but getting the error

localhost is not set up to establish a connection on port 51624 with this computer

How can I fix it?


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend