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 .Connectio n")
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?
====================
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
Conn.Open = ("Driver={Microsoft ODBC for Oracle};Server=AAA.BBB.CCC
strSQL = "select prsn_univ_id from dss_rds.sr_bl_hlth_cntr_gt
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.