.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

urgent help needed regarding transactional replication2005

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
 
urgent help needed regarding transactional replication2005   I did set up transactional replication on sql 2005 and also in article properties have selected to replicate foreign keys,default constraints and indexes. I checked the schema properties at publisher and subscriber and found that on one table a foreign key is not replicated which has an on delete cascade. I am not sure why is not replicating that constraint.The other table has a foreign key which is also not replicated.   I would appreciate all your help. thanks, Satya


View Complete Post


More Related Resource Links

urgent needed an sql query

  

Hiii Frnds,

I have to generate a unique token no which will have three fields an incrementer,comp_code and

date.

I have problem in generating a unique incrementer. Incrementer should be incremented by 1 like 0001,0002 etc, should be unique and based on no of record inserted.

Plz rep asap

thanx and regards


Urgent: help needed signing a SOAP 1.1 Message's Body+Timestamp, and send over SSL

  

Hi:

I have a deadline that is about to whoosh by having underestimated how tricky this would turn out to be.

Specs:

 

  • SOAP 1.1
  • WS-Security for timestamp and signing
  • signature has to be single signature made from 2 elements: body + timestamp
  • Asymmetric Algorithm: SHA1
  • Key algorithm: RSA 
  • sent over SSL
  • client has to authenticate to server via cert with well known CN=
  • Server is not .NET but Weblogic, with policies that cannot be changed.

Basically, a secure (SSL) based transport, with signing to protect against tampering as well as replay.

 

wsHttpBinding

Seemed like a good choice at first as it has WS-Security built in.After setting up a behavior that defines client and server certs setting binding/  

Unfortunately wsHttpBinding creates a signature from too many elements in the message (Body, Action, RelatesTo, Timestamp).

There is no apparent way of controlling what gets selected as an element of the signature.  

For example: as the ws-Security headers (Timestamp, etc.) are not part of the proxy Request message class definition, and are added/injected somewhere down the line, and are no

URGENT HELP NEEDED - RECEIVING ERROR MSG: Procedure or function usp_InsPatient has too many argument

  

error msg detail:

System.Data.SqlClient.SqlException was caught
  class="16"
  ErrorCode=-2146232060
  LineNumber=0
  Message=Procedure or function usp_InsPatient has too many arguments specified.
  Number=8144
  Procedure=usp_InsPatient
  Server=.\sqlexpress
  Source=.Net SqlClient Data Provider
  State=2
  StackTrace:
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnSt

Response.BinaryWrite help needed

  

Hi all

Im new to .NET and stuck now, so i hope anyone can help my with my problem.

I have a MS SQL database where i have stored some documents as Binary data. I cant figure out how to retrieve them and show/download them in my browser.

I found some guides online and have try to put something together.


Download.aspx.cs:

private void Write()
 {
 int id = 0;
 string strID = Request.QueryString["id"];
 int.TryParse(strID, out id);

 var db = new ModelDataContext();
 var doc = db.DocumentDatas.Where(x => x.ID == id).FirstOrDefault();

 byte[] byteArray = File.ReadAllBytes(doc);

 Response.BinaryWrite(byteArray);
 }

How do i fill the byteArray with the data?

Thanks in advance :)

/Ryan


help needed: Ldap User authentication using userDN and password

  

Hi

Is it possible to authenticate a user using userDN and password? If so, then tell me the syntax.So far i have tried to authenticate using username and password from my c# code using directoryentry which takes the parameters like domainname,username and password. But i need to authenticate using Userdn and password.



helped needed: ASP LDAP authentication failed in IE 8

  

I use the following code to do the user authentication through Active Directory using LDAP.

try
{
entry = new DirectoryEntry("LDAP://" + server, user_name, password);
if (!string.IsNullOrEmpty(entry.Name))
{
EmployeeNetId = entry.Username.Substring(0, 3);

// Retrieve EmployeeId, and Employee Full Name
GetEmployeeId(EmployeeNetId);
}
}
catch
{
EmployeeId = -1;
}

It works for Chrome, Firefox with no problem. But with IE 8, it works sometimes, and failed on some computers. When it failed, I figured that I need to check SSL 2.0 in IE 8 Internet Options.  It's weird because in those computers that IE 8 works, SSL 2.0 is also unchecked.

Am I using some deprecated method? Or How do I specifiy the SSL version options in the LDAP connection?


Cutting Edge: Transactional Workflows

  

When modeling business logic, workflows inevitably represent transactional tasks, so you need to know how to code transactional semantics in the Windows Workflow Foundation.

Dino Esposito

MSDN Magazine June 2007


COM+: Create a Compensating Resource Manager to Extend Your App's Transactional Features

  

A Compensating Resource Manager (CRM) is any COM+ object that uses the CRM facility provided by COM+, a set of tools that make it simple to create a custom resource manager for business scenarios that require handling some non-database operation (such as generating a file) as part of a transaction. This article provides an overview of transaction processing, distributed transactions, and the two-phase commit protocol for transactions. Also covered are the implementation and configuration of a CRM.

