When a connection to an oracle database is established, we are dependant on machine by adapting almost of the connection methods. The following codes are independent of many such barriers, as it requires no tnsnames.ora.
 
Private Sub cmdTest_Click()
   
    On Error GoTo Hell
   
    Dim vCn As New ADODB.Connection
    Dim vRs As New ADODB.Recordset
    Dim vCs As String
   
    '''''''vCs = "driver={microsoft odbc for oracle}; uid=scott/tiger@ora9i"
    vCs = "provider=msdaora; data source=(description=(address_list=(address=(protocol=tcp)(host=pc4santosh)(port=1521)))(connect_data=(service_name=ora9i))); user id=scott; password=tiger;"
    vCn.Open vCs
    vRs.Open "select count(*) from tab", vCn
   
    MsgBox vRs.Fields(0)
    GoTo Ends

Hell: MsgBox "Error : " & Err.Number & vbCrLf & Err.Description
Ends: If vRs.State = 1 Then vRs.Close: If vCn.State = 1 Then vCn.Close

End Sub

»»»»»»»   by Santosh Kumar ? Original @ http://santu4you.spaces.live.com 

 
The time required to install an operating system depends on various elements and it differs from computer to computer; operating system to operating system. There are a number of ghosting software that can be used for imaging a drive as well as writing the image back on the boot drive.

I am presenting a different approach, and the steps are as under

1. Install the operating systems ( windows ) in two partitions i.e. make your computer dual bootable
2. Install all your applications on your default operating system i.e. on primary partition
3. Boot your computer from non-default operating system
4. Go to 'Backup and Restore' utility of windows
5. Make a drive back up of primary partition on any of your secondary partition

Now you system is ready to meet any disaster, what you need to do is, just boot from the non-default operating system and restore the backup archive at primary partition.

»»»»»»»   by Santosh Kumar ? Original @ http://santu4you.spaces.live.com 

»»»»»»»   by Santosh Kumar ? Original @ http://santu4you.spaces.live.com 

 
CONVERSION OF DATA TYPES
  v.toString();v.toString(Number2-16)
  parseInt(v); parseInt(v,2);
  parseFloat(v); parseFloat(v,2);
  NaN(NotANumber);

FUNCTIONS
  Definition
    function funName(var1,var2){
      Stm1;
      Stm2;
      return var1+var2;
    }
  Calls
    v=funName(2,5);

ARRAYS
  Creating
    var a = new Array();
    var a = new Array(10);
    var a; a=[20,30,40];
  Resizing
    var a = new Array(5);
    a[9]=100;
  Elements size
    v = arrName.length;
  Methods
    v = arrName.join(); // “1,2,3”
    v = arrName.join(“. ”); // “1. 2. 3”
    arrName.reverse();
    arrName.sort();
    arrName.concat([100,101,102]);
    v = arrName.slice(0,2); //first 3 elements
    v = arrName.slice(2,-2); //3rd to rest except last 2
    v = arrName.toString();

DOCUMENT OBJECT MODEL
  Methods
    clear(); open(); close();
    write(); writeln();
  Properties
    alinkColor
    BgColor
    cookies
    domain
    fgColor
    lastModified
    linkColor
    location/URL
    title
    vlinkColor
    activeElement
    charset
    defaultCharse

OTHER OBJECTS
  history
    history.back();history.go(+/-Number);history.forward();
    history.lengh, history.current
  Math
    Math.abs(); Math.round();
    Math.pow(); Math.max();
    Math.sqrt(); Math.min();

FORMS AND EVENT HANDLING
  onAbort : image
  onBlur : all
  onChange : select, text input elements
  onClick : links and buttons
  onDblClick : document, links, images, buttons
  onError : image
  onFocus : all
  onKeyDown : document, links, images, text
  onKeyPress : document, links, images, text
  onKeyUp : document, links, images, text
  onLoad : window, image
  onMouseDown : document, links, images
  onMouseOut : links, images, layers
  onMouseOver : links, images, layers
  onMouseUp : document, links, images
  onReset : form
  onResize : window
  onSubmit : form
  onUnload : window

COOKIES AND FILE INCLUSIONS
  Cookies
    Storing
      document.cookies = “value;expires=date”;
    Retriving
      v = document.cookies
  <script src=“filename”></script>
  <script archive=“fn.jar” src=“filename”></script>

TIPS ON JAVASCRIPT
  Using with
  Using date
    var v = new Date();
    v.getDate(); v.getMonth(); v.getYear();
    v.setDate(); v.setMonth(); v.setYear();
    1st : 1 to 31, 2nd : 0 to 11, 3rd : Year
  Dialogbox
    alert(“msgStr”);
    promt(“msgStr”,“defVal”);
    confirm(“msgStr”);
  SlyleSheet
    <style type=“text/javascript”>
  tags.H1.fontstyle=“bold”;
    </style>
  Methods for input elements
    blur(); click();
    select(); focus();
  Event handling
    <script for=“objname” even=“onClick”>
  alert(“Hi”);
    </script>
  Displaying message
    status=“type here”;
  Opening a new window
    var w = window.open(“about:blank”, “winName”, “setting”, yes);
    w.methodName();/w.attributeName;
    if 2nd parameter is blank then new window else same window
    if 4th parameter is yes then it will replace the history entry
    3rd parameter : statusbar=yes, fullscreen=yes, height=600, width=400, left=100, top=200, resizable=yes, scrollbars=yes, toolbar=yes, locationbar=yes
  Window timer
    setTimeout(); setInterval();
    clearTimeout(); clearInterval();
  Version support
    <script language=“javascript”>var v = 1.0; </script>
    <script language=“javascript1.1”> v = 1.1; </script>
    <script language=“javascript1.2”> v = 1.2; </script>
    document.write(v);</script>
  Script support
    <script language=javascript1.1>
    </script>
    <noscript>
    This browser doesn’t support ?????
    </noscript>
  Using plugins
    <embed src=file:///C|/1.wav hidden=true autostart=false>
    <embed src=file:///C|/2.wav hidden=true autostart=false>
    document.embeds[Numer].play();
  Using applets
    <applet name=“abc” code=“Abc.class width=400 height=200></applet>
    document.abc.MethodName();
  Printing a document
    window.print(); 
 
»»»»»»»   by Santosh Kumar ? Original @ http://santu4you.spaces.live.com

The following code will be applied only while printing. It will have no impact while using the class for displaying content on the browser.

@media Print {
 .PrintYa{
  display: block;
 }
 .PrintNo{
  display: block !important;
 }
}
»»»»»»»   by Santosh Kumar ? Original @ http://santu4you.spaces.live.com

 
//Description - Calling Function
function PopUpWin(url){
 window.open(url,'','menubar=1,toolbar=0,location=0,scrollbars=1,' + SetCenter(620,485) + ',status=0');
 return false;
}  
 
//Description - Called Function
function SetCenter(Wd, Ht){
 var Lf, Tp;
 Lf=(screen.availWidth-Wd)/2;
 Tp=(screen.availHeight-Ht)/2; 
 return ' left=' + Lf + ',top=' + Tp + ',width=' + Wd + ', height=' + Ht + ' ';
}  
 
»»»»»»»   by Santosh Kumar ? Original @ http://santu4you.spaces.live.com