1. DSN Less Connection in VB?

"Server=Oracle; Driver={Microsoft ODBC for Oracle};"

2. Calling Stored Procedures in VB?

1. Calling Simply the Procedure with out Arguments "Call ProcedureName}"
2. If it is with Arguments Means then
Declare the Query Def qy
Set Qy as New Query def
Qy.SQL = "{Call ProcedureName(?

6. How many procedures are in VB?

function and sub procedures

8. Record set types and Number available in VB?

1- Dynaset, 0 Table, 2 Snap Shot.

10. What is ADO? What are its objects ?

ActiveX Data Object. ADO can access data from both flat files as well as the databases. I.e., It is encapsulation of DAO, RDO, and OLE that is why we call it as OLE-DB Technology. Objects are Connection, Record Set, Command, Parameter, field, Error, Property.

Download Interview PDF