September 30, 2007

Adobe Premiere & Windows 2003

Problem:
adobe premiere 2.0 installer design to run on Windows XP SP2 or higher








Cause:
If you want to install adobe premiere 2.0 on Windows 2003 or Windows Vista then you got error. This problem come from click on setup.exe but the real hole is Adobe Premiere Pro 2.0.msi. This msi package check the windows specification and we can correct it.












Solution:
1- Download Orca for edit msi package
[2.08MB] 1160303066_orca.rar
[7.93MB]
IntelSDK.msi
[Link]
2- Strat Orca and open Adobe Premiere Pro 2.0.msi
3- Goto LunchCondition from left panel and change value of 3th condition row like below
from ((VersionNT> 500) AND (ServicePackLevel> = 2)) OR ((VersionNT64) AND (ServicePackLevel> = 1))
to ( 1 = 1) OR ((VersionNT> 500) AND (ServicePackLevel> = 2)) OR ((VersionNT64) AND (ServicePackLevel> = 1))


If the problem persists, please don't hesitate to contact me ;-)

PS: you can find Orca from here

September 24, 2007

How to fix a cell in excel

- Fix a cell in excel
- How do i fix a cell in excel


The secret of excel for fix a cell is $ symbol …
For example, if you want to fix the A1 in formula =B1*A1 then change formula to =B1*A$1.
The $ symbol in a formula tells excel not to use this cell for copy command.

September 04, 2007

Load DataSet Error

Problem:
Failed to load dataset because of the following error:
Unable to Find connection ‘xyzConnectionString (Settings)1' For object ‘Settings’. The connection string could not be found in application settings, or the data provider associated with the connection string could not be loaded.





Solution:

It's so simple ...
Go to your xyzDataSet.xsd code and remove the one of duplicate Connection tags like below

<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="xyzConnectionString"
ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly"
Name="xyzConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.xyzDataLayer.Properties.Settings.GlobalReference.Default.xyzConnectionString"
Provider="System.Data.SqlClient"></Connection>