Re: On-Line Schedule of Classes -Reply

Angie Byrd (J50AKB1@WPO.CSO.NIU.EDU)
Thu, 22 Jan 1998 15:12:48 -0600

Administrative Information Services puts the data from the
main database into a Microsoft SQL server database. We then
connect via ODBC through Access to the SQL server. We
maintain the Access database locally to increase response
time.

Dave Benham wrote the Cold Fusion program. I believe the cfm
to database communication was not that difficult, but Dave
will have to respond specifically to that one. The larger
issue was manipulating the flat file information from the
main database into more of a relational database.

>>> <sfahey@niu.edu> 01/22/98 02:58pm >>>
In <s4c756ae.039@WPO.CSO.NIU.EDU>, on 01/22/98
at 02:26 PM, Angie Byrd <J50AKB1@WPO.CSO.NIU.EDU> said:

>This interactive search allows a student to query the
>Schedule of Classes based on a number of different
criteria. The on-line
>data is refreshed once a week against the NIU
>central database.

Looks like ColdFusion. Do you use ODBC to connect to the
main database?
Is the main database something other than a Microsoft
product? If so,
was it difficult to get the cfm->database communication
worked out?

Sean