Hi folks,

I'm needing to access legacy Advantage databases locally, using the Advantage .NET Provider components (which I must say, are rather good overall!) However, I am trying to find a way to open a table and get it's schema (field names, data types, etc.)

Under standard Microsoft olebdconnection I could use the following:
>>
Dim oRestrictions As Object()
oRestrictions = New Object() {Nothing, Nothing, Table.WorkingTable, Nothing}
goDataTableFields = dbOLEdbConnection.GetOleDbSchemaTable(OleDbSchemaG uid.Columns, oRestrictions)
Dim row As DataRow
For Each row In goDataTableFields.Rows
...
<<

However, the adsconnection component has not equivalent .getschematable function. I am certain there is a work around for this, but I cn't seem to locate it.

Anyone got ideas?

Cheers,
JS