Table Problem
Date: Thu, 20 Feb 2003 03:00:42 +0000
Message-ID: <2551473.1045710042_at_dbforums.com>
When I use SYSTEM to login to SQL-PLUS, and then create a user, called
tempUSER, then use the tablespace as tempUSER. After that, I logout
SQL-PLUS, and then use tempUSER to login to SQL-PLUS. Then i create a
table called employee with several fields, and it successful created.
Then i use VB to write a program, use ADO to connect to the database.
Set m_RecordSet = New ADODB.Recordset
Do While Not m_RecordSet.EOF
Debug.Print m_RecordSet!Table_Name
Set m_RecordSet = conn.OpenSchema(adSchemaTables, Array(Empty, Empty,
Empty, "TABLE"))
m_RecordSet.Sort = "TABLE_NAME"
m_RecordSet.MoveNext
Loop
Then why the result is not just display the employee table, it will display a lot of tables, such as some system table. So what's wrong with my Oracle setting, or what's wrong in my program.
-- Posted via http://dbforums.comReceived on Thu Feb 20 2003 - 04:00:42 CET