Friday, November 6, 2009

Setting database option SINGLE_USER to ON for database

You can find more details on following post

http://support.microsoft.com/kb/911847
http://support.microsoft.com/kb/259551
http://support.microsoft.com/kb/247181/EN-US/
http://support.microsoft.com/kb/274799/

Backing Up and Restoring Your MySQL Database

You can find more details on following links

http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/1/
http://www.mysqlperformanceblog.com/2006/07/30/mysql-crash-recovery/
http://dev.mysql.com/tech-resources/articles/recovering-from-crashes.html.
http://bytes.com/topic/mysql/answers/631163-how-change-mysql-database-directory

Login failed for user 'sa'. [CLIENT: ]

You can find more details on following post

http://support.microsoft.com/kb/322336
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
http://www.eggheadcafe.com/forumarchives/SQLServersecurity/Jul2005/post23406881.asp
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/a50f79ab-a877-4e50-a5bc-8bd0f88384a2/
http://www.tek-tips.com/viewthread.cfm?qid=1344607&page=11
http://support.microsoft.com/kb/907284

How to: Change Server Authentication Mode

You can find more information on MSDN
http://msdn.microsoft.com/en-us/library/ms188670.aspx

Saturday, October 17, 2009

bobj is undefined

When we use crystal report on asp.net application then some times we get this error. May be this error you can face on client server.

Checks

1. Check whether crystal report runtime is installed on you server

2. On IIS, Unser default website you can find crystalreportViewer12 virtual directory and in wwwroot\aspnet_client\system_web\20….\you can find this folder

3. If you are configuring your report web apps on other website then copy this aspnet_client folder to that directory and create same virtual direcotry.

for more details you can check following URLS
http://bytes.com/topic/net/answers/823323-crystal-report-error-bobj-undefined
http://www.codeproject.com/Messages/2463043/Re-Crystal-Reports-Error-BOBJ-is-undefined.aspx
https://forums.sdn.sap.com/message.jspa?messageID=7304519
http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6552&PID=20067