Cisco Issues Security Patch Updates for 32 Flaws in its Products

https://bit.ly/2wOtM28

Query to Identify Primary Table is being used as Reference in which Tables in the SQL Database

Just write down the PrimaryTableName

and execute below query.

SELECT OBJECT_NAME (FK.referenced_object_id) 'Referenced Table', OBJECT_NAME(FK.parent_object_id) 'Referring Table', FK.name 'Foreign Key', COL_NAME(FK.referenced_object_id, FKC.referenced_column_id) 'Referenced Column',  COL_NAME(FK.parent_object_id,FKC.parent_column_id) 'Referring Column' FROM sys.foreign_keys AS FK INNER JOIN sys.foreign_key_columns AS FKC ON FKC.constraint_object_id = FK.OBJECT_ID WHERE OBJECT_NAME (FK.referenced_object_id) = 'PrimaryTableName' If you want to check multiple Primary Table then just replace OBJECT_NAME (FK.referenced_object_id) = 'PrimaryTableName' by OBJECT_NAME (FK.referenced_object_id) in ('PrimaryTable1','PrimaryTable2','PrimaryTable2')

Simple solution for Crystal Report SP12 with Visual Studio 2013 on 64 bit OS

First of all, many many thanks to Don Williams (http://scn.sap.com/people/don.williams)

Issue: 

An unhandled exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll

Additional information: Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.

Solution: 

Simply add useLegacyV2RuntimeActivationPolicy="true" in startup tag in app.config file.

example: <startup useLegacyV2RuntimeActivationPolicy="true">

Use Crystal Report SP12 for Visual Studio 2013, SP11 has regression issues

SAP has announced through their website regarding the regression issues in SP11.

SP9 or higher is required to integrate "SAP Crystal Reports development version" for Visual Studio 2013

download link: Crystal Report (version SP12) for Visual Studio 2013

Error 10061 or 1067 when starting MySQL Service

Steps to mitigate…

1. stop the MySQL service

2. Delete both ib_logfile0 and ib_logfile1

3. restart MySQL service

both the files ib_logfile0 & ib_logfile1 are loated in MySQL data folder…

This is just work-around solution, assuming there are no databases uisng InnoDB engine.
Otherwise, those databases will not work. Please take proper backup/sql dump before applying above procedure.

Display Crystal Report with ASP.NET 4.0 from IIS7 Production Server

To display crystal report (with ASP.NET 4.0) from the IIS7 production server, following steps are requried... (it worked for me and hopefully will work for you too...)

Step 1:

Installing Microsoft Data Access Components (MDAC) 2.8 Software Development Kit. 

1.      Download link:  http://www.microsoft.com/en-us/download/details.aspx?id=21995 and 

2.      Service Pack 1 of MDAC from the link: http://www.microsoft.com/en-us/download/details.aspx?id=5793

Step 2:

Adding ASP.NET 4.0 as Application Pool on IIS 7
1.      Open your command prompt (Windows + R) and type cmd and press ENTER

You may need to start this as an administrator if you have UAC enabled.
To do so, locate the exe (usually you can start typing with Start Menu open), right click and select "Run as Administrator"

 2.     Type cd C:\Windows\Microsoft.NET\Framework\v4.0.30319\ and press ENTER 

 3.     Type aspnet_regiis.exe -ir  and press ENTER again.

·         If this is a fresh version of IIS (no other sites running on it) or you're not worried about the hosted sites breaking with a framework change you can use -i instead of -ir. This will change their AppPools for you and steps 5-on shouldn't be necessary.

·         at this point you will see it begin working on installing .NET's framework in to IIS for you

 4.     Close the DOS prompt, re-open your start menu and right click Computer and select Manage

 5.     Expand the left-hand side (Services and Applications) and select Internet Information Services

·         You'll now have a new applet within the content window exclusively for IIS.

 6.     Expand out your computer and locate the Application Pools node, and select it. (You should now see ASP.NET v4.0 listed)

 7.     Expand out your Sites node and locate the site you want to modify (select it)

 8.     To the right you'll notice Basic Settings... just below the Edit Site text. Click this, and a new window should appear

 9.     Select the .NET 4 AppPool using the Select...  button and click ok.

10. Restart the site, and you should be good-to-go.

(You can repeat steps 7-on for every site you want to apply .NET 4 on as well).

Step 3:

Copying "aspnet_client" folder into your web application directory

Take this content: C:\inetpub\wwwroot\aspnet_client

And copy to here: C:\inetpub\wwwroot\WebAppFolderName\aspnet_client

(I installed IIS root directory in C: drive)

Step 4:

Modify web.config file

Add following section into web.config file...

<startup useLegacyV2RuntimeActivationPolicy="true">

      <supportedRuntime version="v4.0"/>

      <requiredRuntime version="v4.0.20506"/>

</startup>

Now, you are done setup Crystal Report withASP.NET 4.0 into the production Server...

Enjoy!!!

Crystal Report for Visual Studio 2010

Crystal report is not included with Visual Studio 2010, instead you have to download it from SAP - Business Object website.

To make it workable with your code (c#/vb.net),  you have to follow below steps, quite easy for you as I did, so surely everyone dose...

1. Install Visual Studio 2010 IDE; download link: http://www.microsoft.com/visualstudio/eng/downloads#d-2010-express

2. Install Visual Studio 2010 Service Pack-1; download link: http://www.microsoft.com/en-us/download/details.aspx?id=23691

3. Download & Install Crystal Report;  download link: http://www.businessobjects.com/jump/xi/crvs2010/us2_default.asp

I downloaded from the first link, SAP Crystal Reports, version for Visual Studio 2010 - Standard, Standard EXE installation package which installs the software into the Visual Studio IDE.

You will also have Crystal Report run time engine as well as merge module for .net 4 (both for 32 & 64 bit)

Once you installed the above, then restart your computer and you are done with the installation...

Now,  open Visual Studio and select crystal report application; do the necessary report design and database connectivity etc...

Here comes one the point, when you are going to run your project then we will get an error "Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information"

don't panic, you already done almost everything... just add following lines into application configuration (app.config) file inside configuration section, and then save & run your project.

<startup useLegacyV2RuntimeActivationPolicy="true">
      <supportedRuntime version="v4.0"/>
      <requiredRuntime version="v4.0.20506"/>
</startup>

wow!!! you have done it... hope that will help you a bit...

Thanks...