My current CF project includes ODBC Connections to FoxPro, SQLServer, and Access databases.
These databases are designed and maintained by outside vendors. I merely query them to present information in a friendly format.
What I want to do is programmatically go through the list of ODBC datasources, and document the connection name, database type, tables involved in that connection, and the design of those tables (table name, field names, data types, field lengths, comments, etc.)
End result would be ONE table that includes connection name, database type, table name, field names, data types, field lengths, comments, etc.
My plan would be to to schedule the page to execute on a periodic basis to keep the database database up to date.
So, how do I retrieve a list of datasources set up in Administrator? How do I loop through these datasources to determine the TYPE of database? etc. etc.
BTW, one of my ODBC connections merely points to a FoxPro directory that is chock full of tables. I presume that THESE tables would have to be looped through with CFDIRECTORY or some such thing???
Thanks in advance for any suggestions or pointers.
-Tim
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
