Skip to main content

Posts

MYSQL ERROR

Mysql exception:dbname.ISNULL function does not exist. This error actually srewed me a lot. I did lot of google but the search result were not help full. I manage to solve this error. Below is my findings that may helpfull. I have store procedure where I used ISNULL very often and even other procedures. But only one procedure was showing this Error. For this first check in procedure if there is "Enter" immediate after ISNULL then remove it. If function is used in the procedure check the same in function too. This will resolve the issue :)

Sever information

1)To get server information about original installation Date etc... Type below command in command line for windows systeminfo find /i "install date" looks like below in cmd ----------------------------------------------------------------------------- 2) If you are not able to access other machines in domain, even though they are visible in the net work and trying accessing the same machine from other if you get below message like. %"This server's clock " is not synchronized with the primary domain controller's clock" Do the following log off the machine which is not accessible and login with domain administrator and in command line type NET TIME /DOMAIN:%userdomain% /SET and press enter . Now log off and login with your user name and check. 3) To view or change the network configuration of your local computer or a remote computer. You can manually run Netsh commands or you can create batch files or scripts to automate the process. Not only can you ru...

Dot Net Configuration Errors

When getting error like Object reference not set to an instance of object or system null reference as in below image. For this check application web config if any key declaration is remain. Because this is the cause for such error most of the time.