Subtitles of the Movie

In this movie, we'll conclude our discussion of configuration options for FileMaker Server 9 and FileMaker Server 9 Advanced on the Windows platform. Again, in this instance, we're taking a look at the console running on Windows XP Pro connected to an instance of FileMaker Server 9 Advanced running on Windows Server 2003. We're now in the ODBC and JDBC connectivity tab. The first thing to note is that ODBC JDBC connectivity to a FileMaker Server requires the Advanced version of FileMaker Server 9. But to enable this capability, all we have to do is check the box that says enable ODBC JDBC and what this does is allow access to data in hosted FileMaker Pro files by external applications such as spreadsheets, word processors, reporting tools and a variety of other services. This is a case of where FileMaker Pro is the source of the data. We need to distinguish this and to differentiate it from the new external sequel source capability present in FileMaker Pro 9 and FileMaker Server 9. In that instance of external sequel source capability, the data are in distant, hence the phrase external file, such as Oracle or sequel server and FileMaker Pro is accessing that data and consuming it. We do not need to have FileMaker Server Advanced for that to occur, although external sequel source configuration is fully supported by both versions, both the Standard and the Advanced version of FileMaker Server 9. In fact, configuring the connection from the server enables the administrators to avoid having to install the sequel drivers on all of the FileMaker workstations. But in that instance, FileMaker Pro is consuming the external data and the ODBC JDBC capability shown here does not have to be enabled. The ODBC JDBC capability is for when FileMaker Pro is the source of the data consumed by other applications and as was the case with the various Web Publishing capabilities in the extended privileges section of the file, the appropriate XDBC bit must be checked in order for FileMaker Server to transmit data from that file using ODBC or JDBC. So let's review briefly what we've learned in this particular movie. We've learned that the ODBC JDBC capability requires the Advanced version of Server where FileMaker Server and the FileMaker Pro files are the source of data to be consumed by other applications such as spreadsheets, word processors, reporting tools and other services and that this is distinct from and is to be distinguished from the new external sequel source capability in FileMaker Server 9 and FileMaker Pro 9. In that latter instance, the external data or the source and FileMaker is consuming that data. This option does not require the ODBC JDBC configuration. :03:28] and FileMaker is consuming that data. This option does not require the ODBC JDBC configuration.