Code to Connect Oracle Without any DSN by Using OracleInProcServer

by Raghu (22 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Tue 26^th September 2000
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

API Declarations
Dim OraDb as Object Dim Dyna as Object

Rate Code to Connect Oracle Without any DSN by Using OracleInProcServer




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

Download this snippet Add to My Saved Code

Code to Connect Oracle Without any DSN by Using OracleInProcServer Comments

No comments have been posted about Code to Connect Oracle Without any DSN by Using OracleInProcServer. Why not be the first to post a comment about 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 Comments

Post your comment

Difficulty