Classic producer-consumer-problem.I have x app servers which write records in a DB table (same DB).On each server,a service is running which polls the DB table and is supposed to read the oldest entry,process it and delete it.
The issue is now that the services get into a race condition: service on server A starts reading,server B starts reading the same record.I'm a bit stuck on this.I have implemented producer-consumer so often but never across server barriers.
The server cannot talk to each other except over the DB.Environment is SQL Server 2005 and ASP-NET 3.5.
I understand the producer consumer pattern but I'm finding it difficult to map it to using the Entity Data Model and SQL Server 2008. I want to implement a work queue where multiple threads will pick up the top 5 items (each) to work on and then perform somelong running task on each of those.I've googled for a an example of this but I can't seem to find one that uses the Entity Data model and C#
i help save image as picture in sql databases for consumer profile now i possess a site that sow consumer profile facts an im this site i possess a picture manage to display consumer avatar with. in code at the rear of with Userprofile.Avatar code i obtained the picture as byte
Is there a way to get information about the web site or application that is consuming the Web Service. I would like to determine the details of an application from within my Web Service when it is consumed. The information would be like that in the assemblyInfo of the caller, application name, version etc. Getting the user seems to be easy enough but not details about the application or web site.
I am working in one of the company which sells music online. we want to white label our website so the different consumer can use our download store with their brand name.
I have a site that is running on a Windows Server 2008 machine with IIS 7.0, when I try to open it with Visual Web Developer 2010, it says the following:
error: unable to open site: ... The Web server does not appear to have FrontPage Server Extensions installed.
Looking on the server Frontpage Extensions 2002 are installed, so what could be wrong?
The thing is, I used to be able to open the project and work on it, etc...
Open Website -> Remote Site -> Enter remote site name -> tries to open & error above!
This issues has been driving me nuts. I am trying to follow the tutorial on [URL] I am trying to connect to a database in Microsoft SQL Server 2008. The way I do this is by right clicking on the "Data Connections" > Add Connection. Afterwards the Add Connection window comes up, I make sure my data source is "Microsoft SQL Server (SqlClient). And, I choose a server name; the only server I can choose is DomainSQLEXPRESS. The issue is when I go down to the "Select or enter a database name" drop down box, I do not see my database listed. I have also made sure in the SQL Server Management Studio that I have given my user all the privileges for the database. I know my explanation is kind of vague, but would anyone know the reason why I would not see my database?
I want to replicate data from branch server to main server using SSIS with scheduling .. Every daily at 12 AM. I can have more than 5 branch servers, I need to transfer datas from these server to my main server. how can i do with SSIS and Error handler in SSIS , While replicating if some error happens , it need to save log file or send mail to me Like this i need to do.. and also i need to scedule the created SSIS pac
I am trying to connect my sql server 2000 using the sql server utility. It is perfecly working fine on my system but when try it on some other system i am getting an error message as "Could not find the server".
Is there any other configuration change that i need to make? I am connecting using TCP/IP
I used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
I want to Access remote server( ie., want to access online server not local server) in my Application.. I change Settings in SQL surface Area Configuration---> Remote Connection ( checked the Local and Remote Connection ) Then while running the application it showing the following error.(I make off the firewall also) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I just installed sql server 2008 R2 on my computer. I am trying to connect to sql server throught my C# code and everytime I run the C# program,
I get this error "A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
The connection string that I used in my web.config file is
[Code]....
I am not sure what am I doing wrong, but I followed this article below step by step and still I am getting the same error
I have created a simple website, Iam connecting to a database the is not located in local-newtwork. Connection from development machine works fine, The problem occurs when I publish the website on my server, than it can not connect to the server, Iam pinging the server I no packets are lost, I don't why it can not connect to the database server?