If the server is on the same computer, you can use "localhost". The server is identified by an IP address or a domain name. That string usually encapsulates various values needed to connect. To connect to a sever, you need to get a connection string. Once you know what type of database you have, you need to know where to find it: But we clearly prefer to skip ODBC as another layer between you and the database server. Still we also support ODBC as connectivity and thus we can also connect via ODBC to PostgreSQL. For example PostgreSQL can be connected directly with the native driver and without ODBC. We support these database types: CubeSQL, Centura SQLBase, DB2, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase.įor most of them we can do without ODBC. Like a solution to manage shows and query from the web shop how many tickets got sold.įirst question is what database you like to connect to. Like have a formula field on a layout to query a number for a value from the foreign table and show it to the user. Then just have various calculations and scripts refer to the open connection and run queries as needed. That is a great way to move a few records in one direction or even implement a synchronization routine.Īlternatively you can have a script to open the connection when the solution opens. You can connect via script to a database, run SQL statements and close the connection. While you can do ESS, we offer an alternative way. Your FileMaker solution may have a need to connect to another database. Connect to an external database server in FileMaker
0 Comments
Leave a Reply. |