Alan Gordon

MSDN Magazine March 2001


urgent help please (c#)

  

Hi all,

I need urgent help. (c#coding)

This is a work application form. There are 4 different parts, each of all get different information from user. First, general information like, firstname, lastname, birth etc. Second one is about educational information.

On page there is a dropdown with items; primary education, high school, university etc.(User chooses last completed education). And after that selection, here loads user controls according to selection. During this I have problem with postback. It postbacks all page even I use updatepanel.

I'm writing all code above, first main page(work application form) then designer part; third usercontrol codebehind, last usercontrol designer part.

Please, I really need urgent help very very much.

Thanks to helpers.

First main page: codebehind:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;

public partial class _Default : System.Web.UI.Page
{
    //these are usercontrols i talked about; highschool, university etc.
    BizimUserControl buc = null;
    liseusercontrol luc = null;
    yuksekunivuc yuc = null;
    universiteusercontrol uuc = null;
    yukseklisansusercontrol yluc = null;
    doktorausercontrol duc = nul

Live website slow - very urgent

  

Hi All, 

Finally i came to know because of firebug that  ScriptResource.axd's (multiple) are making my files slow on first click

How do i merge them into 1 ??

 

 

1. ScriptResource.axd is making my page slow in first click.

On second click onwards its fine as i have added handler from http://madskristensen.net/post/Compress-WebResourceaxd-in-ASPNET.aspx   It helps performance but from second click onwards.I am testing it with FireBug.

2. I have also seen and treid http://www.codeproject.com/KB/aspnet/AspNetOptimizer.aspx  but not able to make out how to implement in my application.

3. I also tried http://madskristensen.net/post/Optimize-WebResourceaxd-and-ScriptResourceaxd.aspx but it has error, I tried making chnage as per the discussion in url but it is sill giving error.

4. I have also made scriptmanager as release mode

Please help its urgent

 


Help needed in selecting coulmns from 2 tables using entity framework

  

Hi all,

I have two tabels as mentioned below. I am using entity framework and vs2010.I am not able to write linq query to get data from both the tables. there is one to many relationship(for one category ther can be multiple articles). Please help me out as this is very urgent. Thanks in advance.

1) Article

ArticleID bigint Unchecked
CategoryID int Unchecked
ArticleName varchar(500) Unchecked
ArticleDesc nchar(1024) Unchecked

Is the REST Starter Kit still needed with WCF 4?

  

The REST Starter Kit was targeted at WCF 3.5. I am wondering if it is still needed with WCF 4?


Edit MSI file dynamically using c# code. : very urgent

  

Hi All,

I had created one application and this is multi client application means code is same but setup is different for each client with diff. client Code in app config file, diff product code, upgrade code, setup name, display name.

So i am looking for a way to edit my MSI file dynamically and made changes into that for each client using code or any other way dynamically.

Do any one has idea how to do this Dynamically/Anyother.


Thanks in advance.

Hiren


WCF over mobile modem link - performance help needed

  
I am looking for ways to improve the performance of my WCF communications over a mobile modem. I have a system where the clients are connected to the internet via a mobile (GPRS/3G/HSDPA) connection. This is NOT a windows mobile client, it is a full XP Professional system running .Net4.0. The clients basically use a USB mobile modem (SIM card etc) to get their internet connection. The server is connected directly to the internet via broadband. My WCF interface has 2 main methods, one sends 2 int values from the client to the server and the other sends 3 images (JPGs) to the server. As you can see one is going to take less than a second and the other is going to take maybe 30-60 seconds depending on the images size and connection speed. If we have a good mobile modem connection to the internet then everything works perfectly. The problem I have is a lot of the time I do not have a good connection. The timeout on the WCF binding is set to 120 seconds. This gives the images enough time to get across even if the connection is a bit slow.  The problem comes when the connection stops - this is a network (mobile network) problem, something like the signal drops etc. Communications never recovers. At this point after about 10 seconds of inactivity (no communications) I know that the connection will never recover. At this point the best thing I have found to do it res

Transactional replication: Updates to one of my columns (sometimes) does not get replicated from the

  
hi, This is my scenario: I have a varchar(max) column on a table that is replicated to other servers. I have a stored procedure that does and update to this column and other columns on the table. This is done inside a transaction that also includes other updates. When I call the stored procedure, this one varchar(max) column's value is not replicated. When I just run the single update statement on its own, the value is replicated. Anyone know something about this? Thanks!    

transactional replication and sp_MSupd tables

  
Hi thre, My target server keeps running sp_MSupd sp for different values in profiler and synch status shows "delivering replication commands" I keep waiting but this never ends. and ultimately we run a snapshot and it can't be applied. So recreate the whole replication again. It runs fine for a while but again, the sp_MSupd sp starts running on the target server and the replication goes down again. I don't know how to fix this. any advices?   Regards
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend