I'm a developer new to asp.net 3.5. My client asked if there were any implications of using Linq to SQL data sources with mirrored clustered servers with Failover clustering.
So my questions are can you use Linq to SQL with mirrored Clustered Servers?
If yes to the above, do you need to add or modify any code for mirrored Clustered Servers?
1) we have only one select query to select 5 column form the table(i.e. select col1,col2,col3,col4,col5). so in that case should we go for stored procedure Or we can directly write the select query in the .Cs file only ( means in Database layer). when we should go for the SQL server stored procedure and when we should go for in line query in Visual Studio itself.
2)how to decide when to use Clustered and when to use Non Clustered index?
where should we use clustered index and non clustered index.i mean in day to day use which on e to choice and how to make decision.
View 8 RepliesWe use the caching and logging application blocks from entlib 4.1. We want to keep the configuration of those two in seperate files. How can we achieve this?It looks like entlib is always using the selected Source as it configuration.I tried the following:
[code...]
But this doesn't work because the application blocks always use the selected Source attribute value.
What are the database Servers supprted by LINQ to SQL in .Net Framework 4.0. Is there any other servers other than MS Sql server.
View 4 RepliesIf same web application is deployed on three different servers, which things we need to take care of and what things should be common amonges all three?
View 3 RepliesI have a situation where we are splitting dynamic content from static content and each is getting its own web server. The people maintaining the site want to be able to make navigation changes once and have it show on both servers without any major extra work (for them). I'm putting the navigation structure in an XML file which also has information on things specific to each content page. This brings me to the question of how to share that file. If I want the change to be instantaneous I can't rely on a scheduled task to copy the file from one server to another.Access to one of the servers is very limited due to security policy.
I am thinking about maybe a web service running on one server to get the data from it to pages on the other server. Does this sound viable or do any of you have other ideas that may work better? I considered having the navigation in a database but this introduces the need for a tool for the navigation updaters to have for them to do that. It is easy for them to update XML and just publish to the server with a lower security level. To get them database access requires terrible paperwork and meeting with security people.
You have two servers when you perform a SQL Server database mirroring.You have 1 primary database and 1 mirror database
Do you need to make any changes to web application to tell it that your using database mirroring? If not how does your web application know which database to use when the primary database fails?
We have built an asp.net application according to 3 tier architecture, but Data Tier and Application logic lies on the same server. Our client needs that to be deployed in 2 different servers. Only front end in web server DAL & BLL in app server. Database is in different server. All 3 servers are at different physical locations. How can we commuicate between these servers and our applicaton tiers? is there any option in IIS so that we can deploy only back end code in another server? what is the best approach to communicate between different application tiers when they are physically apart?
View 2 RepliesA friend and I manage a large website for a company. The site is build using Visual Studio 2005 and is a series of nested web applications run inside a master application employing nested master pages. Currently we have to manually move files around folders and FTP them to various servers and I am looking for a way to be able to manage the deployment end of the site in a more automated fashion. I'd like to be able to work on my local version of a project and once I'm done be able to hit one button and publish the site to our internal testing server and then when testing is complete hit another button to deploy it to the live web servers. Right now we have to manually navigate the windows folders and copy pages, css files, images, swfs, etc and FTP them manually. The driver for this is that we have a new junior develop starting and want to remove the manual aspect in advance of him starting.
View 1 RepliesWe have a problem where in the user can download files from an email. A link that will redirect to a page where the code to download the file resides. Before the download the user needs to be logged in to the system for security. The problem is that sometimes for whatever reason when the user clicks the link the download dialog box does not appear and just a blank white page. It happens only on our staging environment where we have 3 servers.. We can't reproduce this in our dev and test env. where we only have one server.
Below is the actual code.
[Code]....
I have an website which runs nice on my development PC as well as on my local server.
But when deployed at clients server it gives error because of different datetime format at client server. I had checked it on 3 to 4 servers when the datetime format is same as my local server website runs fine. But when ever a datetime formate is different it starts giving error for datetime, whenever i try to do any transaction with date stored in datebase.
I just had to moved a site of mine from a hosting service here in the states to an offshore host located in Malaysia. My database is still located on the east coast of north america and I am wondering if the distance between the database and the file system might be to blame for slow load times or if moving my database as well would be a waste of time.
View 2 RepliesI am trying to set up my web site on a stand alone server using Windows Server 2003 with IIS 6 which will access SQL server database (2008) on windows 2008 R2 server (also not in the domain) I am using form authentication and I have configured a custom identity account in IIS6. The local account is on both servers with same password and I have registered the account using aspnet_regiis.exe -ga The application pool in my iis6 has the custom local account set as the identity and my web.config file has the appropriate tags in the system.web element <identity impersonate="true" />
The problem is the local account does not seem to get passed to the sql server. Right now my iis settings are anonymous access (using the local acct vs isr) and no authentication specified under that - I did try Integrated and basic but it prompts for the username and password which I do not want. One article I read stated this: windows authentication does not support delegation (passing credentials from one server to another) and is limited to the one hop rule, only a primary token can be passed to a second server. windows
authentication on iis (all versions) gives the thread a secondary(impersonation) token which can not be used to access any network resouce
I have a search page get data from two sources:
1- my data base
2- web service function
How to put this two data sources in my list view?
I have a ReportViewer control on an ASP.Net page and an RDLC set up that uses a TableAdapter that pulls one record. This works fine.I'd like to have the *same* RDLC use a different TableAdapter (schema of table is the exact same, but may have multiple records). I've tried putting two DataSets in my RDLC and having the code dynamically select which one to use, but it's not working quite right for me.
View 1 RepliesThe question: Is it possible to configure multiple SMTP servers or update the SMTP object server information at runtime?
Description of problem: The site I'm working on has a few pages which send emails. Our site is using Gmail so even though it's a custom domain our email is sent out though Gmail SMTP servers.
Some emails come from the system and some emails come from users in certain groups. I have an SMTP server configured with the admin email for the system e.g. admin@mysite.com This works fine and when I get the email it shows from admin@mysite.comOne of our user groups let's call it "groupA" has an email configured on our domain i.e. groupA@mysite.com When I send the email and specify a from address for the MailMessage object as groupA@mysite.com it still shows up in my outlook as coming from admin@mysite.com I did a little further testing and if I specify both the from address and the ReplyTo as groupA@mysite.com it will show as From=admin@mysite.com but when I choose reply in outlook it shows groupA@mysite.com My best guess is that Gmail is overwriting the From address with the SMTP user to prevent email spoofing.
I found this: http://www.systemnetmail.com/faq/4.1.aspx but it won't work for me since group A, B, and C all need to send emails from the same page.
I need to create a query which does a join between two tables which are in different databases. I can easily connect to each database, and write queries in each, however, I can't seem to find a way of generating a query which does a join between two tables from different databases.
View 2 RepliesI have a slight issue with deleting a record that is stored on two separate SQL servers.
I am using an ASP.NET databound control on a datagrid with delete button commandfield linked to one data source.
Is there a way of deleting the same record from another data source at the same time?
I've created a set of CrystalReports (*.rpt files) for an ASP.NET web app on a development server. I call each report using the following code:
[Code]....
When I transfer the *.rpt files to a different server, the reports display data from the development server; even when I change "Constants.DatabaseName" to point to the new server. It seems like the *.rpt file saves the database connection information from the ODBC File DNS used when creating the report.Has anyone experienced this problem? I'm looking for a solution so I don't have to create multiple copies of my *.rpt files for each server environment (i.e., Dev, Test and Production servers).
We are using a tierd design with a Data Access Layer and classes for everything we need. This serves as an advantage because we do not have to write querys over and we can separate the Presentation layer from the Data Access Layer and Business Rules.I have always in the past populated GridViews, DataLists, repeaters,etc with SqlDataSources. This is what I have become accustomed to and I feel like it is simple. For querys such as Select * from Members, I feel like using a DataSource is simpler than having to go in the code and calling methods to populate and DataBind these presentation controls.
I am working with a gentleman who has introduced me to the world of Data Access Layers and we are breaking everything down into simeple, but effective queries to populate controls and do what we need to accomplish with this application. He is not very approving of using any type of DataSource. We are disagreeing on the time and place to use these class methods to call the database.So my question is, which is more widely used in the programming world? Do most people use DataSources to populate presentation controls regardless of the Data Access Layer they are working with? Which type of queries are best suited for a DAL - simple, populating queries or complicated joins and upserts?
I have a user defined function GetAddress which takes address id (int) as a parameter and returns a address which may contain some 200 to 300 characters...In the execution plan for that function it is displaying cluster index seek cost as 100%...I have clustered index for address id in the address table..is that costing the resources more...How to decrease the cost of the function or a query...!!
View 1 RepliesI developing a application in Asp.net3.5(C#) and Sql server2005, my problem is that i have to Import data from diffrent-2 data sources like MS Access, Oracle, ODBC, XML to my Data base(in Sql server) using C# code. I don't know any thing about importing data from these data sources.
View 1 RepliesI have a stored procedure written using dynamic SQL in the SQL Server and I am calling it on the code behind and adding parameters to it and filling a dataset and binding the data set to a Gridview. But I am getting this error when I bind it.
Can someone please tell me how to fix this?
It used to work fine when I did not use dynamic sql.
Line 237: da.Fill(ds);Line 238: gviewInvestigations.DataSource = ds;Line 239: gviewInvestigations.DataBind();Line 240: Line 241: }
Source File: s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs Line:
239
Stack Trace:
[Code]....
[HttpException (0x80004005): The IListSource does not contain any data sources.] System.Web.UI.DataSourceHelper.GetResolvedDataSource(Object dataSource, String dataMember) +8665698 System.Web.UI.WebControls.ReadOnlyDataSource.System.Web.UI.IDataSource.GetView(String viewName) +41 System.Web.UI.WebControls.DataBoundControl.ConnectToDataSourceView() +128 System.Web.UI.WebControls.DataBoundControl.GetData() +4 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +60 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73 System.Web.UI.WebControls.GridView.DataBind() +4 Controls_InvestigationsControl.bindSearch() in s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs:239 Controls_InvestigationsControl.btnSearch_Click(Object sender, EventArgs e) in s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs:323 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
I need to display some data in a gridview. Its shipping data.
Part of the data can come from a generic database query. Static shipping data that can be looked up from the database. Part of the data is external and has to be queryed from USPS. Any suggestions on what is the best way to accomplish this.
Should I just programmatically fill the gridview from the code behind doing the database lookup manual and filling the gridview with manual data then going out and filling the rest of the gridview with the data obtained from the USPS service?