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:

Databases :: Connecting To Oracle In A Web Application?

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

Configuration :: Connecting An Application To Two Or More SQL Databases?

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

Architecture :: Design An Application To Fetch Data From Different Application Databases

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 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

Databases :: Connecting To An SDF File?

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

Databases :: Connecting Oracle DB Without TNS Entry Through ADO.Net?

Jan 25, 2011

Is ther any way for this.

View 2 Replies

Databases :: Oracle Client In Connecting Two Different Schemas?

Feb 9, 2011

In my 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

Databases :: Connecting Remote Oracle With Limited Permissions?

Feb 15, 2011

I am new to the, 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

Databases :: Connection String -- Connecting AS400 Table In .net?

Dec 23, 2010

how can i access an AS/400 Database/Table in website.I thought i would add something like this in web.config, but it does not work.

<add name="AS400" connectionString="Driver={Client Access ODBC Driver (32-bit)};SERVER=IP Address; USER=usr; PASSWORD=pwd; "/> [code].....

View 2 Replies

Databases :: Data Access Layer For Multiple Databases?

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 3.5 based on database connection

View 1 Replies

Databases :: Connecting To Database - Login Failed For User "discountb1" Error

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 page i'm using the following


i believe i have done everything right, but its obviously not the case.

View 2 Replies

Remotly Connecting To A Web Forms Application That Uses Routing?

Mar 30, 2010

I've been developing a 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

Configuration :: Connecting Application To Online DataBase

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

Web Forms :: Connecting Master Pages In Web Application

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

DataSource Controls :: How To Create Multiple Records In A Dataset From Multiple Databases

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:


View 2 Replies

VS 2010 Connecting To SQL Database From Windows Form Application?

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.



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

DataSource Controls :: What Is Better: Connecting To DB With One Stored Procedure To Get Two Table At Once OR Connecting...

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

Mobiles :: Can Create Windows Mobile Application Without Connecting Device

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

Active Directory/LDAP :: Connecting Intranet Application To Global Catalog

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?


View 2 Replies

Architecture :: Auto Update Application Like In Wordpress, Application Must Check If New Updates Are Available?

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

View 2 Replies

Architecture :: Best Way To Pass A Values From One Application To Another Application?

Dec 8, 2010

Which is the best way to pass a values from one application to another application in

View 5 Replies

Architecture :: Best Way To Kill Session From One Application To Another Application In C#?

Dec 8, 2010

Which is the best way to kill session from one application to another application in C#

View 5 Replies

Architecture :: Want To Create Another Application Or Sub Application?

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

View 3 Replies

Architecture :: Should Multiple Project Be Used For UI / BLL And DAL

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

Databases :: Update Multiple Row With Different Value?

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;

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

Copyrights 2005-15, All rights reserved