MC 9090 HHT

http://support.symbol.com/support/search.do?cmd=displayKC&docType=kc&externalId=11759&sliceId=&dialogID=205202966&stateId=1%200%20205204221

http://support.symbol.com/support/search.do?cmd=displayKC&docType=kc&externalId=12912&sliceId=&dialogID=205202966&stateId=1%200%20205204221

http://support.symbol.com/support/browse.do?WidgetName=BROWSE_PRODUCT&TaxoName=SG_SupportGoals&BROWSE_PRODUCT.isProductTaxonomy=true&BROWSE_PRODUCT.NodeId=SG_MC9090_GRFID_3_2&BROWSE_PRODUCT.thisPageUrl=%2Fproduct%2Fproducts.do&id=m4&BROWSE_PRODUCT.TaxoName=SG_SupportGoals&NodeType=leaf&NodeName=MC9090-G+RFID&BROWSE_PRODUCT.NodeType=leaf&NodeId=SG_MC9090_GRFID_3_2&AppContext=AC_ProductPage&param_document=sp

https://docs.symbol.com/KanisaPlatform/Publishing/427/12914_f.html

https://docs.symbol.com/KanisaPlatform/Publishing/428/12915_f.html

https://docs.symbol.com/KanisaPlatform/Publishing/425/12912_f.html

oracle.dataaccess conversion from type oracledecimal to type integer is not valid

Imports System
Imports System.Data
Imports Oracle.DataAccess.Client
 
Module Module1
  Sub Main()
    Dim con As New OracleConnection("user id=scott;password=tiger;data source=orademo")
    con.Open()
 
    Dim cmd As OracleCommand = New OracleCommand("getoutnum", con)
    cmd.CommandType = CommandType.StoredProcedure
 
    Dim p1 As New OracleParameter
    'this will not work as expected with .NET 2.x and higher and ODP.NET
    'p1.OracleDbType = OracleDbType.Int32
 
    'use DbType and not OracleDbType to get the parameter as a .NET data type
    p1.DbType = DbType.Int32
    p1.Direction = ParameterDirection.Output
 
    cmd.Parameters.Add(p1)
 
    cmd.ExecuteNonQuery()
 
    Try
      Dim a As Integer = p1.Value
      Console.WriteLine("val is {0}", a)
    Catch ex As Exception
      Console.WriteLine(ex.Message)
    End Try
 
  End Sub
End Module

web.config driver dll change for the x64 or x86

Issue: An attempt was made to load a program with an incorrect format 64 bit

Add the following binding policy:

Code Snippet

    <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" />
        <bindingRedirect oldVersion="2.0.0.0-10.9.9.9" newVersion="2.102.3.2" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>

If you want your application to force using 64-bit client when running in 64-bit more (tested on AMD 64) use the following code in app.config of your file:

 

Code Snippet

    <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" processorArchitecture="amd64" />
        <bindingRedirect oldVersion="2.0.0.0-10.9.9.9" newVersion="2.102.3.2" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
   
processorArchitecture and bindingRedirect can work wonders for you... changing the redirections and processorArchitecture will help u eliminate the badImageException.

Law of the Garbage Truck

One day I hopped in a taxi and we took off for the airport.
We were driving in the right lane when suddenly a black car jumped out of a parking space right in front of us.
My taxi driver slammed on his brakes, skidded, and missed the other car by just inches! The driver of the other car whipped his head around and started yelling at us.
My taxi driver just smiled and waved at the guy. And I mean he was really friendly.

So I asked, 'Why did you just do that? This guy almost ruined
your car and sent us to the hospital!'
This is when my taxi driver taught me what I now call, 'The Law of the Garbage Truck.'
He explained that many people are like garbage trucks. They run around full of garbage, full of frustration, full of anger, and full of disappointment.
As their garbage piles up, they need a place to dump it and sometimes they'll dump it on you. Don't take it personally.
Just smile, wave, wish them well, and move on. Don't take their garbage and spread it to other people at work, at home, or on the streets.
The bottom line is that successful people do not let garbage trucks take over their day.


Life's too short to wake up in the morning with regrets,
so ... Love the people who treat you right.
Pray for the ones who don't.
Life is ten percent what you make it and ninety percent how you take it!
Have a blessed, garbage-free day!

ETL Tools

Open Source ETL (Extraction, Transform, Load) Written in Java
http://www.manageability.org/blog/stuff/open-source-etl

KETL is an open source ETL tool by Kinetic Networks that is gaining mindshare of late. It is currently downloadable as part of Bizgres BI project, but can be setup for other databases with a little tweaking.

