Languages

System

Application

Script

Database

HTML 4

DHTML

Technology

Client

Server

SB Tools

Protocols

SBuilder

Learning Visual Basic Activex: ADO, RDS & ASP Syntax

Here's simple ActiveX.exe syntax for Math Object:
Public Function SquareIt(Num As Integer) As Integer
        SquareIt = Num * Num
End Function

Call this program with Standard.exe or ASP:
Private Sub Command1_Click()
      Dim X As New Math.Square
      Text2 = X.SquareIt(Text1)
End Sub

Here' s simple ActiveX.dll for ADO business rule. This program access database with ADO either in the Visual Basic or ASP:
Option Explicit
Const MAXCLASSES = 6
Function OverEnrolled(conn As ADODB.Connection,  lngStudentID As Long) As Boolean
     Dim rsEnrollment As Object
     Dim strSQL As String

   'Student cannot add if already at class limit
   strSQL = "select count(studentid) from enrollment where      studentid = " & lngStudentID
   Set rsEnrollment = CreateObject("ADODB.recordset")
   rsEnrollment.ActiveConnection = conn
   rsEnrollment.Open strSQL, , adOpenKeyset
   If rsEnrollment.Fields(0).Value > MAXCLASSES Then
      OverEnrolled = True
  Else
     OverEnrolled = False
  End If
     rsEnrollment.Close
End Function

Here's simple of ASP where database is accessed using ADO technology:
Set conn = Server.CreateObject("ADODB.Connection") conn.ConnectionTimeout = Application("StateUniversity_ConnectionTimeout") conn.CommandTimeout = Application("StateUniversity_CommandTimeout") conn.Open Application("StateUniversity_ConnectionString"), _ Application("StateUniversity_RuntimeUserName"), _ Application("StateUniversity_RuntimePassword")  

Visual Basic can use the technology life ADO to access the data from client side and manage the data from server on the fly.  This technology has made ecommerce very reliable, scalable and secure. Active Server Pages (ASP) scripting with is writen with VBScript is very can easily be integrated with html coding.

Visual Basic also can take the advantage of RDS: Remote Data Services technology.  It can write business rules for ASP to deliver the data to client faster and secure.

However, ADO, RDS and ASP can only run on the Internet Information Server. But any browser can browser the server side scripts. You can not load and run the ADO, RDS or ASP on other Internet servers such as Unix Apache or Netscape Enterprise servers. This means any client can get the servce but only Internet Information Server (IIS) can provide the services.

Visual Basic technology is soley designed for Windows operating system.  The application that you run on the server has to be the Winodws NT and IIS.  But once it is on the World Wide Web it can be accessed by any browser on any system.  This choice is only for the programmers and ecommerce professionals.  However, since it is user friendly and easy to program over 35% of Internet market has already migrated into Windows NT and IIS.

here's my email address

Copyright (c) All Rights Reserved Prakash Bom, Astoria, New York, USA