Help: Connecting to oracle using VB frontend.

[tthom]

Hi,

I am using Oracle as my database and
Vb and C++ as front end. The only problem is
How do I go about in connecting the Oracle
database with VB using the ADODB.Connection object, using OLEDB. Is there any sites where i can find sample code for this? API? Links? Sample tutorials? ETc? Any help is greatly appreciated. thx

Tim

[moomin]

Dim strConnectString as String

Dim objConn as ADODB.connection
set objConn = new ADODB.connection

strConnectString = "Provider=MSDAORA;Data Source=serverName;User ID=userName; Password=userPassword;"

objConn.connectstring = strConnectString

objConn.open

[rbala_sub]

You can check out oracle documentation for using Oracle OLE objects with VB/VC++

Bala