Posts

Showing posts from 2020

Crystal Report FAQ Error and Fixes

CrystalReports Crystal Report Versions: CrystalReports.com CrystalReports.com/download/ Crystal Reports, Developer for Visual Studio Downloads Common Errors for runtime version: 13.0.22.2668 Error: Failed to load database information. Details: Error in File rpt*** 17596_15752_{FC2EA1BF-082D-4345-947E-BE235A441BFD}.rpt: Failed to load database information. Details: System . Web . HttpExceptionThe file '/gsk/Reports/HRM/Viewer/CrystalImageHandler.aspx' does not exist . System . Web . HttpException ( 0x80004005 ) : The file '/gsk/Reports/HRM/Viewer/CrystalImageHandler.aspx' does not exist . at System . Web . UI . Util . CheckVirtualFileExists ( VirtualPath virtualPath ) at System . Web . Compilation . BuildManager . GetVPathBuildResultInternal ( VirtualPath virtualPath , Boolean noBuild , Boolean allowCrossApp , Boolean allowBuildInPrecompile , Boolean throwIfNotFound , Boolean ensureIsUpToDate ) at System . Web . Com...

MS Sql Server Local DB

Web.Config file: <add connectionstring="Data Source=(LocalDb)\MSSqlLocalDB; Initial Catalog=[database-name]; Integrated Security=True" name="ConnectionString" providername="System.Data.SqlClient" /> Connect to Local DB: Open Visual Studio: Menu: Tools > Connect to Server > Left navigation bar > New Data Connection: Server Name: (LocalDb)\MSSqlLocalDB drop database "myDB";  create database "myDB"; -- Check the logical file name (1st column) after running this query RESTORE FILELISTONLY FROM DISK = 'E:\Ismail\Projects\VPT_TVL\vpt\database\VPT.bak'; -- Place the Logical file name after MOVE statement, and a path where database files will be created RESTORE DATABASE "myDB" FROM DISK = 'D:\database\myDB.bak' WITH MOVE 'myDB_Data' TO 'E:\database\TVL_PT_Data.mdf',      MOVE 'myDB_Log' TO 'E:\database\TVL_PT_Log.ldf', REPLACE;