Article ID: 175080
Article Last Modified on 1/8/2003
Dim rdocn As rdoConnection
Dim rdors As rdoResultset
Set rdocn = rdoEngine(0).OpenConnection("", rdDriverNoPrompt, False, _
"Driver={Microsoft ODBC for Oracle}; UID=PSS; PWD=pss;" _
& "ConnectString=TNS:NCORACLE73")
On Error GoTo MyErr
rdocn.Execute ("drop table TESTA1")
MyErr:
rdocn.Execute ("create table testa1 (col1 char(5), col2 char(5))")
Set rdors =rdocn.OpenResultset("select * from testa1",rdOpendynamic, _
rdConcurLock)
Debug.Print "sourcecolumn: " & rdors(0).SourceColumn
Debug.Print "sourcetable: " & rdors(0).SourceTable 'Nothing Returned
Additional query words: msorcl10.dll dated 01/09/97 msorcl32.dll dated 08/21/97 kbVBp500 kbVBp600 kbdse kbDSupport kbVBp kbOdbc kbRDO
Keywords: kbprb KB175080