External Data Sources

Hello good people, I need help with this java programm gram doesn't want to connect to FileMaker Pro 14,, it gives out 3 errors as follow: java.lang.ClassNotFoundException: com.ddtek.jdbc.sequelink.SequeLinkDriver java.sql.SQLException: No suitable driver found for jdbc:sequelink://localhost:2399;serverDataSource=Onandjokwe ART;user=DSP10;password=DSP10 java.lang.NullPointerException I have set my classpath correctly i think and now i am confused , anyone please help, I am using Windows 7 Here is my code /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose…

I know this has been asked before and I have read the other answers but am still at a loss so am looking for more help - sorry to be redundant! I have downloaded the mysql connector driver -- after reading http://help.filemaker.com/app/answers/detail/a_id/6420/~/which-odbc-data-sources%2Fdrivers-are-supported-with-external-sql-data-sources%3F and knowing I wanted to make the ESS connection with FMP Adv 14, I downloaded the 32bit MySQL Connector/ODBC version 5.2.5 and installed it into the C:\Windows\sysWOW64 folder. I created a DSN, tested the connection - all is good. But, when I open the local FM db and go to Manage External Data Sources, put in the ODBC name, no …

I have a client that would like to use MS Access to connect to a table in a solution hosted on FMS 14.0.3. What I'm reading suggests that was possible with .fmp5 and .fmp7 but is no longer available in .fm12. I've tried to use Access and both (mac) Excel and (windows) Excel to connect via ODBC to the FMS hosted table and I can construct the query and see the fields, but when I submit the request I get an error. Is it still possible to connect Excel or Access to FileMaker 14.0.3 (hosted)? The error I get appears on the attached screenshot. Is anyone currently doing this? Thank you in advance.

We have one Microsoft SQL Server with two different databases (Test and Production) on it. We connect to these databases with FileMaker Pro 14 with an external data source (ODBC). We have copied the Production FileMaker database to the Test database and changed the DSN settings (which has different credentials for Production and the Test environment!). The new Test environment is still pointing to the SQL Server Production database. How can we achieve that the FileMaker Test database points to the SQL Server Test database and the FileMaker Production database to the SQL Server Production database? The FileMaker Test and Production databases are installed on the same serve…

I need some help. I have a database with id and need to update the name of the current record only from an oracle database. I can connect (odbc) to the oracle database and can import by match, but there are some many records and takes a while. Is there a better solution, like jdbc, or a plugin. Currently using filemaker 14 on windows 7. Please advice.

Hello, If I click on "New Database" Will it do anything to my existing database? I use FM for my invoicing. Now I want to make a database for my equipment list. thanks tosy

Hi, New to Filemaker Pro and ODBC. I am trying to set up a parts database/library for my CAD software, Altium. Altium can read the data through ODBC. I have created a small test database to get started. I have the xDBC driver installed and I have set up a System DSN in the Windows Data Sources (ODBC) dialog. Altium is able to connect to my database, view the table, and read the column names. When it reads the data in each cell, however, it just displays (MEMO) for each cell. In FileMaker, these cells are standard text cells. If I choose a number cell, date cell, time cell, etc., then these work perfectly and I can see them in Altium. Only the text fields seem to have a …

Hi there, I must connect a FM solution to an ERM which I only have access to a couple of views. The ESS is SQL Server 2008 R2. The System DSN works fine without any problem. FMS12 is hosted on a Windows 7 x64 (I know!!). The problem starts when I want to add a view to the relationship graph. Filemaker pops a window asking to choose for a primary key. The view does not have any primary key since it is an aggregation of multiple tables. How can I workaround this problem? Thanks for helping

I'm trying to get a sample offline iOS synch process running and ran into some issues with the file references. I am following the guidelines set out here (FM TechNet doc): https://community.filemaker.com/docs/DOC-3838 My first problem is with the deployment of the Connector file. This file is stored in a container field in the 'deployed' file (the one running on the iOS device in offline mode, i.e. NOT hosted). So this 'deployed' file is running locally, and it contains the 'Connector' file in a container field. This connector file gets exported and opened. Once it is opened, it is supposed to have references to BOTH the locally running deployed file and the hosted…

I am having something odd happen to me while searching an ESS TO. Search seems to work fine in native FM tables however when searching an ESS field the search does not return records that clearly meet the search requirements. I am using the Actual ODBC driver to connect to a MySQL database on Mac OSX. Any ideas what my issue is?

Wim - I got this from something you wrote. Where can I get information (Reading 101 type info - it seems to me that the FM Site has little in the way of worked examples - or im missing something) on the structure of this code? I understand SELECT * FROM myTable WHERE myField = something but what is the ? and later what is the ;"";""; ExecuteSQL( "SELECT id FROM myTable WHERE myField = ? and id <> ?" ; "" ; "" ; myTable::myField ; myTable::ID )

