> Using CFMX...
>
> 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]
