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


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

changing datasource connection

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :ASP.Net
 
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....


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?

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

Changing DataSource

  

If I have created a webpage using wizards to set up the objects, can I change the name of all the datasources by just going into the code and entering the new database (the tables are identical) ?

OR

Do I have to work my way back through all the wizards and re-enter parameters?

Thanks ! 


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

datasource no connection

  
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

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


Changing the graphics on the home page of a SharePoint site

  
When you create a site in Microsoft Windows SharePoint Services by using the default Team Site template, the home page includes two default graphics. A Windows SharePoint Services graphic appears in the body of the page, and a picture of a house in a circle appears near the site title. You can change these graphics to customize your site. Changing the smaller graphic requires a Windows SharePoint Services compatible Web page editor

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.

Convert English to Arabic number without changing any regional settings in .net

  
Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.
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