64 bit Itanium Processor

64-Bit OLEDB Provider for ODBC (MSDASQL)

http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

http://blogs.msdn.com/b/data/archive/2007/06/05/64-bit-oledb-provider-for-odbc-msdasql-available-in-longhorn-server-starting-beta-3.aspx?PageIndex=2#comments

Back to 32-bit vs. 64-bit .NET Basics

when you install .NET on a 64-bit machine the package is bigger because you're getting BOTH 32-bit and 64-bit versions of stuff. Some of the things that are 64-bit specific are:

• Base class libraries (System.*)
• Just-In-Time compiler
• Debugging support
• .NET Framework SDK

For example, I have a C:\Windows\Microsoft.NET\Framework and a C:\Windows\Microsoft.NET\Framework64 folder.
If I File|New Project and make a console app, and run it, this is what I'll see in the Task Manager:


Notice that a bunch of processes have *32 by their names, including devenv.exe? Those are all 32-bit processes. However, my ConsoleApplication1.exe doesn't have that. It's a 64-bit process and it can access a ridiculous amount of memory (if you've got it...like 16TB, although I suspect the GC would be freaking out at that point.)

That 64-bit process is also having its code JIT compiled to use not the x86 instruction set we're used to, but the AMD64 instruction set. This is important to note: It doesn't matter if you have an AMD or an Intel processor, if you're 64-bit you are using the AMD64 instruction set. The short story is - Intel lost. For us, it doesn't really matter.

Now, if I right click on the Properties dialog for this Project in Visual Studio I can select the Platform Target from the Build Tab:


By default, the Platform Target is "Any CPU." Remember that our C# or VB compiles to IL, and that IL is basically processor agnostic. It's the JIT that makes the decision at the last minute.

"If you have 100% type safe managed code then you really can just copy it to the 64-bit platform and run it successfully under the 64-bit CLR."

IIS & ASP.NET Bindings

The following command installs the script maps pointing to the ASP.NET version that is
associated with the tool to the SampleApp1 application and all of its sub-applications.

aspnet_regiis -s W3SVC/1/ROOT/SampleApp1

The following command only updates the script maps for the SampleApp1 application, without
affecting applications in subdirectories.

aspnet_regiis -sn W3SVC/1/ROOT/SampleApp1

The following command installs the ASP.NET version that is associated with the ASP.NET IIS
Registration tool and updates the script maps of all existing ASP.NET applications. Note that
only applications that are currently mapped to an earlier version of ASP.NET are affected.

aspnet_regiis -i

The following command installs the ASP.NET version that is associated with the tool, but it does
not update the script maps of existing ASP.NET applications.

aspnet_regiis -ir

The following command displays the status and installation path of all versions of ASP.NET that
are installed on the computer.

aspnet_regiis -lv

The user is not associated with a trusted SQL Server connection

1. In the SQL Server Properties dialog box, click the Security tab, click SQL Server and Windows, and then click OK.
2. Restart the service and you can now connect using sql server authentication mode

From SQL to Oracle Convertion

For converting sql server schema to Oracle

SQL Ways Wizard

Observations:
1. Oracle Procedure name supports only 32 characters.
2. Return type is number or string then it was converted as Function.
3. Return type is List (Ref Cursors) then it was converted as Procedure.
4. All the identity columns will have a sequence created in Oracle.
5. Sequence of paramters in procedure should be in same order while calling in DAL layer.
6. The Oracle User should have permissions on views and create sequence.
7. For data comparisons in plsql, TO_TIMESTAMP('1753-01-01', 'YYYY/MM/DD') is used.
8. For Crystal reports
..Logon parameters, the database will be blank and server will be data source.
..Location doesn't have to be passed to tables while retrieving the data from procedures.

Reference in bin - Oracle.DataAccess
Replace
System.Data.SqlClient to Oracle.DataAccess.Client
SqlDataAdapter  to  OracleDataAdapter
SqlCommand to OracleCommand
SqlDataReader  to OracleDataReader
SqlConnection  to OracleConnection
SqlParameter  to  OracleParameter
SqlDbType.Int  to  OracleDbType.Int32
SqlDbType.NVarChar  to OracleDbType.NVarchar2
SqlDbType.DateTime  to OracleDbType.TimeStamp
SqlDbType.Image  to  OracleDbType.Blob
SqlDbType.Char  to  OracleDbType.Char
SqlDbType.VarChar  to OracleDbType.VarChar2
SqlDbType  to  OracleDbType
SqlDbType.bit  TO  OracleDbType.Int32

WEB.CONFIG - DBACCESS
Cursor for all the return multiple rows methods...
Dim prmOut As New OracleParameter("v_ref_cur", OracleDbType.RefCursor)
prmOut.Direction = ParameterDirection.Output
db.Parameters.Add(prmOut)

Remove dr.GetInt32(
dr.GetInt32(dr.GetOrdinal("AuditID"))
dr("AuditID")

dalATSUsers - access privileges...
MenuList - replace xml file for uppercase field names...

can you pls suggest the dbtype for 64 bit os err msg
Conversion from type 'OracleDecimal' to type 'Integer' is not valid.
in the DAL layer
search for
db.AddParamToSQLCmd(sqlCmd, "@ReturnValue", OracleDbType.Int32, 0, ParameterDirection.ReturnValue, Nothing)
replace it with
db.AddParamToSQLCmd(sqlCmd, "@ReturnValue", DbType.Int32, 0, ParameterDirection.ReturnValue, Nothing)


drop user IEPS cascade;
CREATE USER IEPS IDENTIFIED BY IEPS;
GRANT CONNECT,RESOURCE TO IEPS;
GRANT CREATE VIEW TO IEPS;

To get the first monday in coming month...
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(sysdate)+1,'Monday'),'MM/DD/YYYY') "Next_Day" from DUAL;

