XSD generator (converts XML to an XSD file)

For those who needs an XSD file and doesn’t have enough time to learn how to do it, you can use the functions in this website to get your xml converted in xsd:

 

http://www.hitsw.com/xml_utilites/

 

 

Regular Expressions Code Template in VBScript

The template below is to be used when you have a string and you want to get date information.

varString = the original string that will be used

iItem = Number of ocurrency (1 = first , 2 = second and so on)

sDate = The date time based on a month retrieved from the original string.

Example: 12345 12MAR 25APR 3MAY (Remember: the months are in English)…

Function CheckDate(varString, iItem, sDate)

    Dim iIndex

    Dim objRegExp, objMatch, objMatches

    Dim sDay

    Dim iMonthChar

    Dim bIsDate

    Dim strMonths

    Dim strMonth

   

    bIsDate = False

    'check if the string contains a month

    Set objRegExp = CreateObject("VBScript.RegExp")

    objRegExp.Pattern = "JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC"

    objRegExp.IgnoreCase = True

    objRegExp.Global = True

   

    'get the matches if there be

    Set objMatches = objRegExp.Execute(varString)

    iIndex = 1

    For Each objMatch In objMatches

        If iIndex = iItem Then

            strMonth = objMatch.value

            iMonthChar = objMatch.FirstIndex

            Exit For

        Else

            iIndex = iIndex + 1

        End If

    Next

    

    If strMonth = "" Then

        sDate = ""

    Else

        sDay = Mid(varString, iMonthChar - 1, 2)

        If IsNumeric(sDay) Then

            sDate = GetFormattingData(sDay & strMonth, False)

            bIsDate = IsDate(sDate)

        End If

    End If

     CheckDate = bIsDate

 End Function

Controlling oracle transactions using VBScript

Very nice sample!

 

http://dev-notes.com/code.php?q=67

 

You can also use Oracle OleDBprovider, it is not mandatory to use MSDAORA.

 

 

How to create/drop/enable/disable a primary key in oracle

Hopefully this link works forever, hahahahaha

 

http://www.techonthenet.com/oracle/primary_keys.php

 

 

Problems with Oracle.DataAccess

Error Message: Could not load file or assembly 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

Platform: .net framework 3.5

Application type: console application

Database: Oracle 10

Language: C#

IDE: Visual Studio 2008.

Yesterday, I finished my console application in C#, I built it and I saw in the Debug Folder, the Oracle.Data.dll. I thought it strange because, normally if the dll exists in your computer you don’t need to install the dll together with the executable file.

And… It’s true! If you don’t have any problems with the dll, you don’t need to move the dll with the executable.

What I did: I just use the Global Assembly Cache Tool (gacutil.exe) - the .net version of regsvr32.exe and that’s it. I restarted the Visual Studio 2008 again and It worked.

The exact command that I used was:

gacutil /if C:\oracle\product\10.2.0\client_1\odp.net\bin\2.x\Oracle.DataAccess.dll

the /if option means that you want to install an assembly into the global assembly cache. If an assembly with the same name already exists in the global assembly cache, the tool overwrites it.

You can find out more about the Global Assembly Cache, clicking here

Error while attempting to create an windows xp user

“The password does not meet the password policy requirements. Check the minimum password length, password complexity and password history requirements. Check the minimum password length, password complexity and password history requirements”.

This error message means that you are not following the password requirements. But how can you find out what the requirements are?

Follow the instructions below:

            Find out what are the password policy requirements:

-         Start >> Control Panel >> Administrative Tools >> Local Security Policy

o       In Account Policies folder, select Password Policy  and you can see the password requirements.

In this way, you can also change the requirements and reduce or increase the complexity.

 

 

Enabling file and directory name completion

File and directory name completion is not enabled by default. You can enable or disable file name completion for a particular process of the cmd command with /f:{on|off}. You can enable or disable file and directory name completion for all processes of the cmd command on a computer or user logon session by setting the following REG_DWORD values:

HKEY_LOCAL_MACHINE\Software\Microsoft\Command Processor\CompletionChar\REG_DWORD 

HKEY_LOCAL_MACHINE\Software\Microsoft\Command Processor\PathCompletionChar\REG_DWORD 

HKEY_CURRENT_USER\Software\Microsoft\Command Processor\CompletionChar\REG_DWORD 

HKEY_CURRENT_USER\Software\Microsoft\Command Processor\PathCompletionChar\REG_DWORD 

To set the REG_DWORD value, run Regedit.exe and use the hexadecimal value of a control character for a particular function (for example, 0×9 is TAB and 0×08 is BACKSPACE). User-specified settings take precedence over computer settings, and command-line options take precedence over registry settings.