Feed aggregator

How to resolve Drupal and Internet Explorer problem

MitraZ - Your Everyday Need - Mon, 06/28/2010 - 10:01pm

In Drupal each module exports its own stylesheet. Hence the more module you install the more stylesheets are created. Internet explorer cannot handle more than 30 stylesheets at a time. Ref. http://support.microsoft.com/kb/262161. Hence the view of a Drupal site with lots of modules often breaks down while loaded in Internet Explorer. This problem does not happen with Firefox. Another reason out of many to chose Firefox over Internet Explorer.

-->

read more

Provider Load Failure In SQL Server Management Studio

MitraZ - Your Everyday Need - Sun, 06/27/2010 - 8:30pm

When I go to Reporting Services Configuration in Microsoft SQL Server Management Studio, I get an error: "Provider Load Failure". A temporary solution I found at http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/threa... is as follows:

Copy <C:\WINDOWS\system32\wbem\framedyn.dll> to <C:\Program Files\Microsoft SQL Server\90\Shared\> directory.

Though it temporarily resolved the issue, I could not start some basic SQL Server services under windows administration. Ultimately I had to reinstall Management Studio completely to have a smooth flow. I believe my initial setup somehow was not done right.

-->

How to connect SQL Server 2005 with both ORACLE 8 and 10g databases

MitraZ - Your Everyday Need - Sat, 06/26/2010 - 7:30pm

I was honestly trying to stop using ODBC for its tremendously slow performance.

It was a real pain to begin with. I had Oracle 8 client on my PC but I could not connect to ORACLE 10g database we have. I also tried using 10g client but again I could not communicate with ORACLE 8 database. I found out ORACLE 10g client does not talk to ORACLE 8 database and ORACLE 8 client does not talk to 10g database. Finally, I was successful with 9i client to be able to connect to both ORACLE 8 and 10g databases.

-->

Max Date Function SQL

MitraZ - Your Everyday Need - Thu, 06/24/2010 - 1:41am

Following is SQL statement to find out MAX DATE out of many records of different days. This will show the most recent record. It works for both Date and DateTime field.

SELECT    MAX(<<Column/Field Name>>) AS DATE
FROM         <<Table Name'>>

-->

How to fix #DIV/0! Error Value in Division in Microsoft Excel

MitraZ - Your Everyday Need - Tue, 06/22/2010 - 12:35am

This error is caused by denominator being '0' and hence making the numerator undivisible Refer to this article on Microsoft support: http://support.microsoft.com/kb/182188

-->

SET NOCOUNT (Transact-SQL) SQL Server 2005 Stored Procedure

MitraZ - Your Everyday Need - Sun, 06/20/2010 - 1:12am

When you run stored procedure or queries, you would notice a message on the status bar that shows the number of rows affected. In stored procedure if you set 'SET NOCOUNT ON' then it stops this message from showing and saves substantial amount of time for the run. Reference: http://msdn.microsoft.com/en-us/library/ms189837.aspx

-->

Column name or number of supplied values does not match table definition

MitraZ - Your Everyday Need - Sat, 06/19/2010 - 9:46pm

When you try to INSERT values from one table to another table of same structure, you may see the following error in SQL Server 2005:

"Column name or number of supplied values does not match table definition" Majority of time this is due to a simple mistake of not having the same column name or column definition as the other table. Carefully check the table structure and the problem will be resolved. -->

Confirm record changes on MS Access form

MitraZ - Your Everyday Need - Sat, 06/12/2010 - 10:56pm

MS Access forms automatically saves the data you enter. Therefore, if you want to take an extra step to secure your database from unwanted corruption then here is the code that you may try:

*************************************************

Private Sub Form_BeforeUpdate(Cancel As Integer)

' This step is to confirm with user that this record is going to be modified

  Dim updRecord As Byte

  updRecord = MsgBox("Do you wish to change this record ?", vbOKCancel, "Record Modification")

  If updRecord = vbCancel Then

    Cancel = True

  End If

End Sub

**********************************

-->

Donation for true cause or get ripped off - what do we need?

CanadaReform.ca - Voice Your Opinion - Fri, 05/14/2010 - 7:40pm

The word 'donation' carries a big value now a days. Donations are important for multiple cause both domestic and internationally. Not only that the donations raised through multiple sources helps numerous causes but also the same donation process benefits major capitalist retailers to gain publicity free of cost.

-->

read more

Deactivate Blue key function on HP Laptop

MitraZ - Your Everyday Need - Tue, 04/27/2010 - 11:08am

How to deactivate blue key function in HP Laptops:

To turn on and off Bilingual blue keys:

Hold Ctrl + Shift + shift
(Press both shift keys at the same time in addition to key)

-->

Syndicate content