Hello, I am Very Very New to this so please be gentle. I have a MySQL Database on a hosted server. I can connect to it via PHPMyAdmin and I can run very basic SQL Select * From where etc. I have managed to update records in that Db via the PHPMyAdmin. I can create new records and run local scripts to make bulk changes all via the PHPMyAdmin. I have managed to get a FM13Pro connection to the said Db using ACTUAL ODBC. I have created a copy of the table that I am interested in and all of the data is replicated on my MAC in FM. The question now though is: How can I change data in the FM Db that will be passed to the remote MySQL database. So if I update a record locally(…

Hi All, I have need to connect to a Teradata source to view (read-only) or import data into a single table of hosted FileMaker Pro database. Although Teradata provides ODBC drivers for most platforms, there is no such driver for the Mac. Actual technologies makes approved ODBC drivers for FileMaker, but nothing approved for Teradata. Perhaps someone here can share their experience and provide some advice and tips on how to best implement this connection, and whether it is via the unofficial ODBC drivers for other SQL sources, or using the Teradata JDBC. Thanks in advance.

I am investigating interrelating FileMaker and ArcGIS databases. I am from the botanical world and design databases on a simplified level, so please bear with me! For instance, (and this is an over-simplified version) in both ArcGIS and FileMaker, we have a field in our databases which lists a plants status as alive or dead. Both of these databases are available outside, in the garden. We often would like to update just one source, and correct a plant's status in the garden on both systems. This would alter both the ArcGIS and the FileMaker databases, through just one update, probably in FileMaker Pro is my guess. I am imagining this can be accomplished through JDBC…

I've had very little experience with MS SQL Server, but I understand the basic concepts of it. Enough so that I set up a Windows 2012r2 server this weekend and installed SQL Server 2014. I installed it in mixed mode, so that users could use Windows authentication or SQL authentication to access a test database I created. I figured out how to create a user properly so that the test database I created will show up in the Windows ODBC setup System DSN box when I change the default database. However, once I open FMPA 12 and try to add one of my tables to the relationship diagram, none of my tables show up. I've added the same username to Database\Security\Users and made …

I'm connecting the Endicia softare via ODBC to FM 13. I have installed the ODBC drivers, both 32bit and 64bit. The endicia software can see and select the FileMaker Server from the data source, it can also see and select any of the tables on the database, but the field drop down appears blank. Has anyone else had this problem or know why its doing tihs? I'm on windows 7 64 bit and the Server is Windows 2012 R2

Hi there, i have a filemaker database that runs on a filemaker server 13 with a connection to a mysql db trough ODBC. it always worked fine, but recently certain records won't synchronise ( read : import ) because there is a problem with the UUID. in the MYSQL db the UUID exists and in the local file also. but when i try to update the records in the mysql db certain records return an error. when i chance only the uuid of that record, with an other valid uuid, it works fine. a new relation between the filemaker and Mysql db , based on the UUID returns the expected result Any comments or experience ? Regards Ivan

How is it to you to display an external table in a php page? thank you Shmuel

My company has just installed FileMaker Server 13 on a Windows 2012 machine. We've setup a few ODBC DSN sources and I've confirmed they work because I've accessed a few of them via remote clients using ESS in a few of the databases that are hosted on this server. One of the DSN sources is a DB2 source, so ESS will not work. So I was hoping to setup a PSOS that would import from ODBC. So, I was thinking I could run FileMaker Pro client on the server machine, open up the database in question, and then write a script that performs the "Import from ODBC" with the configuration that would work for the context of server. Unfortunately, when I choose "Import / From ODBC" I do n…

I have the .sql script for a MS SQL database, and I'd like to try using Filemaker instead. Is there any way to use the SQL script for the empty database to recreate it in Filemaker, or do I have to rebuild it from scratch?

Hi, I have filemaker solution which I am converting to use the data separation model with a data file, and user interface file. This will be deployed to a number of clients at different sites. However, as this database will be used for research and audit, it is foreseeable to at some point we will want to access data from all of the organisations, and run reports etc. My question is, what is the simplest and most effective way of doing this: 1. Do I use one data file only, and get all of the organisations to add to this? or 2. Do I have multiple client data files and then try and combine these later on. Is there a way that filemaker can access m…

EDIT: Nevermind. Apparently it was a problem choosing the file from the server under favorites; when I went to local servers, selected the server, and then the file, everything worked fine.  Hi,  I've got a couple of solutions both using the data separation model. I was hosting all files on our server, but decided to deploy the interface files on users' local computers. For one, I downloaded the interface file, and edited the external data source from "file:databaseName" to "fmnet:/ourServer.local/databaseName". Once I did that, everything worked fine.  I tried doing the same thing, but that didn't work. I've tried deleting the entry in external data sour…

Hello Board! I hope you're all well into the swing of 2015 by now! I have an External SQL Data source. There is an instance in my RG and I can duplicate it into other instances and read/write to it no problems. But, charting summarised calc fields from it doesn't work. If I import all of the records into a native Filemaker table, these summaries (Not Summary fields, but calc fields) do work. So I'm trying to find a way to automate/script this import. I do not want to go File|Export To|....zzzzz.... process every hour of every day. If I can build a script to do it, that'd be great. I can Copy All Records, but I can't paste them. I can set up an Export script …

Hi all!  I am trying to connect to SQL database hosted in MS SQL server, located in Azure.  My setup: Server - Win 2012 Server, FMS 13 Advanced, - ODBC Driver: ODBC Driver 11 for SQL Server 11.0.2270.0 (64-bit) Clients: - FMSA 13, tried MAC & WIN   Setting up System DNS without problems, test completed succesfully  Added this DNS as external DataSource in my DB.  When trying to add TO to Relationships graph , get the message:  SQL Database & All its Tables and Views shows in "Specify Table" Dialog  "This action cannot be performed because the required table is missing"   I though that the credentials for SQL D…

Attempting to connect to my MySQL database via ODBC but unforunately the DSN is missing so I can't connect (Filemaker 13 Pro) I've searched the forums for the solution and have come across a simular issue regarding 64 bit drivers but I am running a 32 bit O/S (Windows 7) therefore can only install 32 bit drivers. Looking at this post http://forums.filemaker.com/posts/4c08106b66 "To setup DSN for 32-bit application you must use: %WINDIR%SysWOW64odbcad32.exe" however I do not have a SysWOW64 directory. The ODBC connection has been tested and works ok so I am convinced it's FM related. This is the driver I am using - http://dev.mysql.com/downloads/connect…

I have a large microsoft word file which contains URL links. Hyperlinks. I tried to import the links many ways and they loose, their LINKHOOD (the non blue underlying URL) In Microsft word they appear blue and they are active. If I click on a link in this document, it opens a web page but in the address bar it is addressed with what is underneath the visible hyperlink. Is there some way to convert the word document into some way to allow the import of the real converted text underneath the hyperlinks? I need to collect the actual urls so I can use them in an open url script. In their present form they don't work. I tried putting it to excel but there is no change. …

Hello Eeverybody, I am working with FM 11 Advanced Server on Win 2012 Server. Clients are all FM 11 Advanced from both Mac and win platforms. The database we have defined is working fine but we need to open to the web, so a clone of the initial FM database has been created (essentially same TO, and same fields per table) in MySQL 5.4 to be able to add records through the browser with JQuery/PHP. we would like to keep working with FM, using it as an INTRANET front-end of the MySQL database (which would receive data from the INTRANET through filemaker and from the Internet through the web). ESS is working Ok, and we have been able to import shadow tables in filemaker.…

We have a field in a DB hosted on FM Server 11 that contains the URL to an Excel file in a folder on a remote server, and want to import the Excel file into the hosted database to create new records with field matching - via a script. We aren't sure of the best approach. Suggestions would be appreciated. Thanks.

We're using Filemaker Server 11. With ODBC/JDBC enabled. Over the years files have been embedded in the records in containers. I need to be able to pull these into our website so i've connected via JDBC and am pulling files in. http://www.filemaker.com/support/product/docs/11/fmp/fm11_odbc_jdbc_guide_en.pdf using this document as my reference. .ai .zip .psd all come out fine with GetAs(field, 'FILE') .png files come out fine GetAs(field, 'PNGf') But when I try to pull out .pdf files with GetAs(field, 'PDF') like the documentation indicates I should be able to, it throws 'PDF' is not a valid stream name. Of course i've tried 'FILE', 'PNGf', 'EMBO' …

Hi, Is there any way that let me pass some data from Share point to Filemaker and vice versa? Thanks

I am trying to run Execute SQL script to populate a particular field (password) in MySQL table to which FileMaker 13 is connected using MySQL ODBC driver. The driver is already connected and i imported the tables i need, so it works perfect all arround BUT - when i Execute SQL from FileMaker to MySql it prompts me for a username and a password for the ODBC data source and when i import the details similar to the ones i am already using to connect ODBC driver with MySQL it rejects my credentials. I am working on Apple and the database and the ODBC driver are hosted on Windows 2012 Server if this might be important. Could anybody tell me why is this happening and which us…

Hello, I have a FM13 Database hosted on a FM13 Server which has an ODBC connection to a MySQL Database. I could connect my FM13 Pro client to the Database and use my MySQL Tables. My problem is I need to modify/link the Project starter solution's database tables to the MySQL tables but I can't figure out how to do this. Do I have to recreate all the tables exactly like they are in the FM database in the MySQL ?? Is there an easy way to do this?? Appreciate any suggestions/feedback ! Tell me if this is not clear Thanks

I have a few Oracle tables in my file, connected by ODBC DSN. I have noticed that one table in particular is showing an incorrect record count. When you first open the file or change to the layout in question, sometimes the count shows the correct 11,800 records. However, when I do a find that I know should return 4600 records, I get only 230, and the total record count goes down to 8200. Very weird. Anyone seen this type of behavior before?

Hello, I have need to make many calls to our FM DB from our BI software using ODBC/JDBC. I have successfully connected to FM using ODBC, but as we all know, its uber slow. So, after extensive googlin' I've found two good options for our needs; FxPHP or ESS. I've been reading this post about ESS and how I can script a replication between all the FM tables to a MySQL instance. But this seems like a big job. At the end of the day, all I want to do is be able to query or FM data without having to wait an hour for the data to return. Could some recommend to either: Use FxPHP to make calls to FM directly OR Make a MySQL database and use ESS on FM to copy it s…

I am creating a Go solution that uses a hosted filemaker database for syncing only. So they will only use the external connection when syncing records. The problem is when I open my mobile file (on ipad or just on my desktop) I run a loginscript to capture the account name and.. Login Script Step 1: Go to Layout["Service Tech" (ServiceTech)] Step 2: Enter Find Mode[] As soon as step 2 starts i get the following message box The file "Service" could not be opened. (File closed by host) If you press ok then it tries to located the file Service. Well I don't want to open that external datasource until the user initiates the Sync function. This is because most o…

i didnt know how to search for this question or which forum to place it in... im sure you guys will move it... this may be a bit remedial but i cant get my head around it. i have a table of potential prospects that have yet to be contacted. my client sent me an xls of their current customers for me to remove from the prospect database as to avoid a cold call to them and looking stupid. looking to match or cross-reference by phone number, street address and/or company name. my tables phone number field data has just 10 digits throughout and the customer list's phone fields have parenthesis and hyphen ex (555) 555-1212 i know FMP is powerful enough to auto…

I'm having trouble trying to create a table in a FM file using SQL. I'm testing the communication between .Net and Filemaker. The following command returns an error CREATE TABLE customer (First_Name text) Error message [17:59] Erreur ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Bad Column Type: First_Name ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Query Failed Does someone have an idea on how to create a table using SQL command? Thanx

I began using Filemaker last weekend and there seems to be a learning curve for me. I would like to convert a spreadsheet into a data table. With that data table I would like the user to enter a number e.g. year Then have the field automatically lookup a value then put that value in another field. For instance, Year [________] user would enter year APR [________] APR would automatically be generated upon user input. Thank you so much!

OK, so I have two SQL tables in my solution, and overnight the password for the SQL access account expired. I have changed the account to non-expiring and reset the password, but when running the two update scripts, one works perfectly, the other runs instantly yet completes. Stepping through the script, It goes to the SQL layout, and that is empty, so it can't put data from the SQL table into the holding table. Of the two tables (these are in-fact Views) which contain the data (both are correct and contain data on the SQL server), only one of the two is populated. The only change I am aware of is switching the source database table to unicode - could this be the issue? …

Hello everyone! I am a new french user FM and I just put my question here because you are the experts FMP: D I'm sorry if my comments are confused but English is not my native language and I am not bilingual. That, in a nutshell: Can I filter a field as an external table is filtered? Let me explain, I work to show a billing amount based on its category and date, so I used a portal that displays a value (because I am the sum), but it does is not very practical, it's not very "clean" I think. So did I do? I will wish it to apply this filter, but in the section directly without going through a portal. Some people advised me to take a calculated by running a SQL q…

I need a little help trying to grouping like data, but I also need to sum 2 columns of the data. To give you a better understanding I will show you an example of the data I am pulling in: I am running SQL query against our main system and need to generate a report from the data. Unfortunately I am having trouble summing the last two columns and grouping the data, as I cannot create a temp table to group and sum at the end. Because of this, i receive all of the data as single lines from multiple sources. ITEM CODE VENDOR QUANTITY UNIT COST 6 MONTH 12 MONTH Part1000 Bobs Parts 15 $2.00 1 …

I am accessing SQL tables from FMP 12 via ODBC and this has mostly been working fine, except for some performance issues that crop up now and then, e.g., Not Responding appearing at the top of the window for a few minutes now and then, but then it always clears and continues to function. I don't fully understand exactly how the connection operates or the best practices. For some of the connections, I just obtain a total count of the records and the names of all of the fields in the remote table. The remote table may contain 2-40 fields and about 80 records to 150 million records. Since the last time I added one of the remote tables to FMP, I keep getting an error …

Hi everybody, I have trying to combine data from a MySQL source with my local FM database using a shadow table with ESS connector. Basically I have done a Point Of Sale (POS) that gets the data from a MySQL database (it contains the information about the products, prices, stock, etc). I have two problems: 1. I have done an script that connect to this shadow table when I insert a barcode for a product and extract the information about that product. If I open the FM solution and initially run the script, the process is too slow but if I go firstly to the shadow table and then I run again the script, in that case the process is faster. I have solve this problem using…

I have been using Filemaker for many years, but just recently connected Filemaker Pro 12 to a Wordpress database with ODBC and am confronted with trying to extract data from a meta_value field. I don;t have a clue!!! Do I use EsecuteSQL? Here is the example: I have a meta_key of custom_field and the meta_value is a:5:{s:5:"phone";s:14:"(xxx) xxx-xxxx";s:16:"terms_conditions";s:1:"1";s:13:"refund_policy";s:523:"Since Company is offering non-tangible, irrevocable, digital goods; we generally do NOT issue refunds. During checkout, upon clicking the "Submit" button, your purchase is charged to the credit/debit card that you supplied. If you are taking advantage …

Greetings all, I am attempting to insert a record into a Filemaker 13 Solution hosted by FMSA 13 from the context of a MS SQL 2012 Server. Thus far I have been unsuccessful using openquery and also attempting to do a standard insert using a fully qualified db name. I have the linked server setup using the Microsoft OLE DB Provider for ODBC Drivers. The linked server will return SELECT queries successfully. Has anybody had any luck inserting from SQL? Any help would be greatly appreciated.

Hi, i installed MySQL ODBC 5.1 driver on windows server several times before for previous versions of FileMaker and it worked, and still works just fine. Now i am trying to do the same thing on Windows 2012 Server with Windows 8 platform and for FileMaker 13 Server and client, and with the newest driver 5.3. I am installing a 32 bit driver on the 64 bit system in the proper folder (...SysWOW...) as mentioned, everything same as i did previouslly. The drivers are successfully connected to the MySQL database. The ODBC on the FileMaker server is enabled. ISSUE: When i open FileMaker 13 it does not see the ODBC source, the list is blank. I tryed both ANSI and UNICODE …

Wanted to get some opinions as to external sources to speed reporting... We have an FM Server 12 running a few databases with roughly 5 - 7 fm clients (12) connecting. We have a table with roughly 1 million records that is a transaction table. We generate a number of reports that access the transaction table (via relationships), displaying calculated sums ... as an example ... show me all revenue for a certain product for months January through March 2014. We are using a relationship to access the data. so one field will be a "sum" calculation of a Amount field in the related table. Users enter a date range and pk product in global fields in the parent table w…

Why does it take forever to count with this SQL? ExecuteSQL( "Select count(*) From TableName Where kanymd between '20140201' and '20140228'" ;"";"" ) btw, the format type of kanymd is based on Number, not date type. For your information, it doesn't take time at all if I try to Import records via ODBC with the same condition. Also it takes less than a second if I do the same thing with MS Access. Any advice?

A client is migrating their timesheet data entry from FileMaker to 10000FT--a cloud app service for project and resource management. However, we still need to capture that timesheet data in FileMaker, as 10000FT does not have the reporting functions already built out in FileMaker. 10000FT offers an API for web app integration, and their tech support departments promises that 10000FT can push data into FileMaker using their API. Frankly, I'm at a loss of where to start for this though. It seems like I'd need to build a custom web app using the 10000FT API to grab the data and the FileMaker API to push data into FileMaker. But perhaps there's a simpler way to create cus…

I'm trying to connect to MySQL server via ODBC. MySQL views are only open to analyzer such like us. However, it seems most of those views don't contain primary unique key. So it keeps showing the error below. "The selected columns contains some non-unique value.... " Is there any another way to use MySQL data source via ODBC within Filemaker even if the view doesn't contain unique key column? MS Access allows me to do that. By the way, it's hard for me to add id(serial) to view because I have no permission to it. Any good solution?

I'v been using Filemaker for more than 5 years. Most of the time, I was using Filemaker server with filemaker pro as clients. Now, I'm facing the big problem of performance of Filemaker when using ODBC. If I make MS Access to link to external SQL Server via ODBC, it works okay (e.g Just easy search something like A_table.a_column="1" and related_B_table_column<100) However, it seems taking forever for filemaker to do the same thing above. Why does it take so long? Is filemaker supposed to be using with only SQL queries when using ODBC? Can't I just do regular 'find' after bringing external tables to relationship(database management), and make relat…

Help me out guys. The config is as follows: FMS 13 on OSX 10.9. Second machine: OSX 10.8 server running a web server and ODBC connector with a driver recommended in FM's manual. So I managed to do a connection to a database and was able to retrieve some test data successfully, however I immediately ran into a huge problem: all my real table names contain non-latin characters, Unicode if you will, and whilst trying to issue $sql = "SELECT * FROM Genuß"; I get a response: Warning: odbc_exec(): SQL error: [FileMaker][FileMaker] FQL0001/(1:19): There is an error in the syntax of the query., SQL state 42000 in SQLExecDirect in /Library/Server/Web/Data/Sites/De…

Hello all. I'm fairly new to FM, so please forgive me if my question seems stupid. I have a really huge database in FM 12 (let's call it FM1). I also have a FM file, which needs to see some fields from FM1 (let's call it FM2). It's all taken care of in relationship graph (FM1 as External Data Source). What I need is for the user of FM2 to be able to view data from FM1, without being able to alter it in any way. So far I came up with preventing the user from entering these fields in Browse mode, but that seems to me a bit unprofessional (and makes impossible to copy the field). And if it's a way to go, is it 100% foolproof? The user will have to be able to edit, create …

So part of the application that I have been working on uses an external data source (SQL data), but our DBAs arenot keen on using SQL accounts to access data - they would we set up a service account on the AD which can be granted the appropriate access to the database. So I have an ODBC connection, and under authentication, I have three options: 1. Prompt user for user name and password - Not an option 2. Specify user name and password (applies to all users) - this works with a SQL account 3. Use Windows Authentication (Single-Sign-on) - confused as to how this would ever be used? Can someone please confirm if its possible to use an AD account instead of a SQL accoun…

Does anyone have experience making an ODBC connection to an Ingres database, or more specifically, use of the OpenLink drivers?

I have a script that imports several fields from a MySQL DB, including a blob type, which goes into a container in FileMaker. However, it only gets the first 128KB of data from the blob. Any thoughts?

Hello. I wasn't sure where to place this question, but I thought I would start here. I have been developing with FileMaker for about 3 years now. The place I was working had it, but was sorely underused. Self-taught development skills and successfully developed a few solutions for various departments. Recently laid-off and now trying to become a freelance FileMaker developer. I am fairly confident in the intermediate developer skills. Firstly want to get a FM Developer Certificate. But what is a good complementary area to study to boost my chances of getting another job, or improve my skills/marketability as a developer. I would think strengthening my kn…

Hi all, Background: Starting a new job where they are using Filemaker amongst other things. Downloaded the 30 day trial. I went to connect to a SQL database but it doesn't appear as a driver. Go to the site and was given a "trial" driver which is for a Mac. Question: On my laptop at home - Windows 7 - where I have a SQL Server (2008 R2) instance running, how can I connect to it from my Filemaker (trial version) in order to import data?

I need some info from many tables from an SQL system and I have ODBC working and I can use the data through relationships with filemaker commands and almost everything is fine. I'd like to count the records in various SQL tables without setting up relationships and I've tried a large number of variations and searched the posts and web with no luck. For example In a calculation: ExecuteSQL ("Select Count () from Dflt.epCLC_Step3_RAN50";"";"") yields a ? This is a simple table of one field of scrambled IDs, just 50 records. Eventually, I plan to have the table specified by a filemaker field to present record counts for different tables that might be of int…

Using Filemaker 11 Server. I have a server script that is going to several ess layouts based on ORACLE views over ODBC, and exporting the data to excel files in the Documents Folder on the server. A separate database has a scheduled server script to import the data into local Filemaker tables that mirror the ORACLE structure. This works great when the ORACLE server is online, but when it goes offline (usually without notice), the script just hangs (it eventually times out at the time limit I have set on the server). On the client I can do an Open File script step and check for an error before going to the ESS layout, but that script step is not supported on th…

Greetings, My first post in this forum. I am hoping that anyone more experienced than me in FileMaker may have run into this weird nuance when trying to import records into FileMaker 11 on the Mac via ODBC. I have an ODBC connection to an SQL Server database, BETA1. I've confirmed that I'm using the latest ODBC drivers from Actual. In BETA1, there are a series of tables that aren't very wide nor deep, save for a few history tables. I am currently running FileMaker Pro 11 on my Mac. I created a new database. In the Relationships screen, I added a table, Prefix, to my FM database. The table definition appears to mirror what I see in the SQL Server Management St…

Hi Folks. I've been working with filemaker with SQL databases for awhile and need some tips. Basically I use FM 12 to pull in and process data from a large SQL data repository that I have no control over. I run FM 12.3 on OS X Lion on a late 2011 mac mini and use Actual ODBC. The SQL database is huge and is esentially a warehosue for hospital data. I mine a very small percentage of the available data. I am not the administrator of the SQL database and I have very little knowledge of its inner workings. Working with the SQL database has always been slow, but now I am looking to do more SQL queries with more complex data and I find that the queries are just too slow to…

Filemaker docs say to call for a Refresh Window from a script to refresh the data. IT DOESN'T WORK!!! It only works when the script ends, but I need to alert the user ONLY when new data has arrived. AFTER the script runs, then the new data arrives!! My best solution so far is to have the first script install an On Timer Script to call the next script, so when the first one quits, data comes in, and the second one then sees that. Not very elegant! Anyone have a better way?

I am moving a FileMaker solution which been in development for some time from a development database to a production database. (The solution uses an external SQL database.) After building the solution on the development SQL db, I just got my first look at the production db, and discovered something I did not anticpate. Although structurally the same, and with identical table names, the SQL database itself has a different name. Is this going to be a problem? How big? Thanks for any advice.

Hi, My students are developing a project in Filemaker using the separation model. The FM data file connects to a MySQL database. I noticed that when updating a foreign key value on the Presentation layer, the view of the value on the related table does not update. Like if the relationship didn't updated. Eg : I have a "buildings" table and a "building_types" table. There is a field "buildings::fk_building_type_id" which is related to "building_types::id". I am using a layout attached to BLD__BUILDINGS in the presentation layer. In the layer, there are two fields "BLD__BUILDINGS::fk_building_type_id" and "bld_BUILDINGTYPES::name". When I change the "fk" the "…

I need the ability to change external data sources on-the-fly from the front end using a script. Is this currently possible natively in FM13? If I cannot do this natively does anyone know of a third party plugin that will allow me to do this?

Hello Board! I have an external MySQL db setup and working very well. All is OK, except, i'm trying to add another field into Filemaker. I have used the Sync button before and the field just pops straight up, no problem. Today, though, i've had a BLOB field added (so i can have a barcode.png file in that field and print it onto a Layout in FM that uses the external table). It doesn't show. Is this because of the field type? I've restarted FM but i can't restart the MySQL server. Any ideas? I'm stumped, it doesn't seem to be very complicated, it never has been. There doesn't seem to be many options. H

Hello everybody, I have FM11A (client for now) on a WinXP machine where I run also a MySQL server (5.5) for testing purposes. I have a database fully working on filemaker and I am developing a mirror MySQL database to go online. My aim is to be able to perform bidirectional sync between Fm and MySQL leaving the 2 databases as entirely independent entities (so I would avoid to have FM write directly on MySQL tables, i.e. haveing Fm as front-end and MySQL as back-end) I have been able to import the MySQL table (demographics) into the FM database (where another 'demographics' table is present) the 2 tables have exactly the same fields. When I open FM and Im…

I have a database that is stored locally on my computer that has external data sources to a server offsite. I want the database to work "offline" without an internet connection at times. The problem is that when I open the database and filemaker cannot find the external sources (because there is no internet connection), the database takes forever to open. How can I tell filemaker to not look for the external sources? Thank you

I am attempting to use Filemaker as an ODBC datasource in place of MySQL. I am currently running PHP 5.5.3 and am attempting to create a PDO that will utilize the Filemaker ODBC connection. However, I am unable to successfully connect to the database as I am getting an error that says "Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in /Applications/MAMP/htdocs/OMIS/core/init.php:6 Stack trace: #0 /Applications/MAMP/htdocs/OMIS/core/init.php(6): PDO->__construct('odbcriver={Fi...', 'odbc', 'odbc') #1 {main} thrown in/Applications/MAMP/htdocs/OMIS/core/init.php on line 6" I know that the both the Filemaker ODBC Driver and the DSN for…

Using Win7x64 I've installed both 64bit and 32bit ODBC drivers, but from what I've been reading, must use 32bit drivers. I've installed the MYSQL ODBC drivers to test the connection to the external database and it works fine. Also, I can use Import and select this DSN and it works fine as well. Now to FileMaker DSN: Open 32bit ODBC Data Source Adminstrator Goto System DSN Tab and add Filemaker ODBC for host I use the server's IP(it's not local): xx.xx.xx.xx:3306 (port 3306 is used for MySQL access) I can type in the DB name(testing fails here as well) Next: Open Filemaker Open Local FM Solution File->Manage->External Data Sources..add new D…

This is hurting my head trying to remember this far back. I'm trying to put together a test platform for an FM6 application. The current production platform pulls data from a MySQL database (that resides on the same physical server with FM6). The client wants to have the MySQL hosted offsite so I need to test pulling the data while MySQL is installed in a different city/state. It should work but while trying to define the host in the "Import Records" script step I can't get the host to present the tables. I have placed a copy of the entire FM6 project on a separate laptop with FM6ProDev installed on it. On that same PC I have defined a DSN for the new MySQL installati…

Hello My company has two mechanisms by which orders are placed - online and by email/phone. The online orders are retrieved by pulling XML down from a remote server, parsed and ingested into a Filemaker database. The email/telephone orders are booked in through some software which runs on our local server as an MS SQL database. What I would like to do is consolidate both sets of data into one database so that I can view all of our orders regardless of how they entered the building. The online orders have been taken care of, I just need help with adding in the orders from the SQL database. Is the best approach to copy the data into FM and then periodically syn…

Hi, I am currently using Filemaker Pro advanced 12.0v4 in OS Mavericks. I am setting up a database system. One of my requirements is - under a field i need to access a file that is saved in an external server (not Filemaker hosted). Meaning to say, i input a report link under the field and upon clicking it, i get connected to the server and the file required. How can I go about doing this? I have the static ip address of this server and my iMac is running on Wifi. Pls advise. Thanks and Regards Titano

Hello I have a relation on a file located on a FMServer, which is or is not in the network. If it's not, I have a long delay on startup. There is no field from the related database on the start layout. The external data source is defined in File -> Manage -> External Data Source as fmnet:/ip.add.re.ss/filename.fmp12. What would be the best practice to solve that problem? Best regards and thank you for your advice

Now, I'm trying to connect to External Oracle DB Server via ODBC within LAN network. Everthing about setup is pretty much done, and I can see the full list of tables name when I try to add External database in relationship window. I'm almost there! I thought I'm fine so I w-clicked on the target table name but it shows just "ODBC error" It doesn't even describe any detail about what kind of the error is. WIth my SQL Plus, indeed I can connect to the Server. Is there anything that I'm still missing??? or Do I have to do something with Server side?? As long as I can access to Server with SQL Plus, I thought I should succeed. Does anybody know any about this case? A…

Hi All, I've been bashing my head against a wall for a little while now, and really really need some help. I have a Windows 2008 Server, which is running FileMaker Server Advanced 12, and I need to know what I need to install to be able to access an Oracle 11g Database via ODBC. I've tried a couple of downloads from the Oracle website, and nothing has worked so far. I'm sort of fumbling around in the dark as I do not know much about Oracle at all. If anyone knows how to do this I would be forever grateful for some concise information / steps etc. I have removed all previous attempts and downloaded software from my server, so I can start from scratch on…

I have set up an MySQL database as an external data source in Filemaker. When I add a new record to it using Filemaker the Found Count briefly increases by one (for about half a second) but then the record seems to disappear. I can search for, and find, the new record in Filemaker but otherwise I have to close and reopen Filemaker to see it. I know there is a Refresh Window option in Filemaker but is there any way of stopping the record from seeming to disappear from view as soon as it is committed by Filemaker?

Hello Here is my problem: Filemaker Server Adv v11.02, Server OSX 10.5.8, Client FM Adv 11.04 Using XML import, I would like to import data from a password-protected REST-API into my database solution. The database is on the server. Importing the xml data from a file from my harddisk with the appropriate xsl file is working fine, however, over http, it does not work. I tried the user:[email protected] method, but it did not work either (the user is an e-mail address and has an @ sign) and considering safety, this might not be a good method anyway. Is there a solution to this problem, i.e. import xml data over the internet (http) und integrate user and passw…

Can anybody tell me if Filemaker Pro will interact with SalesForce?

Is there any way to send data to a SQL sproc from FM GO? Calling the sproc directly seems to be out since you can't use EXEC SQL from the mobile client. So, I thought we would insert data in to a sql table and feed it to the sproc with a trigger. Then we discovered this nasty problem: http://help.filemaker.com/app/answers/detail/a_id/7870/kw/ESS%20best So, I am out of ideas and turning to these esteemed forums. Any thoughts are appreciated. Thanks, John

I've gotten a lot of help from these forums in the past, but now I have a few specific questions that I need help answering. I know this is long, please bear with me as I'm trying to understand how this works… I'm developing a database that will be used for daily journaling. The development of the database has become complex enough that there are a couple entire tables dedicated solely to allowing the database to function more like an application on the presentation layer. These tables support things like calculations, navigation, controlling a log-in/change name/change password process, displaying an interactive calendar, and supporting the core of the UI functionali…

This is freaking me out - a little. I have a SQL ESS View with 15 fields in it. When I do a find in that table, it produces bizarre, wrong results. For example if i do a CTRL + F find, and type "5" into a field, it produces multiple records where that value is something other than 5. Has anyone encountered this before? I thought it might be an indexing problem, but I confirmed that the field I am using as an index does contain only unique values. The index field is a row number that gets assigned in the SQL query that produces the view. Is that an issue? Any thoughts are appreciated.

Hey Guys, This will probably be straight forward but I couldn't find the answer in my quick searches. I have a database already hosted on my server, and I need to include one of the tables, within it, in another database hosted on the same file. I have tried to create the data source with local file path, but because the referenced database is in use, it gives me an error. I have tried using the local IP hosting address, but because I access the database remotely that won't work. I can obviously use the remote IP hosting address as the data source, but I just wanted to check if this was the correct way (didn't want to cause speed issues). The other way I wanted…

Dear Members, I want to create grouped or formatted reports in excel when I export data from filemaker. ODBC is not an option. I want to use xml style sheet etc to create these reports. Can some one help me to find out some helping material which I can study and produce these reports. It would be great if I could find any sample file and check how it is done. Data grouping and formatting is the main issue. Thanks in advance for your kind help. Tusif

Im using FIleMaker Pro 12 Advanced on Virtual Windows on VirtualBox in a Ubuntu machine, and if I try to open remote it doesn't shows the user login window. The server is from triple8.net The ports are ok for both Ubuntu and Virtual Windows, even I include all of this TCP and UDP ports only just in case: 80, 2399, 5003, 5013, 5015, 16000, 16001, 16004, 16006, 16008, 16010, 16012, 16014, 16016, 16020, 16021 and 50003 but still doesn't open. The ip is ok, it works well by iwp on any browser and FileMaker 12 on other computers on the same network. Wich can be the problem ?

So I have a nice separation model all set up: UI on workstation and data on FM Server 12. Connecting remotely to FM Server is "okay" speed - useable. 99% of my data are just fields and fields with auto-enters - so very few calculation fields. So I could easily convert all tables to MySQL. But how much faster will it be? I can't find an answer (or even a discussion) about this anywhere online. And then the big question for me is... Why use FM12 server at all? Why not just have the UI file (on each workstation) connect directly to the MySQL data using it's own DSN? It would mean I can "define fields" all from the UI file, setting up auto-enters, …

Hi Forum! Hmm unsure if this is the right group anyways here goes: I have a user who has a personal Spelling Check Dictionary file (no news there). Everytime when the user opens Filemaker client 11 and does Open Remote to log onto the FM file hosted on our server 11, the user hasto go into the Spelling Check prefs of Filemaker Client and select the personal Spelling Check Dictionary file. Quit filemaker, start it again and the user hasto do it again...all the time. Filemaker doesnt seem to keep the Setting that the User wants to always use THAT personal Spelling Check Dictionary file. Is this a known issue? Is this normal? thanks forum, Sp…

Hi everyone, We connect to several SQL tables using SQL server (and they reside in our graph). I have noticed that, if the table is moved to another server, FM has no problems with it; I can just change the DSN to point to the new server. But if the external source changes the default DATABASE name, FileMaker cannot maintain the same table occurrence. In other words, there is no way to re-point a table occurrence to a different DSN if the database name changes. Even if I rename it within the DSN, it breaks. FM will create a different source in the tables tab. No matter how I attempt to rename and repoint the existing table occurrence, FM refuses. It seems t…

I have connected many tables from an SQL database to a FileMaker file. This was a test SQL database with fake data and records in it. The real database is an exact copy of the test database-- all the same tables and fields, and views -- just different data and records. Now that I have the Layouts set up like they need to be in the FileMaker file, I needed to edit the External Data Source to point to the real database rather than the fake one. To do this, I set up a completely new ODBC data source on the FileMaker Server that points to the real database. I then went into "Manage External Data Sources" in the FileMaker file. I double-clicked on the data source to…

I have a FM GO layout with a portal. The portal show records from a a SQL ESS table (actually a SQL view) The relationship is built something like this: uiProject = sqlProject uiClass = sqlclass uiType = sqltype The UI fields on the parent side are all global fields set by the users choices. All of this is fine. The trouble comes when I want to add an additional relationship to serve as a filter. uiLine = sqlLine The reason this is a problem, is that sometimes sqlLine is empty or null. So, while I can create the relationship and get the filter to work properly, I can never show all records. The usual way to do this in Fil…

Hi All HELP PLEASE I am missing something here I have filemaker server 12 installed in windows and I have the database with odbc query sql server and on everything works nice on the server side when I open the Filemaker Advanced 12 odbc works fine. and when I chose the import script step and double click the ODBC connection list is there with all of my connections. Inside the company when I go to other workstation I open Filemaker Advanced 12 then I select open remote chose the the database from the server It opens fine I go to file Manage External Data Sources and I have all the ODBC connnections here too. When I start doing a script Like Import a…

I am using FM 12 adv. I need a way to open a user selected file (Filemaker v12) or a way to put that file on the Relationship Graph. Once the user selects the file, I know and have captured the path and file name in a global variable: $$Path. What is the best way to do this? Thanks

Not really sure where to post this. Relates to SQL Server, ODBC/FMSQL and FM Server. I have installed the FM ODBC Drivers on our SQL Server (2005) Machine. I created Linked Servers to multiple FM 12 Databases, on FM Server. I am creating a central SQL Server Table, for some Marketing Data. Same thing as the last post. Just a different approach. Works okay, for the most part. I issued a couple SQL Statements, which overloaded FM Server. Won't do that again but not uncommon in Database World. FM Server is certainly limited on this end though. I have simplified my SQL work to pulling individual tables from FM Server & doing the dirty work in T-SQL. Agai…

Working on a project right now involving SQL ESS tables which are drawn from the client's development database. When it comes time to deploy and move to the live database, is it just matter of repointing the existing DSN to the correct place? I've just had this nightmare vision where I'm re-connecting everything, but that can't be the way it works, because the universe just can't be that cruel, can it? CAN IT??

Running FM 12.4 Client & Server Advanced. Server is Windows 2008. SQL Server is 2005. Running Client & Server on a Virtual Machine. I mounted a SQL Server Table, to consolidate Marketing Data. We have this running in FM. Wanted to keep the data in SQL Server, for various reasons. I am Importing the data from 5 FileMaker Tables into the SQL Server Table. Other than it being a complete dog for perfomance (both in FM & SQL Server), it works well when running from the Client. When I try to run it through a Schedule on the Server, I get Error 100 on the Import. Assume that means "File Not Found". It appears to find the FM Files fine, as I run…

Hello, We need help importing the attached mdb data file into FM12 in Windows. The Detail field is encoded, we are told "4-bit binary" by the nurse call system manufacturer. We had some limited success using the Code function, but all of the characters can't be read. We have played with various ODBC drivers but we are still learning the ins and outs. Any help or direction would be appreciated. -- Jim R4KJun13.zip

I am using Mac OS Snow Leopard and my partner is using OS Mountain Lion 10.8.4. I've attached a document (or other file) indexing FM solution where the user: 1) selects a file 2) an applescript then opens the file 3) the user can then rename the file, creating a new record in an FM database 4) an applescript then renames the file 5) the file path is extracted and placed into an FM text field either (depending on the file path syntax) via a. an applescript that copies it to the clipboard and pastes it into the field, or b. a Get (DesktopPath) script 6) scripts then parse the text field and edit the file path to the correct syntax for FM 7) …

Hi, Currently I am trying to connect an external Data source (actually its a web browser/page) to Filemaker Pro 12. The external data source is connected to my Macbook Pro via a LAN cable. I researched in the net and found out that ODBC is required. I downloaded it and tried to connect but unsuccessful. One of the issues I'm facing is, I do not know what platform the web page is developed from , i.e Microsoft SQL, MySQL, Oracle or Open Office Databases. I could not get the information as its third-party application. So I tried using each and everyone of the database platforms in the hope of connecting through. When I tried using Microsoft SQL and MySQL, after …

I am new to MySQL/ODBC/ESS and I'm on Mac OS X v. 10.6.8 (x86, 64-bit) I installed the MySQL ODBC Connector version 3.51.30 (10.6, x86, 64-bit) from mysql.com (also tried version 5.2.2 but couldn't get it to show up in "ODBC Administrator.app") on my FileMaker Server (version 12.0.1.178). I got to the point where I could add the MySQL tables to the filemaker relationship graph. I can view, edit, and add records. I can edit "int", "decimal" and "datetime" fields without problems. However, if I create or edit content of a field of type "TEXT" (and I also tried changing them to VARCHAR), when I click out of the record it saves only the first character! I can e…