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?
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?
how to migrate an existing database from a specific application to a new Ms Access based application(database)?
View 4 RepliesI would like to use the Role Membership and User Security database as my application database too. That is, just add the tables and relationships required by my application's data access layer to the Membership and Roles Database to save on hosting fees, (I have to pay extra for having two databases instead of one). Of course, the connection string would have to be adjusted, but I don't see a downside considering the application's database is actually an Access database. What can I say, it was a requirement at the time.
Basically, I would like to do the opposite of this:
http://forums.asp.net/p/1162485/1925262.aspx#1925262
I have an existing SQL database containing student:class enrollments and would like to add a login feature using asp.net's built in Membership and Roles management tools. to how to integrate the Application Services Database with an existing SQL database? Once I have created the Application Services tables using aspnet_regsql tool how and where do I create a link between my tables and the .Net Membership tables?
View 5 Repliessplit a database web application -
Application1 uses database1 on ServerX
Application2 uses database2 on ServerY
Both application communicates over web service API, they are apart of the same application, one application is used to manage user's profile/personal data, while the other application is used to manages user's financial data.
Or should just put them together and just use 1 database on the same server?
I want to restore a database using asp.net web application in C#..
View 1 RepliesHow to use different database for One Application
View 6 RepliesI am looking to build a web application from the ground up. I have done a bit of research, however I just thought I would post here to see what kind of responses I get. I will give a brief description of the type of application I am trying to build. It will be a database web app for managing clients and financials of those clients. The application will need a secure log on system for approximately 160 end users, with the ability to change permissions for each user given their individual rights.
Depending on the type of user created they will have access to 1 of 7 unique application modules within the app framework. A data dictionary will be designed and created prior to starting the project as the 7 unique application modules will have common database fields and custom relationships. Based on this information, what asp.net tools, libraries or books would you recommend using?
I have a development box running Win7 and VS2010. A User Acceptance Testing server running Windows Server 2008 / Sql Server 2008 and a Live server running Windows Server 2008 / Sql 2008.
When doing development I connect to a development database on the UAT server.
I have a problem that only occurs when I change the connection string to point to the database on the Live Server.
So, before I start describing the problem - the app works fine in development and when published to the UAT server - but there is a problem when I either publish it to the live server or, whilst on my dev box, point the connection string to the live database.
Here's an example.
I have a page with a gridview on it. In each row of the gridview there is a drop down list. All calls to the database are done through a Data Access class.
Say I have a function on an .aspx.cs page called GetDetails().
In this - to populate the Gridview I'll have something like ...
Code:
[code]....
I'm going to develop a desktop tool that will require a database.
How would I go about doing it in a way that will allow me to post the code to a website so that all of the desktop applications see a new version and download the database.
I want to attach the sql server database to my asp.net web application. How can i do it ?
View 1 RepliesI am trying to develop a web application(Using ASP.NET and c#) that uses a specific database hosted on web server. I will have another desktop application that will use a local database. Both databases have same structure and data at start up. Then databases will change when users add data to web application and an employee adds data to the desktop application. After a while I have to sync both databases.
What will be best way to do this? Is there any opensource example/ starter kit to start with?
My application is working correctlywhen I debug it against my sql express.
Now i have deployed on IIS on another machine with win2008 web server and changed the database connection string.I would like that the application uses always the same user to connect to the database and not to use the identity of the connected user.
Error: Cannot open database "XXXXXX" requested by the login. The login failed. Login failed for user 'NT AUTHORITYNETWORK SERVICE'
How do I connect from a web application to db2 database?
View 3 RepliesSituation: I have a web application which shows errors and where you can accept those error messages. I also have a service, which checks errors from a system and sets the error messages in the database. When I accept an error in the web application, i would like the service to know which error message has been accepted, so that it can do some other actions. My guess is that this could be done through some sort of trigger, but i can't figure out how.
View 1 RepliesAlmost all the applications I worked on involve some look-up values. For example, a lot of times a list of languages ( English, French, etc...) need to be displayed on the WebForm for user to choose.
The common data structure for such look up values include an integer Id and a string as name. Since these look-up values are used so frequently, and they are unlikely to be changed. Most of time, instead of grabbing them from database, I just define a global enum in C# like this
enum Language : int { English = 1, French = 2}
I've been handling look-up values like this for years now. I knew it may not be the best way to handle them. For example, every time a new language is added to the system, somebody needs to remember to update that enum.
we are developing a application using MVC 2 , i would like to have help on developing database independent application , is there any way to achieve using MVC .
Also is there any examples of ORM available using MVC for newbee to understand.
how i can use Oracle database with asp.net mvc 2 web application?
View 3 Replieshow can I enable database logging in my ASP.net application?
I am using VS2010 (ASP.net MVC2 Project) and would like to see logging that highlights database activity between the application and the database, including database connection establishment (as I do have a connection related error somewhere).
I'm using SqlServer Express 2008.
I have setup a Web Site Administration Tool for a web application and it work great
Now i have another custom application that was built on a different server and site but i want to use the users in the existingWeb Site Administration Tool for authentication and authorisation.So i deployed the custom application to the the same server where the Web Site Administration Tool resides. and just changed the connection string to point to the same database.But when i login with a username and pass it says login no correct.http://myserver/IntranetAdminTool/default.aspx?pplicationPhysicalPath=C:Inetpubmyapplication&applicationUrl=/myapplicationwhen i go to the link above it works and i can see all my usershttp://myserver/IntranetAdminTool/default.aspx?pplicationPhysicalPath=C:Inetpubmyapplication2&applicationUrl=/myapplication2When i go to this link i can't see users as its th new custom application i just moved to the site.
I get error There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem:Server cannot access application directory 'C:Inetpubmyapplication2'. The directory does not exist or is not accessible because of security settings.Is my approach a resonable one and is this possible?
I am developing a web application which requires user to login. There will be N number of users using website concurrently. We have a MySQL database which will store user information like Name, User ID, Password etc. I am not able to understand on how to check username and password once they enter data using Login form which will be present in DB.
View 4 RepliesHow to intregrate an oracle database with an asp.net web application?... Any good tutorial to start with?
View 1 RepliesI am having a problem in inserting characters such as a name into a mySql database via an Asp.net application.
If I inserted numbers, the app adds the numbers into the database and I can see them, but the case with names, the name column in the database shows no values (keeps on showing null values) along with the numbers added.
command2 = New MySqlCommand("INSERT INTO customer(Customer_id, Customer_name) VALUES (@Customer_id, @Customer_name)", Connection) // Connection String
command2.Parameters.AddWithValue("@Customer_id", SqlDbType.Int).Value = TextBox1.Text() //assign values
command2.Parameters.AddWithValue("@Customer_name", SqlDbType.VarChar).Value = TextBox2.Text() //assign values
I have users input links (like file paths and web pages links) to a database via a form. When they put file paths (e.g C:Program Files...) it stores them properly.However, I have a page in my application that pulls the links from the database so that the user can click on those links. For links which include spaces (like the one I just used as an example) it replaces the space with %20 ... This messes up my link and it doesn't work. How can I fix this?-I number records that are saved into my database in a specific way. I have an ID for each record which is a two digit number. For number that are low (1-9) I would like it to display as 01, 02, 03, etc. But if I save it in that form into the database, it goes from 01 to 1.How can I fix this? Users need to see it as 01, 02, etc...
View 6 Replies