To Support Arabic... for Client Tools
HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ HOMExx \ NLS_LANG
Change the registry value from
AMERICAN_AMERICA.AR8MSWIN1256
to
American_America.UTF8

Troubleshoot Crystal Reports Deployment Issues

Run time merge modules and re-destributables...

https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/bobj_download/main.htm

http://resources.businessobjects.com/support/additional_downloads/runtime.asp

10.2 is Crystal Reports for VS 2005
10.5 is Crystal Reports for VS 2008

Runtime package for Crystal reports for Visual Studio 2008
http://social.msdn.microsoft.com/Forums/en-US/vscrystalreports/thread/b70c896a-6844-48bb-a966-63a3f589a0f1

Run crystal reports developed using VS 2005 on VS 2008 by adding the following section to web.config file...
 <system.codedom>
   <compilers>
    <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4">
     <providerOption name="CompilerVersion" value="v3.5"/>
     <providerOption name="OptionInfer" value="true"/>
     <providerOption name="WarnAsError" value="false"/></compiler></compilers></system.codedom>
 <runtime>
  <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
   <dependentAssembly>
    <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>
    <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/></dependentAssembly>
   <dependentAssembly>
    <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>
    <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/></dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35" culture="neutral"/>
        <bindingRedirect oldVersion="2.0.0.0" newVersion="3.5.0.0"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35" culture="neutral"/>
        <bindingRedirect oldVersion="2.0.0.0" newVersion="3.5.0.0"/>
      </dependentAssembly>
    </assemblyBinding></runtime>

Microsoft Chart Controls

Microsoft Chart Controls for Microsoft .NET Framework 3.5
Prerequisite: Microsoft .NET Framework 3.5 SP1
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=130F7986-BF49-4FE5-9CA8-910AE6EA442C&displaylang=en

Microsoft Chart Controls Add-on for Microsoft Visual Studio 2008
Prerequisite: Microsoft Visual Studio 2008 SP1 and Microsoft Chart Controls for Microsoft .NET Framework 3.5
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=1D69CE13-E1E5-4315-825C-F14D33A303E9&displaylang=en

Samples for Chart Control - .NET Framework 3.5 SP1
http://code.msdn.microsoft.com/mschart/Release/ProjectReleases.aspx?ReleaseId=1591
Samples for Chart Control - .NET Framework 4
http://code.msdn.microsoft.com/mschart/Release/ProjectReleases.aspx?ReleaseId=4418

To Run Samples:
1. Download & Install Microsoft Chart Controls for Microsoft .NET Framework 3.5 or 4
2. Add reference to System.Web.DataVisualization assembly.
3. Build and run.

http://weblogs.asp.net/stevewellens/archive/2008/12/03/custom-annotate-your-charts.aspx

http://weblogs.asp.net/stevewellens/archive/2008/12/11/stupid-chart-tricks.aspx

Windows XP Tips

Forgot Windows XP Passwords?

Use Bootable CD and get to the DOS prompt

Copy windows\repair\sam file to windows\system32\config\sam

This will overwrite the passwords with empty ones.


Do you mean that you want to turn of Plug and Play?

Windows doesn't detect a driver, it detects new Harware and then installs the required driver.

Steve Gibson of Gibson Research has just released an easy-to-use utility
for turning off Universal Plug-and-Play (UPNP) in Windows XP/ME/98. The
utility, "UnPlug 'n Pray", is available for no charge at this download
page:

http://grc.com/UnPnP/UnPnP.htm

This utility is a great tool for folks who would rather turn off UPNP
altogether on their Windows systems instead of having to keep up with a
steady stream of UPNP security patches from Microsoft.

This tool also confirmed that the FBI is currently giving out incorrect
instructions on how to protect a Windows XP from the UPNP security
holes. I followed the FBI instructions, but Steve's utility was still
needed to get the right XP services turned off. The FBI/NIPC Web page
that needs to get fixed is located at:

http://www.nipc.gov/warnings/advisories/2001/01-030-2.htm

Dashboard Designing

Effective Dashboard Design: Why Your Baby Is Ugly
http://msdn.microsoft.com/en-us/architecture/bb267385.aspx


Self-Service BI Architecture for Dynamic Business Reporting
http://msdn.microsoft.com/en-us/architecture/bb267386.aspx


PerformancePoint Monitoring and Analytics: Dashboard basics I
http://office.microsoft.com/en-us/training/performancepoint-monitoring-and-analytics-dashboard-basics-i-RZ010350485.aspx


PerformancePoint Monitoring and Analytics: Dashboard basics II
http://office.microsoft.com/en-us/training/performancepoint-monitoring-and-analytics-dashboard-basics-ii-RZ010350512.aspx

http://it.usaspending.gov/