Skip to main content

Posts

Unable to access the table during begin transection

Dear Reader Today one of my client shows me the problem that is new for me and i need to share with you that issue is when they are trying to update or insert any stuff in the sql server by using begin transection they are unable to access the table let suppose there are thosands of tables that need to be updated under begin transection then it must lock the sql tables unless untill the transection has not be committed or rollback begin transaction update tablenameset columnname = getdate() where columnname = '9000000017' Commit Solution for this problem I have found the solution may be it works for current basis i am not able able to sure this will work but that is what they are looking http://msdn.microsoft.com/en-us/library/ms173763.aspx Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com
Post a Comment
Read more

Sys.ArgumentException: Cannot deserialize. The data does not correspond to valid JSON.

I face the problem today and sick to resolve it thanks for Henrik Juhlin who post the solution here and i will do following more changes get rid of this issue http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/107/threadid/329762/scope/posts/Default.aspx Update following files from dnn 5.0.1 dnn installation setup to Main JS folder js/dnn.xml.js js/dnn.xml.jsparser.js js/dnn.xmlhttp.js js/dnn.xmlhttp.jsxmlhttprequest.js Note very important : after that clear your cache and close the browser. Execute the application again in new browser Regards Rashid Imran Bilgrami CEO Best Visualization
Post a Comment
Read more

DNN Blog: Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces

Dear all, Today i was faced a problem problem setting up Blog module, one of the exception blocks is shown below: Error: Blog is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: 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) ---> System.Data.SqlClient.SqlException: 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) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnect...
Post a Comment
Read more

HTML VS HTM

This is very simple question but i don't think many people knows about that what is the difference between HTML and HTM why these both extension are different even both contain the same code style Ans. Three letter extension (.htm) was due to Windows 8.3 filenaming convention used in DOS because it could not understand 4 letter extensions or long filenames. html is the proper extension and should always try to use this instead of htm. in 1995 when windows 95 arrived then it will give the support for more then 3 charcter extenshion thats why .html was drived always prefer to use ".html" Regards Rashid Imran Bilgrami CEO Best visualization
Post a Comment
Read more

SQL Reporting Service - SSRS Installation & Configuration

In this blog i informed you about SSRS reporting installation & Configuration Normally during installation of SQL server 2005 and 2008 we did not check mark Report server and also did not use instance name in sql server   Setup Instruction Technical Issue the first thing you need to run the SSRS is to install the custom instance name in your SQL server installation Second you must select the Reporting service and business intellignece service in the setup     Configuration Steps & Instructions There are many tutorials that defines you the installation & configuration and i am not rewrite every thing because i am consentrating on the problem that arrives after doing these steps please follow setps in the below mentioned URL Major Instruction for Vista and windows 7 users You must start installation of sql sever by using main administrator user If administrator user is not enable you just follow these steps Start > Control Panel > Select Administrator ...
Post a Comment
Read more