Similar Content
- ByBuckieTried adding an ODBC source using both MySQL 8.0.22 and MariaDB 3.1.10 drivers in Unicode mode and I can connect just fine, however it's impossible to add a table onto the relationships graph. It sees the table's name but when I try to add it, I get
This action cannot be performed because the required table is missing.error. It works fine with ANSI version of the MySQL driver, sans the ability to work with Unicode of course. I've tried multiple combinations, including making the database and the table strictly 'latin', it still refuses to add the table. The test database itself is very simple, just a single table and a single field, no spaces and no unicode characters in names. Test/test/test, basically, tested with an empty FM database. The server is running MariaDB 10.4.16. Any pointers to solve that? - By34SouthI previously used ODBC Manager (32 bit) to great success importing data directly from Filemaker Server to JMP. I recently upgraded to Catalina (MacOS 10.15.5) and knew that one of the casualties would be this ODBC utility. I downloaded the 64 bit ODBC manager from Actual Technologies and successfully installed it but get the following message when trying to open an FM database from within the ODBC interface in JMP:
dlopen(/Library/ODBC/FileMaker ODBC.bundle/Contents/MacOS/fmodbc.so, 6): image not found
I have navigated to Actual Technologies' web site believing I should download an ODBC driver but this comes at a hefty price tag, especially when converted to my local currency. Given the increasing costs of maintenance contracts and SSL certificates I had hoped to avoid further expenditure. Do I really need this and is there an alternative? - ByandyCodlingApologies if I've put this in the wrong place.
My Filemaker solution uses a FM database and an ODBC connection to a MySql database that is used to serve data to a website.
I have complete read/write access to the data in the MySql database from inside FM and thus control of data published on the site.
I would like the MySql database to be able to access tables in the FM database in the same manner.
I have set up an FM ODBC connection to our FM server and that is visible in my local ODBC Manager, have tested the connection and that is good, but I can't see any way in the MySql apps I have installed on my system to create a table in the MySql database using live FM data, in the same way that I can make a table in FM using live data from the MySql database.
Is it possible to do this?
My main MySQL app is SequelPro. And occasionally MySQL workbench and associated tools.
Thank you.
Andy Codling - ByTimPI have been attempting to connect to a SQL database on my network using Monkeybread Software and each time that I attempt to do it I have encountered the same error, which I have attached here. I have set up an ODBC connection as well as made sure that I had the names correct, however I have gotten the same error message each time. Thank you for your help.
- ByHOnzaWhen most of the world is forced to work from home, many things you took for granted can disappear over night. Speed of the internet is one of them, performance of your business critical apps follows very closely. The good news is that most of the custom FileMaker apps out there do not use the full power of the platform and they can be made much faster. So let me share a few tips on how you can optimize your FileMaker apps for working from home over the slower-than-usually internet connection.
Do you know what tools you can use and how you can improve your app's performance to an acceptable level even when connecting from home over VPN?
For example, one neat trick will make everything appear in the Top Call Stats, not just the 25 top calls...
Read more in my article with an inspiring 5-minute video
Who Viewed the Topic
By Brendan McBride Posted on May 9th, 2017 in Free Downloads, FileMaker
FileMaker Server 16 now has the ability to create PDFs on the server! Gone are the days of creating overly complicated PHP setups and unreliable FileMaker Pro robot machines. FileMaker 16 is jam packed with loads of new features, one of the most exciting is it's new PDF capabilities. Here are a few of the great new features FileMaker Server 16 adds for PDFs:
New Features
The FileMaker Data API Engine converts the HTTPS request (URL and JSON data) into a format that the Database Server component can understand, and requests data from the solution hosted by the Database Server. The FileMaker Data API Engine requires that ports 3000 and 8989 be available. I am our systems manager - we utilize FileMaker Server and are currently on FM 16. I am not the database administrator but was wondering how I can manage PHP with FileMaker Server. Previously I was using a PHP plugin for IIS that I could easily upgrade & switch between PHP versions. Is there any documentation on managing PHP outside of IIS?
- Server Schedules & Perform Script on Server (PSOS): Save Records as PDFis fully supported with server side schedules and perform script on server.
- WebDirect: Both Print and Save Records as PDF script steps are supported. Printfirst open a View as PDF dialog, then it will open a new window or tab. Save Records as PDFwill download the PDF directly to the users download folder.
Filemaker Server 16 Requirements
Important Notes
There are a few features that are not yet supported on FileMaker Server when it comes to print forms and a few settings that need to be handled. Here are some points that you will want to keep in mind:
- Fonts: You will need to ensure that any fonts that your print forms use are also installed on the FileMaker Server machine.
- WebDirect Popups: The Print script step for WebDirect is a popup, so you will want to ensure that your users enable popups for your database.
- WebDirect Menu: View as PDF is the only PDF option accessible from the WebDirect drop down menu.
- Server Schedules & PSOS: The print script step is not supported with server side schedules and perform script on server.
- Custom Web Publishing: FileMaker Server CWP will NOT be able to create PDFs, even when running a script using the PHP API. To learn more, read our article on how to create a PDF via PHP on FileMaker Server.
Did you know we are an authorized reseller for FileMaker Licensing?
Contact us to discuss upgrading your FileMaker software.
Brendan McBride
Filemaker Server 16 Compatibility
Brendan is a certified FileMaker and web developer and is a very friendly, hard-working, and technically-astute engineer ready to solve any problem you throw at him. Brendan went to Purdue, receiving a Bachelors in Computer Science and minored in Economics.