Comments by Ranjith Kumar (Top 20 by date)

<add name="HaierOracleServer" connectionstring="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.24.35.85)(PORT=1527))(CONNECT_DATA=(SERVICE_NAME=DRMSB)));User Id=dbams;Password=123#123;">

I am using Server level configurations as my connectionstring ..so it should work in local and server

I rechecked twice but no connection string problem

As i said earlier its working in my local with no errors with same connection string

can u give sample code for using session/cache plzz

var ip = context.Request.Headers["Host"];
HttpContext.Current.Session["ip"] = ip;

still null in session

///
public class sdp : IHttpHandler
{
private static readonly log4net.ILog log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
string returnMsg;

public void ProcessRequest(HttpContext context)
{

var ip = context.Request.Headers["Host"];
// var ip = context.Request["HTTP_X_FORWARDED_FOR"] ?? context.Request.UserHostAddress;
log.DebugFormat("Received request from IP: {0}, Msisdn: {1}, Message: {2}",
ip, context.Request["msisdn"], context.Request["msg"]);
var status = Processor.Instance.Process(context.Request.Params["msisdn"], context.Request.Params["msg"]);
log.Info(status.Description);
context.Response.ContentType = "text/plain";
returnMsg = string.Format("<ussd><type>3<msg>{0}", status.Description);
log.Info(returnMsg);
context.Response.Write(returnMsg);
}

how can i use that ip in another class file

any incoming ip

Web

thank you let me check plzzz

Serial is primary key and auto increment

here is the schema
CREATE TABLE HAIER.PEPSIRENDEEMHISTORY
(
SERIAL NUMBER NOT NULL,
PIN VARCHAR2(50 BYTE),
STATUS NUMBER DEFAULT 0,
CURRENTDATE DATE,
MSISDN VARCHAR2(50 BYTE),
USERNAME VARCHAR2(50 BYTE),
SIM INTEGER DEFAULT 0
)

i have tried its working thank you but i have one more problem...showing me cannot insert null value into serial which is auto increment column

CAN U SHARE SOME SAMPLE EXAMPLES PLZ THE DATEFORMAT SHOULD BE IN MM/DD/YYYY EXAMPLE 05/12/2013