Xin Cube announce that new version of invoice software - xin invoice 3.0 has released. The invoice software come with new features and new invoice template.
For more information, refer to the press release http://www.prlog.org/11089459-invoice-software-xin-invoice-new-version-30-released-by-xin-cube.html or http://www.free-press-release.com/news-invoice-software-xin-invoice-new-version-3-0-released-by-xin-cube-1290268955.html . For video demo, please refer to http://www.youtube.com/user/xincube
Web application Sharing including ASP, ASP.NET 1.0 (C#) AND ASP.NET 2.0 (C#) MS SQL 2005 Server, Life, Travelling
Monday, November 22, 2010
MySQL Server 5.1 data folder
My development machine have MySQL server 5.0 installed and i upgrade to version 5.1.
After i've installed MySQL server 5.1, i can't found the data folder which normally in "C:\program files\MySQL\MySQL Server 5.0\data" for version 5.0.
Finally able to get the location in in "C:\Users\All Users\MySQL\MySQL Server 5.1\data" for Windows Vista
If you are using windows XP, it's in "C:\Documents and Settings\All Users\MySQL\MySQL Server 5.1\data"
Hope this help
After i've installed MySQL server 5.1, i can't found the data folder which normally in "C:\program files\MySQL\MySQL Server 5.0\data" for version 5.0.
Finally able to get the location in in "C:\Users\All Users\MySQL\MySQL Server 5.1\data" for Windows Vista
If you are using windows XP, it's in "C:\Documents and Settings\All Users\MySQL\MySQL Server 5.1\data"
Hope this help
Labels:
MySQL
Sunday, October 17, 2010
MS SQL profiler like for mysql
I was looking around a software for MySQL that can work like MSSQL profiler which can monitor the SQL query executed. Finally i found one called Log Monitor which work well for me.
How it's work? Download Log Monitor. Open LogMonitor.jar file.
Connect to MySQL server, open a SQL Query window and run this script
SET GLOBAL general_log = 'ON';
Now, open another SQL Query window and run any script. You can see the query you run displayed in the Log Monitor.
Hope this help.
How it's work? Download Log Monitor. Open LogMonitor.jar file.
Connect to MySQL server, open a SQL Query window and run this script
SET GLOBAL general_log = 'ON';
Check on log file location in my.ini file (for windows user) or my.cnf (for linux user).
For windows user,
#Path to the database root
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"
Open Log Monitor and set "log file path" with the file name.
Now, open another SQL Query window and run any script. You can see the query you run displayed in the Log Monitor.
Hope this help.
Labels:
MySQL
Tuesday, October 12, 2010
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Face strange error when try to print report using crystal report.
Server Error in 'xxx' Application.
Exception Details: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Source Error:
Stack Trace:
I'm not sure what could cause this issue but after i reset iis, everything work fine.
Server Error in 'xxx' Application.
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace:
[AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.] CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) +0 CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) +95 CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() +271 [Exception: Load report failed.] CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() +333 CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) +894 CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename) +84 Transaction_InvoicePrint.Print() +149 Transaction_InvoicePrint.Page_Load(Object sender, EventArgs e) +5 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627 |
I'm not sure what could cause this issue but after i reset iis, everything work fine.
Labels:
ASP.NET
Friday, October 1, 2010
mysql 5.1 data folder / directory / location
I've installed new MySQL 5.1 to replace my MySQL 5.0. I cannot find my data folder.
Finally, check my.ini file in MySQL 5.1 folder and found line below
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"
All data folder is in "C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"
Finally, check my.ini file in MySQL 5.1 folder and found line below
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"
All data folder is in "C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"
Labels:
MySQL
Tuesday, September 21, 2010
ASP.NET Security Vulnerability: Take Action Immediately
This is very important for those who have asp.net application running out there. Attacker can get data encrypted data in view state or web.config data if you ignore this.
Detail informations and workaround stated in Scottgu's Blog
For more others information, please refer to
http://www.microsoft.com/technet/security/advisory/2416728.mspx
http://info.dotnetnuke.com/rs/dotnetnuke/images/DotNetNuke_Security_Update_Regarding_ASPNET_Vulnerability_091810.pdf
http://info.dotnetnuke.com/rs/dotnetnuke/images/DotNetNuke_Security_Update_Regarding_ASPNET_Vulnerability_091810.pdf
Labels:
ASP.NET,
Vulnerability
Monday, September 20, 2010
Keep track download in ASP.NET
Situation:
I have a software in my web server and let visitor download for free, i wish to keep track of total download and visitor location.
Feasibility:
For the location keep tracking, i use GeoIP (GeoLiteCity.dat) http://www.maxmind.com/app/ip-location
Solution:
Database:
I have create a table called downloadlog with field below. I plan to have different type of product in future, so i add ProductFamilyID field. If you don't have that, you can ignore it.
Now, i need a stored procedure called psp_DownloadLog_Add that insert data into table above. The code should be as simple as possible
CREATE PROCEDURE [dbo].[psp_DownloadLog_Add]
(
@p_IP NVARCHAR(50),
@p_Country NVARCHAR(255),
@p_CountryCode VARCHAR(50),
@p_City NVARCHAR(255),
@p_ReferrerURL NVARCHAR(512),
@p_ProductFamilyID INT
)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO tblDownloadLog
(
IP,
Country,
CountryCode,
City,
ProductFamilyID,
ReferrerURL,
DownloadDate
)
VALUES
(
@p_IP,
@p_Country,
@p_CountryCode,
@p_City,
@p_ProductFamilyID,
@p_ReferrerURL,
GETDATE()
)
SET NOCOUNT OFF;
END
ASP.NET
To make the system more structural and manageable, I have create 2 classes to handle the download log. DownloadLogInfo class mainly is use the deal with the information that need to log into database. DownloadLog class is mainly the class who do the communication with the database. Please check the code below.
DownloadLogInfo class
public sealed class DownloadLogInfo
{
public DownloadLogInfo() { }
int _downloadID = 0;
string _ip = "";
string _country = "";
string _countryCode = "";
string _city = "";
int _productFamilyID = 0;
string _referrerURL = "";
DateTime _downloadDate = DateTime.Now;
public int DownloadID { get { return _downloadID; } set { _downloadID = value; } }
public string IP { get { return _ip; } set { _ip = value; } }
public string Country { get { return _country; } set { _country = value; } }
public string CountryCode { get { return _countryCode; } set { _countryCode = value; } }
public string City { get { return _city; } set { _city = value; } }
public int ProductFamilyID { get { return _productFamilyID; } set { _productFamilyID = value; } }
public string ReferrerURL { get { return _referrerURL; } set { _referrerURL = value; } }
public DateTime DownloadDate { get { return _downloadDate; } set { _downloadDate = value; } }
public DownloadLogInfo(int pDownloadID, string pIP, string pCountry, string pCountryCode, string pCity, int pProductFamilyID, string pReferrerURL, DateTime pDownloadDate)
{
_downloadID = pDownloadID;
_ip = pIP;
_country = pCountry;
_countryCode = pCountryCode;
_city = pCity;
_productFamilyID = pProductFamilyID;
_referrerURL = pReferrerURL;
_downloadDate = pDownloadDate;
}
}
DownloadLog Class
public sealed class DownloadLog
{
public void Add(DownloadLogInfo pInfo, string pConnectionString)
{
SpParamInfo[] myParamInfo = new SpParamInfo[6];
myParamInfo[0] = new SpParamInfo("@p_IP", SqlDbType.NVarChar, pInfo.IP);
myParamInfo[1] = new SpParamInfo("@p_Country", SqlDbType.NVarChar, pInfo.Country);
myParamInfo[2] = new SpParamInfo("@p_CountryCode", SqlDbType.NVarChar, pInfo.CountryCode);
myParamInfo[3] = new SpParamInfo("@p_City", SqlDbType.NVarChar, pInfo.City);
myParamInfo[4] = new SpParamInfo("@p_ProductFamilyID", SqlDbType.Int, pInfo.ProductFamilyID);
myParamInfo[5] = new SpParamInfo("@p_ReferrerURL", SqlDbType.NVarChar, pInfo.ReferrerURL);
DbAdapter myDbAdapter = new DbAdapter(pConnectionString);
myDbAdapter.ExecuteNonQuery("psp_DownloadLog_Add", myParamInfo);
myDbAdapter.Dispose();
}
}
Now, I have create a page, call download.aspx. This page will actually get information from the visitor and insert into database. After that it will force a file to be downloaded. Before that, i already GeoLiteCity.dat file and put into my App_Data folder.
Code behind for download.aspx
protected void Page_Load(object sender, EventArgs e)
{
string VisitorReferrer;
// Full path to GeoLiteCity.dat file
string FullDBPath = Server.MapPath("~/App_Data/GeoLiteCity.dat");
// Visitor's IP address
string VisitorIP;
VisitorIP = Request.ServerVariables["REMOTE_ADDR"];
if (Request.UrlReferrer != null)
{
VisitorReferrer = Request.UrlReferrer.ToString();
}
else
{
VisitorReferrer = "";
}
// Create objects needed for geo targeting
Geotargeting.LookupService ls = new Geotargeting.LookupService(FullDBPath, Geotargeting.LookupService.GEOIP_STANDARD);
Geotargeting.Location visitorLocation = ls.getLocation(VisitorIP);
DownloadLog myDownloadLog = new DownloadLog();
DownloadLogInfo myDownloadLogInfo = new DownloadLogInfo();
if (visitorLocation != null) // get the geoip information using visitor IP address
{
myDownloadLogInfo.Country = visitorLocation.countryName;
myDownloadLogInfo.CountryCode = visitorLocation.countryCode;
myDownloadLogInfo.City = "unknown";
if (visitorLocation.city != null)
{
myDownloadLogInfo.City = visitorLocation.city;
}
myDownloadLogInfo.IP = VisitorIP;
myDownloadLogInfo.ProductFamilyID = 1;
myDownloadLogInfo.ReferrerURL = VisitorReferrer;
}
else
{
string country = "unknown";
string countryCode = "unknown";
string city = "unknown";
myDownloadLogInfo.Country = country;
myDownloadLogInfo.CountryCode = countryCode;
myDownloadLogInfo.City = city;
myDownloadLogInfo.IP = VisitorIP;
myDownloadLogInfo.ProductFamilyID = 1;
myDownloadLogInfo.ReferrerURL = VisitorReferrer;
}
// WebConfig.Connection is the connection the database and insert data into database
myDownloadLog.Add(myDownloadLogInfo, WebConfig.Connection);
Response.ContentType = "application/zip";
Response.AddHeader("content-disposition", "attachment; filename=softwaresetup.zip");
FileStream sourceFile = new FileStream(@"C:\inetpub\dotnetfish\software\softwaresetup.zip", FileMode.Open);
long FileSize;
FileSize = sourceFile.Length;
byte[] getContent = new byte[(int)FileSize];
sourceFile.Read(getContent, 0, (int)sourceFile.Length);
sourceFile.Close();
Response.BinaryWrite(getContent);
}
Labels:
ASP.NET,
MS SQL 2005
Tuesday, September 14, 2010
Cannot Delete xxx: Access is denied Make sure the disk is not full or write-protected and that the file is not currently in use
Have you come across the annoying error when try to delete files from you computer or even external harddisk?
I've tried to change the permission setting in security tab but i cannot do anything because only system can change the setting.
Finally, i found a tool named unlocker http://download.cnet.com/Unlocker/3000-2248_4-10493998.html that help me to delete the files.
Hope this help.
Labels:
windows
Attempted to read or write protected memory. This is often an indication that other memory has been corrupted.
Hit below error when deploy a new app to existing running application.
Attempted to read or write protected memory. This is often an indication that other memory has been corrupted.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory has been corrupted.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Try to set the folder permission but still hit the same error after restart iis.
Next, i try to run the permissions wizard in the IIS. After run it, restart iis and i'm lucky. It work like normal.
Hope this help.
Labels:
ASP.NET
Friday, August 13, 2010
Subscribe to:
Posts (Atom)


