Architecture :: Web Application Connecting To Multiple Databases?
Sep 17, 2010
I am supposed to develop an enterprise-class ASP.NET Web Application that connects to multiple databases. For example when the web form loads, I should populate different ASP.NET controls (GridView, DataPager, TextBox, DropdownList etc) from multiple databases (SQL Server, Oracle, DB2, SAP Server etc) and also, edit the data in the controls and save the data to the respective databases on button submit.
Should I use Web Service or WCF for data integration, if so is there a limit on the size of the data?
What should be the architecture considering the application should be scalable and easy to maintain?
View 2 Replies
Similar Messages:
Feb 21, 2011
I am developing a web application with back end as Oracle. I call the procedures from web application when ever some update, create or delete for the records needs to be performed. How to maintain the connection in these scenarios.
Can I open the connection and maintain it through out the application till user logs out?
View 10 Replies
Mar 27, 2010
My Application uses two SQL databses, one for membership/roles (ASPNETDB.MDF) the other for my data. When deploying to a server do I have to use two connection strings, one for each database? I am using the publish to provider wizard with VWD 2008 to replicate the databases on Sqlserver 2008 (Windows server 2008 R2). I have my data connection working fine, I am just trying to get mebership and roles working.
View 3 Replies
Nov 10, 2010
I need to develop an application, which will get records (orders) from one application and process them. The updates to this records (order updates) will be sent back to the source application for end customer reference. I'm planning to achieve this data synchronization at the database level using triggers and stored procedures to insert database between the 2 databases.
But, the issue is I have to deploy this application in 3 different customer sites and I have to change the database names (cannot use the same database name) in each deployment manually. Because of this deployment issue, I was thinking of handling this within the asp.net application where I can store the db name in the database and then build the query within the application, but I dont want to do it as building queries like that doesnt look very professional.
View 2 Replies
Dec 6, 2010
I already have an existing sdf file that is used in a windows application by looking at the current programs folder to find it. I want to use this same database (a copy of it) on an ASP .Net website so won't be hosted in a sql server anywhere want's to be accessed directly, is this possible?
View 1 Replies
Jan 25, 2011
Is ther any way for this.
View 2 Replies
Feb 9, 2011
In my asp.net application im using Oracle client. In the connection string, we specify the 3 basic attributes: data source, User Id, and Password. We are using connection pooling. Our data resides in 2 different Oracle schemas. Most of the requests are for data from both Schema1 and Schema2.
Is it possible that the connections are implicitly tied to a schema1 or schema2?
View 2 Replies
Feb 15, 2011
I am new to the asp.net, I am going to create a website which needs to talk to oracle database(i only need get the data only) which is in client place.
I want to know what do i need to do this (what are the requirements)
What i have is Client IP, DB name, Username and Password.
I have asp.net2005 on my system with sql server.
View 1 Replies
Dec 23, 2010
how can i access an AS/400 Database/Table in ASP.net website.I thought i would add something like this in web.config, but it does not work.
<connectionStrings>
<add name="AS400" connectionString="Driver={Client Access ODBC Driver (32-bit)};SERVER=IP Address; USER=usr; PASSWORD=pwd; "/> [code].....
View 2 Replies
Jul 6, 2010
i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
View 1 Replies
Jun 6, 2010
The problem i have would be im getting - 'System.Data.SqlClient.SqlException: Login failed for user 'discountb1'.' error message. my connection string in ASP was the following
"DRIVER={MySQL ODBC 3.51 Driver}; SERVER=CIServer12; DATABASE=BathroomBitsb1; UID=discountb1;PASSWORD=******; OPTION=3"
now just for my simple asp.net page i'm using the following
Code]....
i believe i have done everything right, but its obviously not the case.
View 2 Replies
Mar 30, 2010
I've been developing a asp.net/c# web application that uses .net routing with Visual Studio 2008. The project is setup to use http://localhost:17315 as the server path. I'm trying to figure out a way for a co-worker to connect to my local project from their system. When I setup the project as a virtual directory in IIS (5.1) the .net routing doesn't work correctly and I get a 404 error (http://localhost/home).Is there anyway for a user on our local network to connect to my application remotely with my current configuration? I know they can't connect to the Visual Studio Development Server, but I would think they should be able to connect if the application is setup in IIS. Maybe IIS6+ is needed for this?
View 21 Replies
Oct 1, 2010
I have all my tables and queries in online DB ie., i have created all my tables and queries in online using third party site [URL] Now i want to make connect my application (which is in my system) with that database
View 5 Replies
Jul 12, 2010
i'm trying to connect a webform to a master page but i get errors all the time.
i know that it's quite simple when adding a web content form but i don't really know what is the diffrence.
View 4 Replies
Mar 7, 2011
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
View 2 Replies
Aug 5, 2010
I had another thread on this problem but I wanted to start this one so no one had to look at the code I posted in the other thread. I have a successful connection but want to display data from the SQL database on my website in my Windows form application. Here's the code I have so far. Used some of the ADONET Tutorial1 here. The table Ray Rover Activation has a number of different columns but to start out I just wanted to see if I could display data for the EmailAddress column.
Code:
[code]....
If I comment out the Sub DoStuff I don't get any errors but neither is anything displayed other than the messagebox message. If I don't comment out DoStuff then I get an error, "Incorrect syntax near the keyword 'FROM'". Maybe someone could enlighten me some on what I need to do get the data in the column EmailAddress to display.
View 2 Replies
May 20, 2010
While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.
But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.
I have one Stored Procedure that return the two tables, but entities don't support this right now.
I can split them to two Stored Procedure and call each of them separately.
View 2 Replies
Mar 18, 2011
I am using Visual Studio 2008, I am new bie to create windows mobile application. I haven't installed Windows Mobile 6 SDK. I have started with built-in SDK and Emulators of VS 2008..
My question is, Can i create windows mobile application without connecting device ( Mobile or Pocket PC )?
View 6 Replies
Jan 12, 2010
I am developing an intranet application that needs to authenticate against a global catalog server (containing about 14 domains). What would I use for the connection string?
GC://DC=mb,DC=rellish,DC=com
View 2 Replies
May 3, 2010
I need to auto update application like in wordpress, Application must check if new updates are available, download this updates and install.But I don't know how to install application. Because if some files in bin directory are updated application is restarted.Is it possible to create ASP.NET web application which will be auto updatable?now we have a new technologies, could u please suggest me any kind of soultion for the above problem. here i am enclosing my email idsunnyb4uu@hotmail.com
View 2 Replies
Dec 8, 2010
Which is the best way to pass a values from one application to another application in asp.net
View 5 Replies
Dec 8, 2010
Which is the best way to kill session from one application to another application in C#
View 5 Replies
Aug 25, 2010
I m sure this question has been asked before. I have a web application hosted underhttp://localhost/abc. which is mapped to c:inetputwwwrootabc folder. I have APP_Code, App_LocalResources, BIN and other folders under abc folder. Everything is great. Now I want to create another application or sub application
http://localhost/def. Both abc and def apps need to use some common classes and resources. Whats the best way to do it. I dont need to create a separate application for def. All i want is the url
http://localhost/def.
View 3 Replies
Feb 12, 2010
I have been creating my BLL and DAL with in the same project as my UI. These have been logical tiers in their own folder with in the same project, that's with in the same solution. I want to try to create a solution that is more like a truly multi tiered app.
I've heard people talk about using a separate projects for their DAL and BLL. My understanding is that these would be separate dlls that would contain the appropriate code for each of the these tiers. I have a few questions regarding this.
Is this a good way to do this? It seems like a logical approach. It also seems like the next step in me moving towards an architecture that's truly tiered. Should I do this differently?
Should the projects for the BLL and the DAL use the same namespace? I think I read that some people use a namespace for each of these that indicates what they are, such as BLL and DAL.
View 6 Replies
Feb 7, 2011
I have to update multiple row and two column of each row.
I have try to Update with case statement but after I perform that statement it blank out every other column that doesn't fall into the criteria of the update statement.
My table structure is like this;
table1
col1
row1 11
row2 22
I want to update row1 and row2 of their col1 in one single sql , how do i do that?
View 4 Replies