KETL is different from Kettle, another open source ETL tool (you can read more about the story behind similar names here at Nicholas Goodman's blog). While Kettle (API)  is GUI oriented, KETL is scripted.
http://business-intelligence.phi-integration.com/

https://docs.google.com/browse#folders/folder.0.0B9ZAe6ftekYJNTc0OWM2NzctNzM3MS00YmNjLTkyMTctZjg0ZWUxZWI2YWQw
TogetherDownloads - Workflow, Data Transformer, Relational Modler.. etc...  http://www.together.at/download

http://software.xineo.net/xil.jspx  -- APIs

http://scriptella.javaforge.com/

http://www.smooks.org/mediawiki/index.php?title=Main_Page

Laughter is cheap medicine

A woman diagnosed with Rheumatoid Arthritis wrote to me and talked
About how painful the disease had become. Debra said that no drugs
Would touch the devastating pain. "At times I prayed to die because I
Did not think I could go on this way," she said. But in two and a half
Years she weaned herself from most of her medication, which had
Reached a high of 21 pills a day. This is how she did it.

"I began seeing a doctor who gave me the most important prescription
That I ever could have received," she said. "He excused himself from
The room. I watched him walking back and forth in the hall; he seemed
To be in deep though t."

The doctor came back in with this prescription: he told Debra to get
Some funny movies and to begin laughing. If she didn't feel like
Laughing, then she should smile. If she didn't feel like smiling, she
Should smile anyway! He said that it would increase endorphins in her
Brain and help with her pain.

She did just as he suggested. She smiled constantly. Her children
Teased her about the fake smile, but she told them that it was going
To get rid of her pain. And it did. Of course, not all of her pain is
Gone, but her newly acquired habit of laughing and smiling has made it
Manageable without all of the drugs.

Today, Debra is never seen without her smile. She says that she would
Not even feel normal without it.

Laughter really is cheap medicine. And it's a prescription you can
Fill right now.

Never Give Up

One day a young lady was driving along with her father.
They came upon a storm, and the young lady asked her father, What should I do?"
He said "keep driving". Cars began to pull over to the side, the storm was
Getting worse.
"What should I do." The young lady asked?
"Keep driving," her father replied.
On up a few feet, she noticed that eighteen wheelers were also pulling over.
She told her dad, "I must pull over, I can barely see ahead. It is
Terrible, and everyone is pulling over!"
Her father told her, "Don't give up, just keep driving!"

Now the storm was terrible, but she never stopped driving, and soon she
Could see a little more clearly. After a couple of miles she was again on
Dry land, and the sun came out.

Her father said, "Now you can pull over and get out."
She said "But why now?"
He said "When you get out, look back at all the people that gave up and are
Still in the storm, because you never gave up your storm is now over.

This is a testimony for anyone who is going through "hard times".

Just because everyone else, even the strongest, gives up. You don't have
To...if you keep going, soon your storm will be over and the sun will shine
Upon your face again.

Joke

An illiterate father with his educated son went on a trip.
they set up their tent & fell asleep.
some hours later,father wakes up his son & asks "tell me wat u see"
son: i see millions of stars
father:wat does it suggests?
son:astronomically,it tells that there r millions of galaxies & planets.
father slaps the son hard & says: idiot,some one has stollen our tent...
MORAL:EDUCATION RUINS UR COMMON SENSE...:-D.

Encrypting the Connection Strings & SQL Server Connectivity Issues

Encrypting Connecting Strings DPAPI

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -pe connectionStrings -app /Hari -prov DataProtectionConfigurationProvider

Encrypting App Settings using DPAPI

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -pe appSettings -app /Hari -prov DataProtectionConfigurationProvider

To troubleshoot the SQL Server connectivity issue,
try the following common steps.

1. Check Network:
Make sure the Network is workable and stable when you connect to SQL Server on a remote machine. You can test the Network connection using the PING grogram:
ping <Server Name>
http://social.msdn.microsoft.com/Forums/en-GB/sqlexpress/thread/74a8625f-b5ef-4639-bd7b-c93ed04a376d

2. Enable remote connections for SQL Server:
a) In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click Protocols for <instancename>.
b) In the details pane, right-click one of the available protocols, and then click Properties.
c) To enable the TCP/IP protocol (or named pipes) for remote connections, set the Enabled box to Yes.
<add name='ConnectionString1' connectionString='Data Source=tcp:mblahblah.discountasp.net;Persist Security Info=True;User ID=SQL2005_12345_personal_user;Password=Bilibalah' providerName='System.Data.SqlClient'/>
</connectionStrings>

TSQL - Find date difference between two rows

SQL 2005

WITH TableWithKey AS

ROW_NUMBER
(SELECT tagid, Time_Stamp, () OVER (ORDER BY tagid, Time_Stamp) AS ExtraKeyFROM TAZMReads) SELECT a.tagid, a.Time_Stamp FROM TableWithKey AS a INNER
JOIN TableWithKey AS b ON b.ExtraKey = a.ExtraKey - 1 and a.tagid = b.tagid and

DATEDIFF(Second, b.Time_Stamp, a.Time_Stamp) > 1

http://www.squeakland.org/
an educational tool for teaching children powerful ideas in compelling ways

http://www.skeptic.com/

I will leave something for you when I leave this world,
Few tears in your eyes, my name on your lips & my absence in your life.

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/