Oracle data access with vba

Question

I keep getting a 424 error when setting my con object

Dim con As Object
Dim rs As Object
Dim query As String
Set con = CreateObject(ADODB.Connection)
Set rs = CreateObject(ADODB.Recordset)

strCon = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(jdbc:oracle:thin" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=somehost)(PORT=10080))" & _
"(CONNECT_DATA=(SERVICE_NAME=somename))); uid=uid; pwd=pwd;"

could anyone let me no what i am doing wrong?

thanks

SWa · Accepted Answer · 2012-11-02 15:48:05Z

2

Like this:

Set con = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")

answered Nov 2, 2012 at 15:48

SWa

4,36325 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle data access with vba

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related