Link to home
Start Free TrialLog in
Avatar of ssalter2004
ssalter2004

asked on

VB6 connect to Oracle

I'm trying to connect to an oracle db (10) with vb6.  I have the following code in my form_load(). Note: This is basically code I took from an ASP program I wrote that works fine.

====================
Dim Conn As Connection
Dim rs As Recordset
Dim strDB As String, strTable As String, strMsg As String, strSQL As String

strDB = "AAA.BBB.CCC.DDD"
strlogin = "eee"
strpass = "fff"

Set Conn = server.CreateObject("ADODB.Connection")
Conn.Open = ("Driver={Microsoft ODBC for Oracle};Server=AAA.BBB.CCC.DDD;User Id=eee;Password=fff;")

strSQL = "select prsn_univ_id from dss_rds.sr_bl_hlth_cntr_gt where prsn_ntwrk_id=ggg"
Set rs = Conn.Execute(strSQL)

rs.Close
Set rs = Nothing

------

When I run it I get a compile error with the Conn.Open line highlighted with an error message of "Method or Data Member Not Found"

What am I doing wrong?
ASKER CERTIFIED SOLUTION
Avatar of Carl Tawn
Carl Tawn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial