Happy Codings - Programming Code Examples

Visual Basic Programming Code Examples

Visual Basic > ActiveX Controls Code Examples

Calling ODBC from ADO to connect to thirdparty driver



Calling ODBC from ADO to connect to thirdparty driver

Dim ADOCN As New ADODB.Connection
Dim ADORS As New ADODB.Recordset
Dim mysql  As String
With ADOCN
'here how to call odbc from ADO!
   .ConnectionString = "DSN=odbc namet;UID=YOURUSERID;PWD=YOURPASSWORD;"
.Mode = adModeReadOnly
   .Open
End With

With ADORS
   .CursorLocation = adUseClient
   .CursorType = adOpenKeyset
   .LockType = adLockOptimistic
   .ActiveConnection = ADOCN
    mysql = "select whatever from my table"
   .Source = mysql
   .Open
'for good preformance, I did store the record set in variant type variable so I can disconnect from host sooner

.ctiveConnection = Nothing
    myrows = .RecordCount
    mycola = .Fields.Count
    mydata = .GetRows()

'now I can loop through my result

Whether entered Matrix is Magic Square
A magic square is a simple mathematical game developed during the 1500. Square is divided into equal number of rows and columns. Start filling each square with the

C++ Codings Store & Display Information
Program stores the information (name, roll & marks) of 10 students using structures. In this program, a structure, student is created. This structure has three members: name ('string'),

Program code to Reverse a Given Number
Take the Number which you have to Reverse as the input. Obtain its quotient & remainder. Multiply the separate variable with 10 & add the obtained remainder to it. Do step 2 again

C++ Codes Linear Congruential Generator
C++ Program to "generate random numbers" using Linear Congruential Generator. A linear congruential generator (LCG) is an algorithm that yields a sequence of pseudo-randomized

C Armstrong Numbers Between 2 Integers
Program Print Armstrong Numbers between two Integers. In case of an armstrong number of 3 digits, the Sum of Cubes of each digits is equal to the number itself. For example: 407

C Codes Calculates the Area of a Triangle
This C Program code calculates the area of a triangle given it's three sides. The formula or algorithm used is: Area = sqrt(s(s - a)(s - b)(s - c)), where s = (a + b + c) / 2 or perimeter / 2. &

File Encryption and Decryption C program
Do not give the have the same sourcefile and destinationfile, encrypting or decrypting, bug will be worked out as I get more interested in file encryption. Decrypt the file with the same

C Insert an Element in a Specified Position
C Program inserts an element in a specified position in a given array. C Programming language code takes a user input and inserts the desired element in the specified position.