Skip to main content

Posts

Crystal Report 2010 - Failed to load database information

"Failed to load database information" error when i try deploy my program with CR 2010 using TTX file as report definition this is because there is missing .dll, call "CRDB_FIELDDEF.DLL"..u need to manually copy the file to "C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86" folder then the report is loading again it said that TTX is old tech but i'm still using it because i don't need to connect the report to any DB, but until i found new one to replace :D check this link to read it [EDIT 25 Jan 2011] i think i'll using ADO.NET Dataset next time :D until then

Deploying VS 2010 and Crystal Reports for VS 2010

for win App: download SAP Crystal Reports runtime engine for .NET Framework 4 (32-bit) SAP Crystal Reports runtime engine for .NET Framework 4 (64-bit) from here extract the package, u'll ended up with this 2 files CRRuntime_64bit_13_0.msi CRRuntime_32bit_13_0.msi copy both to: C:\Program Files\Microsoft SDKs\Windows\v7.0A\Bootstrapper\Packages\Crystal Reports for .NET Framework 4.0\ in Setup Project Prerequisites, u must check SAP Crystal Reports Runtime Engine for .NET Framework 4.0 then build the Setup :D hope this help, see u

ClickOnce: "Value cannot be null.\r\nParameter name: activationContext"

heloo.. if u get "Value cannot be null.\r\nParameter name: activationContext" error when try to deploy clickone.. make sure Enable ClickOnce Security Setting leave uncheck.. see the image until then

Backup SQL Server DB to network drive

here the step that needed: 1. make sure SQL SERVER SERVICE in run under same account and password between SQL SERVER machine and Network Machine ex: Network Machine: \\192.168.1.5\f$ - share the f$ in 192.168.1.5 - set security for the share for : user1 with pwd: pwd1 SQL Server machine: - create user1 with pwd: pwd1 if it doesn't exist - setting the Service for SQL SERVER to run under: user1 account with pwd: pwd1(Log On As) - execute the script 2. backup script BACKUP DATABASE [DB_LIVE] TO DISK = '\\192.168.1.5\f$\backup_db.bak' WITH NOFORMAT, NOINIT, NAME = N'SRM_LIVE-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 u can set it to run for jobs too see u