![]() ![]() Important If you disable ODBC/JDBC sharing after it's already been on, FileMaker Pro stops serving data immediately. Note Avoid using spaces in the field names of database files you intend to share via ODBC and JDBC, because some SQL query tools don’t allow spaces in column names. For details about supported SQL statements, expressions, and Catalog functions, see FileMaker SQL Reference and FileMaker ODBC and JDBC Guide. Repeat steps 3 - 5 for each database you want to publish.Įach FileMaker Pro database file that is open and set up for access is a separate data source (create a DSN for each individual FileMaker database file you want to access).įor instructions on installing FileMaker ODBC client drivers, see FileMaker ODBC and JDBC Guide. Prevent any user from accessing the database using ODBC/JDBC. Users may need to enter their account name and password for account access defined in the Manage Security dialog box, depending on the setting in the File Options dialog box (see Setting file options). Click Specify to select the privilege set that account access must have to access the shared database file.Īccounts that need access to the database file require the fmxdbc extended privilege Access via ODBC/JDBC. Provide access to users with account access assigned one of the selected privilege sets. Provide access to users from any account. Select the filename(s) to share from the list of open files. See About accounts, privilege sets, and extended privileges for more information.Ĭhoose File menu > Sharing > Enable ODBC/JDBC. To enable or change a file’s sharing status, you must open it with account access that has Manage extended privileges access privileges. As a minimum level of protection, specify account access that requires passwords. Review the privilege sets you’ve assigned to accounts that will access shared database files. Important Prevent data from being inadvertently modified or deleted: other applications can update and delete unprotected, shared data. ![]() ![]() Sharing FileMaker Pro data via ODBC or JDBC (FileMaker Pro only)įileMaker Pro can serve as a data source for sharing your database files with ODBC- and JDBC-compliant applications. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |