Hi,

I am trying to get the columns from a table in Oracle databse using OpenSchema and MSDASQL provider. The resultant recordset contains the 2 records for each column.That is, if the table has 4 columns, the recordset contains 8 records. However, when I use MSDAORA or ORAOLEDB, the recordset is fine. The code snippet that I used is :


Dim lConnection
Dim lRS
Dim lFieldName

lConnection.Open ("Provider=MSDASQL;Driver={Microsoft ODBC for
Oracle};Server=TESTDB;UID=USER;PWD=TEST;")

Set lRS = lConnection.OpenSchema(adSchemaColumns, Array
(Empty, Empty, "Test"))

While Not lRS.EOF

lFieldName = lRS("COLUMN_NAME")
MsgBox lFieldName

Wend


Any one tried this?

Have a nice day,
Lalitha