I am trying to get a list of tables from an ODBC link (no OleDB driver for this particular datasource - an old Fox pro database). I have an ODBC connection which I can run SQL onto but need something similar to GetoledbSchemaTable. Please someone help me :*( - I'm only 21 and I'm too young to be losing hair from pulling it out over such a small annoying problem
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC table list
- Thread starter Rilez
- Start date
- Thread starter
- #3
Right after pretty much 48 hours solidly bashing my head against this problem I've finally got it sorted. you have to import the old ado routines into asp.net by transforming them into an assemblie. from here you can then use myrecordset = myconnection.OpenSchema(ADODB.SchemaEnum.adSchemaTables) - everythings working now, I'm happy 
)
)- Status
Similar threads
- Locked
- Question
- Locked
- Question