para advance saya mau nanya soal koneksi antara vba dan oracle
menggunakan DSN less. berikut adalah source yang sudah saya buat tapi
masih ada error dan errornya adalah object required.
Dim strConnection, conn, rs
Dim strSQL As String
Set strConnection = New Connection
Set conn = New ADODB.Connection
Set rs = New recordset
strConnection = "Provider=OraOLEDB.oracle;Data
Source=192.168.1.234:1521:xe;User Id=viola-0.5.0;Password=123456;"
Set conn.strConnection = Server.CreateObject("ADODB.Connection")
conn.open strConnection
Set rs = Server.CreateObject("ADODB.recordset")
strSQL = "SELECT * FROM AIRLINES"
rs.open strSQL, conn, 3, 3
rs.MoveFirst
While Not rs.EOF
RSWApp.WriteToLog rs("ID"), rs("CODE"), rs("NAME")
rs.MoveNext
Wend
DODB.Connection")
rs.Close
conn.Close
Set conn = Nothing
Set rs = Nothing
End Sub
mohon bantuannya yah :)
