Pages

Search This Blog

Sunday, December 19, 2010

Xin Invoice software 2.0 holiday season and year end promotion

Xin Cube is running promotion for Xin Invoice product for 16th December 2010 to 31st December 2010. The discount up to 37% for Xin Invoice software version 2.0. for more information, visit: http://www.xininvoice.com . Press release can be found in http://www.free-press-release.com/news-xin-invoice-software-2-0-holiday-season-and-year-end-promotion-1292512710.html

Tuesday, December 7, 2010

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Facing issue when try to connect to MSSQL 2005 Express from remote server

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

To solve this issue

1. Enable TCP/IP


Go to Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager


Make sure TCP/IP is Enabled



2. Make sure MS SQL allow remote connection with TCP/IP protocol.

Go to Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration


Click on Surface Area Configuration for Services and Connections


Make sure Local and remote connections and using TCP/IP only is selected.


3. Open port for Port: 1433, sqlbrowser.exe and sqlservr.exe in windows firewall.
Launch the Windows Firewall configuration tool from the control panel.
Click the Exceptions Tab
Click on Add Port, key in information as below




Repeat above but this time click the "Add Programs." button and select "sqlservr.exe" from the 
location where you install SQL Server Express (normally in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn)
Report the same steps but select "sqlbrowser.exe" (normally in: C:\Program Files\Microsoft SQL Server\90\Shared)



 Try again and the problem solved. Hope this help.




Monday, November 22, 2010

invoice software - Xin Invoice 3 release

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

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

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';



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.

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.

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.

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/"