• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Code to Connect Oracle Without any DSN by Using OracleInProcServer

Code to Connect Oracle Without any DSN by Using OracleInProcServer

Code to Connect Oracle Without any DSN by Using OracleInProcServer

API Declarations


Dim OraDb as Object
Dim Dyna as Object




Rate Code to Connect Oracle Without any DSN by Using OracleInProcServer

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

Set OraDb = OraSess.DbOpenDatabase("oracle8","scott/tiger",0&)

' In the Above Command 
'FirstParameter ("oracle8") is the Database Name or the HostString
'SecondParameter ("scott/tiger") is the UserName/Password

Set Dyna = OraDb.CreateDynaSet("Select * from Emp",0&)
for i = 0 to Dyna.RecordCount
   text1 = Dyna.Fields(0).Value
   text2 = Dyna.Fields(1).Value
   text3 = Dyna.Fields(2).Value
   text4 = Dyna.Fields(3).Value

   Dyna.DbMoveNext
Next i