Click here to Skip to main content
15,887,214 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
I have an application developed in MVC 3, mysql (from xampp database). it is currently running on windows server 2005 32bit, but when I tried to migrate this tool to windows server 2008 64 bit, I encountered this "error: Object reference not set to an instance of an object". I have tried as well to change my mysql.data.dll but the error still occur.

Does anyone here familiar on this?

Any advise please.

Thanks in advance!
Posted
Comments
John C Rayan 14-Dec-15 8:16am    
Where do you get this error? Can you show us the line of code?
Did you uninstall the MySql driver and install the 64 bit version of it.?
Member 4419121 15-Dec-15 7:22am    
i think this line in controller is not can't be triggered
// initialize MySql connector
mySQLWrapper mSQLObj = new mySQLWrapper(HttpContext.Application["MySQLConnString"].ToString());


and also in model
using MySql.Data;
using MySql.Data.MySqlClient;

namespace Request_Tracker.Models
{
public class mySQLWrapper
{
private const string cTicketNumbers = "pTicketNumbers";
private const string cFormCode = "pFormCode";
private const string cStatus = "pStatus";
private const string cDateRequestedFrom = "pDateRequestedFrom";
private const string cDateRequestedTo = "pDateRequestedTo";
private const string cDateOpenedFrom = "pDateOpenedFrom";
private const string cDateOpenedTo = "pDateOpenedTo";
private const string cDateNBSActionFrom = "pDateNBSActionFrom";
private const string cDateNBSActionTo = "pDateNBSActionTo";
private const string cProcAllStatus = "uspgetrequestsheader";
private const string cProcMarketPending = "uspgetpendingheader";
private const string cProcNBSPending = "uspgetnbspendingheader";
private const string cProcRawData = "uspgetrawdataclosed";

//this wrapper is exclusively for select only, reading data
private MySqlConnection mConn { get; set; }
private MySqlCommand mComm { get; set; }
public long mRowCount { get; set; }
public MySqlDataReader mReader { get; set; }
public long mRowsPerPage { get; set; }
public long mPageNum { get; set; }

public mySQLWrapper(string sConn)
{
//default values
mRowsPerPage = 0;
mPageNum = 1;
mConn = new MySqlConnection(sConn);
mConn.Open();
mComm = new MySqlCommand();
mComm.Connection = mConn;
}

public void retrieveRows(string argSQL)
{

mComm.CommandText = countRowSQL(argSQL);
var objRowCount = mComm.ExecuteScalar();
mRowCount = objRowCount == null ? 0 : (long)objRowCount;
if (mRowCount > 0)
{
if (mRowsPerPage == 0)//return all rows
{
mComm.CommandText = argSQL;
mReader = mComm.ExecuteReader();
mRowsPerPage = mRowCount;
}
else
{
mComm.CommandText = argSQL + " LIMIT " + ((mPageNum * mRowsPerPage) - mRowsPerPage) + "," + mRowsPerPage;
mReader = mComm.ExecuteReader();
}

}
}

public void runSpAllStatus(clsAllStatusParams objParams)
{

mComm.CommandText = cProcAllStatus;
mComm.CommandType = System.Data.CommandType.StoredProcedure;

mComm.Parameters.AddWithValue(cTicketNumbers,objParams.pTicketNumbers);
mComm.Parameters.AddWithValue(cFormCode, objParams.pFormCode);
mComm.Parameters.AddWithValue(cStatus, objParams.pStatus);
mComm.Parameters.AddWithValue(cDateRequestedFrom, objParams.pDateRequestedFrom);
mComm.Parameters.AddWithValue(cDateRequestedTo, objParams.pDateRequestedTo);
mComm.Parameters.AddWithValue(cDateOpenedFrom, objParams.pDateOpenedFrom);
mComm.Parameters.AddWithValue(cDateOpenedTo, objParams.pDateOpenedTo);
mComm.Parameters.AddWithValue(cDateNBSActionFrom, objParams.pDateNBSActionFrom);
mComm.Parameters.AddWithValue(cDateNBSActionTo, objParams.pDateNBSActionTo);
mReader = mComm.ExecuteReader();

}

in Global.asax
Application["ConnString"] = "server=phsscd0004;user=root;database=db_request_manager_es;port=3306;password=N8sD%ve10p;";

in Web.config
John C Rayan 16-Dec-15 4:39am    
Change your "MySQLConnString" to "ConnString" in mySQLWrapper mSQLObj = new mySQLWrapper(HttpContext.Application["MySQLConnString"].ToString());

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900