External Data Sources

Hello I am using a ESS in FileMaker Pro over a SSH tunnel to a MySQL database (it works really fine!). But sometimes, my SSH connection may drop, by example, because of the network state. I've made a calculation field that ask a value on a remoted single row table, so it could say "Connected" or "Disconnected" whenever the ESS connection is up or not. This could be great for the users so they know if they should reload the file and for scripts to detect that tables are not in a normal state. However, FileMaker seems to cache the value and it does not update when my connection drop. Anybody know a easy workaround? Thanks ! Frankywinky

I'm having some issues with writing a relative path for a hosted, remote file...that should connect to a local file. It seems that a remote file can refer to a local file if the full path is specified, but I've been stymied in all of my attempts to specify a relative path. You would think that simply specifying "file:Desktop/test.fp7" might work, but it doesn't, at least not on a Mac (and neither does "filemac:Desktop/test.fp7"). Anybody with some bright ideas? Since this needs to be specified in External Data Sources, I can't script variables into the path.

I am new to FM9 but not FM. I just purchased the updated version. I am trying to understand how to set up the relationship between FM9 and MySQL after having setup a ESS. It looks like I am able to read information from MySQL and changing them in FM but not exporting them from FM9 into MySQL when creating a new record. Until getting FM9 I was exporting files (FM 8.5) saved in .csv (with a script) and then importing them in MySQL using Navicat. It worked fine. But any alteration of any record in FM meant saving six different files and exporting them in six different tables in MySQL. I thought I could achieved the same result with less hassle by connecting dir…

Hello, I have a php website and want to access filemaker database and show information from that db. System: Windows 2003 Filemaker Server version: ODBC Driver: DataDirect SequeLink 5.5 Client for ODBC PHP Version: 5+ PHP ODBC Library: Installed Web Server: IIS 6 Here are the steps that I've done: - Filemaker server was installed successfully - Our db is installed on filemaker server. - ODBC driver installed. - Created a new ODBC dsn for filemaker server. - Used classical PHP ODBC library to access and query the tables. Everything works fine. But on local development enviorment and local server deployment machine.. When I run the…

I have a "year" and "make" fields in my database both of which have multiple entries in them separated by a carriage return. These fields are matched to a the "year" and "make" fields in our order form and can be used to create a list of parts that we sell for that vehicle. My question is: Does MySQL support the same kind of multiple match field like filemaker? I'm trying to integrate FM with our online store.

Does anyone have any information on the best way to import data into FM tables via an LDAP query? This is in a University situation in which the IT Div is asking us to pull details via LDAP requests, rather than they push data to us via dumps. Anyone know of a way to do this from inside FMP, or a plugin that will facilitate it? Michael

I can easely do this with FM9, but FM8.5 doesnt see externeal ODBC, is there a way to do this?!?!?

Right then, What I need to do is pool together email addresses into a new db from multiple sources. I have some in a seperate filemaker db and some in a mysql database on my website. I have finally managed to get odbc working on my mac and have managed to access that information in a filemaker table. How can I get the email address field from these two tables into the third with it automatically updating whenever a new one is added while not editing the data in either table? I have tried creating relationships between them pointing towards the third table but it is not adding the emails.

Hi I have an .asp site that queries our Filemaker database and it usually runs fine without problems. However about once a day a random user gets the following error ][ODBC FileMaker driver][FileMaker]Query Failed . This error occurs on an INSERT statement on the Set rsInfo = oConn.execute(strSQL). I don't see anything wrong in the code and it works successfully on dozens of instances of the same event each day. Please let me know if you have any ideas or need any more clues. Thank you for your time!

Hi all new to Filemaker and before i buy any software am after a bit of advice. Im looking to design a database which is accessed through a website. There will be 3 different levels of access Customer, Contractor and Administrator. The process is pretty simple to follow see below:- Customer logs fault on website Administrator Allocates fault to Contractor Fault is sent to Contractors PDA where they receive a job sheet Contractor Accepts Job and sets estimated Arrival Date / Time Contractor arrives at property completes job Contractor gets tenant to sign job as complete on PDA and sends data back to website Website is updated as job complete …

It would seem this is something that should come up quite often, but this part of the fmforums isn't too helpful about it. Maybe because it's obvious? Anyway, here my question: My client needs their local contacts database synch with a MySQL database. They have a form on their website for people to subscribe to a newsletter. The newsletter mailout happens via a PHP script on the backend of the website. The client might also enter some contacts locally into the FMP database, and some of those should receive the mailout too. So the two databases should really be one, not least because they might overlap. I have no experience using FMP 9's new External SQL Da…

I went to filemaker and clicked on hosts--> specify host. I added a server name and checked "permanently add entry to host list." I want to remove this server from the list now -- how do I do that? Thanks!

I am trying to create a ODBC connection from a Windows XP Machine to a Filemaker 9 Advanced Server using a DataDirect SeQuel Link 5.5 ODBC driver. I have ODBC/JDBC enabled on the server, but when I run a netstat -an on the server, it doesn't show that it's listening on port 2399. When I try to connect from the client it tells me that the server is not responding. I have the port on the client set to 2399. There is no firewall on the server that would be blocking port 2399. Thanks in advance to any help. Client machine: Windows XP Server: Filemaker 9 advance on Mac OS 10.4

My server has crashed a few times when someone has remotely connected to my FM Server that has been rock solid for prior to switching on ODBC connections. I'm curious if anyone could help me try and determine a cause. As I don't know much about ODBC (my fault there I need to get up to speed on this) and was wondering if there a difference in where the queries or finds are coming from. Is a Find from FM to the SQL db significantly different than a query from SQL to FM. Would one be be more taxing on my server than another? (the SQL file is on a different server) The other thing that is odd is that these crashes only seem to happen when the person is working o…

Hello.. my programmer made a script... not working I have attempted to go File/ manager/ and setup external data sources.. Tried all kind of variations?? Please take a view of my process... i created a video presentation what I am doing.. http://www.mastar.com/Presentations/Camtasia/Problem1/problem1/problem1.htm

Hi Guys! I'm struggling! I have a FM 9.03 Windows Server 2003. I am attempting to drop in some tables from an external SQL server database (on my web server) so that users can dynamically update records on the SQL server. I have no problem creating a System DSN and putting the required tables into the ralationship graph, then creating the link to the FM tables and then updating the required fields in SQL. BUT, it will only work for one user. I can create the external data source in FM I can only crete it with the 'Prompt user for username and password" option because if I try to use the "Specify username.... (applies to all users)" option it gives me an …

Hello All, I have created a form in FileMaker. Most of the fields are Text and wont contain more than 30 characters. I have Date of Birth field which contains a date and a text field which contains telephone numbers. Finally, I have a text field which only stores a text value(M or F) for Sex. What are the most suitable SQL Server equivalents of storing these values? Thanks Jalz

Hi im using in a script, Several "Execute SQL" script steps that connects to exactly the same datasource and does various INSERT and UPDATE operations via ODBC. What i was wondering is if FileMaker makes a new connection for every "Execute SQL" script step even if there is already open connection for the same datasource in the same script? Thanks MF

Hi, does anyone know if it's possible to look and modify an external mp3's ID3 tag data natively within Filemaker? I maintain my own karaoke database and want to be able to read and write back the tags according to a look up on my database. If not natively, then with a free plugin?

Hi, I'm a SQL and FM newbie. I am developing an online web shop using CubeCart. CubeCart uses MySQL with tables for inventory and categories etc. For development I am running CubeCart on my localhost. I have managed to establish an ODBC connection to my CubeCart database and can access the fields using FM Pro in selected tables. With one of the tables I am encountering a problem. The first field cat_name is displayed however the contents are not. When I enter a value into this field the CubeCart SQL database is updated as expected. However the field contents in FM Pro returns to blank on record commit. In the SQL database the field in q…

I'd appreciate any wisdom on the best way to structure a MySQL/FM 9 solution. Is it best to always copy the MySQL raw data into FM9 or is that unnecessary and an acceptable/safe practive to use the "live" data and utilize FileMaker's feature set to extend it? Thanks!

I installed FileMaker Pro 5 on a Windows 2003 server. I would like to create a schedule task to run every night and import data from another database via an ODBC connection. However, when I go to Import, the "files of type" list does not have "ODBC sources" on the list. Do you know why it would be missing? I've installed FileMaker Pro on many workstations and it is always there. Thanks in advance for the help!

Howdy, all, and happy holiday season. I'm re-engineering an already-written solution so that all the data entered by a user is stored in an external FM file, instead of locally, to make upgrading the solution in the future easier for all concerned. So, I'm looking for a "best practices" way of doing this. Suggestions? One problem I've run up against is creating a record in the host file which must create a new (related) record in the data file. Portaling everything isn't the answer, so what is a good way to handle this? Creating summaries is another problem: am I stuck creating those in the data file since I can't designate an external file/relationship wh…

Just can't figure out why my "Select ODBC Data Source" Box in filemaker is empty?? Thanks

We want to dump some data from FMP into a MySQL table that is used for reporting by other applications. To do this we: 1) Add an External Datasource that connects to the MySQL database. 2) Create a table occurrence that is bound to the MySQL table. 3) Write a script that loops through all the existing fmp records that we are interested in and does the following: ---- Create a new record in the MySQL table occurrence. ---- Set the fields. ---- Commit the record. The table is relatively small, maybe 10 fields. The error we are encountering is that when we attempt to run the script, FMP throws an error that it is out of memory,…

Hello everyone, I'm quite new to Filemaker i have used it and i might use it again for my ne business. I'm looking for some information on software for to manage holiday rentals. At the moment we are using access which is....... We are making a new website using Joomla. We need CSV format for that. Now there are some suppliers of software for rentals but i'm looking for one who programmed it in Filemaker? Does anyone happen to know if it exists? Btw. I was not exactly sure were to put this post in the forum. Regards, Peter

I'm using mySQL ODBC to import a table into Filemaker. Some of the strings contain newline characters ('n'), and they don't import properly -- I'm not sure whether they're translated into blanks, deleted entirely, or what, but they don't they don't survive as newlines. I can use mySQL functions to translate this character into something that works, but - what will work? Thanks, Chap

Has anyone installed the CLIENT Sequel Link drivers on Windows Server 2003 which was hosteing FileMaker Server Advanced 9? The idea is to create a system DSN on this machine and then point all the clients to this DSN, hence alleviating the need to install the FM ODBC driver on each client. Thanks Jalz

My Situation: I have already many products registered into my filemaker database each of these products have a price and this info in a SQL Server. How can i link each price to each already filled record? So i need to import especific data from especific fields from sql to each of my already filled records in filemaker. What i need is kind a link between each field of each record to each one in SQL. Is that possible?

I am trying to insert the result of an SQL query into a field in FMP 9. Here is my SQL statement (which produces the correct result): SELECT count(*) FROM smart_cd.USAGE_SAS WHERE FTR_SERVICE_TYPE = 'C' I can run the SQL query in a script using "Execute SQL", but I can't figure out how to send the results to a field in FMP. I don't want to hard code the value of the field to equal the SQL statement (as in a calculation), as I want to be able to retrieve this information at will. Any assistance is appreciated. Thanks, Tony

New issue now involving SQL 2005 data format. Im importing data from a Sql 2005 database based on a time stamp field. If I duplicate a simple query in crystal 9 the WHERE clause reads ("Material_Trans"."Material_Trans_Date">={ts '2008-10-01 00:00:00'} AND "Material_Trans"."Material_Trans_Date"<{ts '2008-10-01 00:00:01'}) Which gives me all records with a date of 10/01/08. I can not find a way to pass this date in the given Sql format to make the query work. I have been able to make it work in an access database by formatting my Filemaker field like this #10/01/2008# and passing this to my Sql statement I am really under the gun now all our mission critical repor…

Question: How hard would it be to synchronize the data between Trac (http://trac.edgewall.org/) and Filemaker Pro 8? I have never used Trac myself, I have used similar adaptations of Trac, and really thing it could benefit my company. One of the services we offer is 3rd party support for server systems, and our engineers are on call 24/7. Perhaps it would be worth it for them to use a system like Trac for interface with our engineering databases. I could not find anything on the web after doing a brief search Regards, - Mike

We recently migrated from an Access database to SQL 2005. When comparing the syntax I see queries are now different. Access Example < SELECT `Customer`.`Customer`, `Invoice_Header`.`Open_Invoice_Amt`, `Invoice_Header`.`Due_Date`, `Invoice_Header`.`Document_Date`, `Customer`.`Name`, `Customer`.`Sales_Code`, `Address`.`Status` FROM (`Customer` `Customer` LEFT OUTER JOIN `Invoice_Header` `Invoice_Header` ON `Customer`.`Customer`=`Invoice_Header`.`Customer`) LEFT OUTER JOIN `Address` `Address` ON `Invoice_Header`.`Customer`=`Address`.`Customer` WHERE `Address`.`Status`='Active' AND NOT (`Customer`.`Sales_Code`='Edmar' OR `Customer`.`Sales_Code`='EMI') OR…

Hi All, I'm a newbie in FM and I'm beginning to find my way in it but now I'm facing an obstacle I can't overcome. I use a SQL Server database as db and FM as GUI. All is working fine, I even found a workaround to the problem of the valuelists. The problem I'm facing now has to do with the SQL Server 'DateTime' field. In FM there is no such field which causes a problem when a user needs to enter that field. The user can't just enter a date but also needs to enter the 'time' part of the datetime field. Is there a workarround for this? I searched the web but I could not find a solution for this. I'm thinking of creating a popup window where the user sel…

Hi, I'm wondering if there's a way Filemaker can interact with a MYSQL database that is hosted on a remote web server and if so how? My website isn't hosted locally. I can only access the MSQL database through a PHPMyAdmin portal that the hosting company made available for me. Any help would be appreciated. Thanks

Hello! is anyone using FM connecting with MySQL 5, on a shared MySQL-Server from your internet-provider? Do you have good response times? I never found anyone talking about poor response times... I have: 3 FM Clients (Windows, OS X) SQL-data on a shared host connecting: with MySQL ODBC 3.51 xDSL: 2048/512 I have a small database with customers, and often - usually after a longer break -, when we go back to work and click on any field of the current record, FileMaker starts a "Search" and needs 15 to 60 Seconds to be able to edit the current record again. I have no idea, why sometimes it‘s possible to go on immediately and sometimes he ne…

To simplify the issue lets say I have a table in sql called "customers" and it only has custid (serial, primary) and firstname. In FM I have the same two with the relationship being custid. I can import just the custid and it will fill in firstname with the proper data - so all is well. If I create a new entry in SQL (with a new custid) I can simply type the custid into the field and the correct data will show up. What I'd like to do is when a new custid is created in SQL that it's automatically shown in FM. I hear this is possible but without doing a looping import or a portal I can't see how. Any ideas?

We are currently doing some testing with ESS. We have a couple of MySQL tables added to a fmp file. Is there a way of capturing the sql query statement when i do a search within filemaker? Any help would be appreciated. steve

The FM knowledge base shows that SQL Server doesn't have a corresponding entry for DATE or TIME fields (all other variants of SQL do, however!) So, how do I handle the SQL field if I only have a date, like a transaction date, and I want to update the SQL field. Conversely, when I read the SQL field will I only get the date part back into my transaction date? Will I need to redefine my transaction date to be an FM Timestamp. If any one can give a "heads up" on similar items then that would be great.

Check for file or host availability Hi, I'm trying to make a script that checks if a filemaker file hosted on my office network is available or not. If it is the script continues and imports a few records. If the laptop running the script can't see the office network (the laptop is not connected to the office network) the script should stop. What's the best way to implement this? The File hosted in the office network is described in the External Data Sources as: fmnet:/internalofficeservername.ourdomain.com/OfficeFile The name internalofficeservername.ourdomain.com only resolves internally (there's a record in our internal dns server, but not on our exte…

Hello, I need to access data in FM from SQL Server 2005. For example, I can need to copy data from FM table to a SQL Server table. Thanks in advance.

Anyone managed to install the ODBC on the server instead of client based machines? If so, how did you go about referencing the database from client machines.

i am using ODBC connector for connecting SQL database to the filemaker solution to import export the data. when i am installing on the Tiger it is working fine but when comes to leopard it is giving me an error as ODBC Error:[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded

Hopefully this is a simple question... I have a main sales database full of accounts and sales. This was designed to simply keep track of sales based on who/when, etc. Now I've added an external file that is a database that handles invoices / payments. In the main database, I reference this file as an external source, allowing me to show transactional data for each account. In the invoice / payment database, I reference the main accounts / sales file as an external file. I need this to lookup sales details based on sales for invoice creation. I know this isn't much different than having 2 or more unique table occurrences in the same file, but I'm not …

Hi there, I'm developing a c# window's solution with an interaction with a filemaker's odbc connection. This application may send some sql request on inexistent tables or columns. Is there specific code or message in the filemaker's reply? My goal is intercept this code, message to make an identification of the error's type and write a comprehensive message to the user. [edit] I find a code and a message send by mysql. for a unknown column, filemaker says Message "Error in Result Column" SQLState : HY000 NativeError : -203 The SQLState is always the same for the different kind of errors (HY000), but the NativeError number changes. …

Does ESS in FileMaker 9 fully support the lastest releases of MS Access? I don't want to just import data from Access through ODBC but want to use it as a data source through a shadow table to get data on a regular basis. Thanks, for the help. I've been reading about ESS support for Oracle, MS SQL Server and MySQL but not much on MS Access apart from importing.

I have just found out that FM v9 supports MySQL as the back end database. I am trying to figure out how to separate the data from my FM application to facilitate updates and make the solution easier to manage overall. Is this the way to go? If so, how do I take my existing FM application/data and "port" it over to MySQL. I just watched a demo of how to creat a MySQL database using FM from scratch, but how do you take an existing database and move it to MySQL?

I have an FM9 solution hosted with FileMaker Server 9 Advanced on a Windows Server 2003 platform. As such, I set up an ODBC connection on both my dev box and server box to an internal Oracle database. The Oracle table I wish to connect to contains over 700K records, so ESS is very slow. I'd like to execute SQL queries instead. The SQL queries I wrote on my dev box run correctly. When I connect to the server version of the FM database, the server's ODBC connection is not available, so the queries don't run at all. Can FM9 Server not use the server box's ODBC setup? I'd rather not set up individual ODBC connections for the hundred or so users. TIA ken

I hope someone can help! I have the following SQL Query (which works fine) select * from invoices where inv_date >= '01 Jun 08' and inv_date <= '30 jun 08' However I want to parameterise the two dates with global date fields stored in FileMaker 6, in a database called 'dates' (saves manually changing dates at start of every month). The query would then look something like: select * from invoices where inv_date >= '&&start_date_global' and inv_date <= '&&end_date_global' This is where I get stuck! How do I make the FileMaker 6 database 'dates' (and the two fields 'start_date_global' and 'end_date_global') be vis…

I’ve been trying to create an ODBC link to Filemaker 9 Pro on my Mac here at the office to build some quick printable reports in PHP, but the ODBC set up has been killing me. I’m wondering if you have any ideas or solutions as to my problem. I’ve followed the documentation included with Filemaker perfectly (I think so, anyway!), set up the ODBC driver off the xdbc folder on the Filemaker CD, opened Filemaker, and shared the database. The error that is returned after I do an iodbctest is clearly a driver error: Enter ODBC connect string (? shows list) Driver=Sequelink;DBQ=AlturaDB;UID=admin;password=XXXXX (masked, not sic!) 1: SQLDriverConnect = [iODBC][Driver …

I was wondering if it is possible to migrate a table from FM9 to MySQL with minimal effort in FM. This table has over 300 fields and a lot of relationships. The purpose of this is to normalize the data in the table without rewriting the whole FM app. Can I create a view in MySQL that matches the order and names of the fields in FM and replace the FM table with a MySQL View? What steps are needed to make this work in FM?

I have an interesting problem. I have to connect a Filemaker database to an Oracle 10g database (Banner). The ODBC drivers are set and tested and they work. When I attempt to make the connection through Filemaker Server, it gives me an Oracle error (ORA-12154 which means that there is a problem with name resolution). On a hunch, I closed the database on Server, and opened it in Filemaker Pro 9 client and I was able to make the ODBC connection without a problem (I did this on the same computer). Any ideas? Everything that I have read indicates that you only need Server Advanced to have an external system connect with Filemaker but ESS does not require Server Advanced.

So i am trying to integrate an FM database and an SQL database. We have an online database that stores our user infomation. We have a FM database that will keep some offline data, but mostly use it for queries and print layout for mailings. My issue is how to deal with the sql structure. The structure is as follows: Each piece of data is stored in a table containing three fields: Each data pieces is a new record UID (userid) FID (identifies what the data is (last name, first name, address etc.) Value (the actual data) I am trying to get filemaker to search these records as if they were fields. I can display these in a portland but cannot get them to…

Has anyone run across FMP/FMS creating odd SQL Select statements when using ESS via FMS? Here's a quick version of what I'm doing: Filemaker Server 9.0.3.325 (Windows Server 2003) System DNS created using default SQL driver Filemaker Advanced 9.0v3 (Windows XP) I'm trying to use invoice number in both tables to match and create a relationship. The relationship works, but is very slow and the SQL statements are not as simple as they could be. Simple SQL Example: SELECT Field001, Field002, InvoiceNo FROM [sql_Table] WHERE (InvoiceNo = '12345678') Here's what FM is creating: SELECT Field001,InvoiceNo,Field002 …

Greetings, I've hooked up a mysql table to fm9a using the actual technologies opensource drivers. I can see the first record in filemaker but no others. Any ideas on how to proceed? Thanks Pete

I'm making a layout that I want to link to other databses (external data). However, I don't want all these other files being displayed in the Remote Connection display. How do I hide the external data and display only the 1 file? (Similar to Job Pro Central's Home page and other databases)

I am having a problem when opening a file in Filemaker. When I open it, it comes up with a message saying "This action could not be performed because the required table is missing"... when I press OK, it presents me with my correct data. How can I get rid of this message popping up every time that I open this file? I have created many files through Filemaker and have never had this message appear, and I am not sure what I have done differently. I would really appreciate some help on how to get rid of this message. Thanks YKB

I'm installing a database that is hosted on an internal LAN. I will be using Server, but it won't get installed until next week. I'm testing the db by having it hosted by a regular old copy of Filemaker 9A. The solution has two files, a main file and a photo file. I've opened the main file which opens the photo file (a hidden window is present under Show Window), but when I try to open that file from a client machine, I get an error saying the photo file is missing. Any ideas of why the second file isn't showing? Thanks, DJ

I am trying to not have to recreate all my table in mysql. My table have no data in them, so the data is not an issue. What I want to do is some how have mysql read my database and create my current tables. This would save me from having to recreate and retype every field. [color:red]Any ideas on how I can do this?:?

Hello everybody. I have FMPRO 9 ADVANCED and SQL SERVER 2000 which is running on a WIN2003 Server. I've setup the DSN for a specific DB in SQL SERVER, but when I try to bring the Shadow table to filemaker relationships graph I can see the Tables of SQL SERVER but not the fields inside the table. Pls Help

Hi, I am using FM9 on OSX. I tried adding a record to a sql database from a filemaker file using the "Execute SQL" script step. Though this works and the record gets updated in the external SQL database it gives me a error message every time. The error message I get is: ODBC Error: [Actual][sql Server] Executing sp_notify_necropsy_results... The related contents in the log file is: FileMaker Pro A06E5FA0 EXIT SQLError with return code 0 (SQL_SUCCESS) SQLHENV 0x1fb70a90 SQLHDBC 0x1fb07c90 SQLHSTMT 0x1fadd170 SQLWCHAR * 0x1fb5ae10 | 01000 | SQLINTEGER …

Hello, Please forgive me, this is my first attempt to use FMP as the source for ODBC data.... I am using FileMaker Server Advanced 9 and am trying to connect a Employee ID Badging machine / software to my FMP database. I think the software is called ID Works Automation or something. Anyways, in the application I am try to connect the fields and it always gives me a message: "Incompatible Data Type" . The only data type options for ID Works is text, photo, date, and signature. I am trying to connect something as simple as name and it gives me the error. Dates connect, but not simple text fields.... it shouldn't matter if it's a number because the field is st…

Filemaker 9 Adv. I have an order enter FP7 program, and I want to integrate a working FP7 inventory program so that people can open a window, pick an inventory item to be added to a quote in the order entry program. In the Order Entry program I added the Inventory FM file as an external data source. I added the tables from the inventory program to the OE program (but not all the relationships defined in the Inventory program, nor the layouts). When I open a window to the inventory program (calling an open script from the inventory program in a new window) from the OE program, I can select a record, and script the fields to variables. To do this, I have created a …

I'm stumped -- i got mySQL ODBC working great on my Vista machine -- FMP talks to the mySQL db great. However, even though I made sure to hand edit the mysql odbc ini file on the FMP Server to connect, it gives me a link error. Any one else have this issue? Firewall?

Hello, I recently found out that a special printer / software program needs to access my FileMaker database. I'm running Server (not server advanced), so there is no ODBC feature (right?). I do, however run a copy of FM Advanced. How can I get this special software / printer to call to my Filemaker solution without ODBC through server? Is my only hope to get Server Advanced?? V

Hi there, First off, I'd like to thank everyone that contributes on here, I've found some great answers in the past. I'll try my best to explain this problem, if there's any tests or anything I can do to get better info about the problem, just let me know. Running FileMaker Pro 9.0v1 on Mac OS X 10.4. Basically, I have a brandspanking new version of FileMaker Pro 9. I have used FileMaker Pro 8 previously, to build an order management system for a small business I run. All pretty straightforward, calculations, invoices, some custom contact sheet-type print layouts, some basic scripting etc. I am now trying to use FileMaker Pro 9 as a sort of front-end t…

This is a totally new area for me: How can FileMaker open and import from a SQL View Table? Any hints into the right direction would be appreciated. Cheers Greg

I'm fairly new to using mySQL as an ODBC data source for FM. Can I create tables on the mySQL side and define the fields directly in FM? And if so, how? -cauri

Hi guys, I'm working on this database and i need to get data from my vb.net code to the fmp database... i was wondering if there is a way to program my program to automatically import the xml data to the FMP database... thanks in advance, Euka

I'm in a test scenerio with FileMaker 9 Adv, and FileMaker 9 Adv Server. I have my Layout populated with live SQL fields. One of which is a 'Delivery Date' field. With SQL being the back-end if I enter in "7/9/2008" it yells at me saying that it wants the format to read "7/9/2008 12:00:00 AM" or something to that extent... Is there a way I can do a Validate by Calculation on that field so if the user enters in just a date without a time it appends on a "12:00:00 AM"? I'm at a loss here.. This could be a deal breaker for me using SQL Server as my back-end. If I'm going to require the end user to key in a time along with their dates it's just not practical. …

I was wondering if there was a script that would allow you to export from Filemaker to an ODBC. I would export to a file but the data I need to xfer is image files. Thanks in advance. matt

Hi! I am using jdbc to get data out from Filemaker in a "batch" kind of way, many SELECTS in a row. It workes fine until about 200 of my 1000 things to is done. Then I get: SequeLink An Internal Error has occured. What is this and how can I fix it? Its the same questions to the database over and over so If it can do 200 it must surely manage 1000? Can anyone help me plz!!

Hi! I have a problem using jdbc drivern sljc that comes with Filemaker. Sometimes when I do resultset.next() in java it gives me interan error. Is this a known Issue? Is there a way round it? Regards Joakim

Hi, I'm trying to setup a configuration using ODBC sharing. I'm running advanced server 9.0 on OS X 10.5.2. My idea was to share information with Windows PCs. Sorry for such a basic question, but where can I find the SequeLink driver for Windows; is it available on the original CD? It seems that the Mac version only ships with a Mac ODBC client; am I wrong? Thanks for you help, Guy

Greetings. I've been going through some FM9 Pro tutorials on lynda.com and have been able to setup a ODBC system DSN with Actual Technologies plug-in that connects to our mySQL database, but it's connecting in real time (which is very cool), but the solution needs to 'import' those live records so that if any from the mySQL database are deleted, I still have that record locally. When I try to set up a USER DSN FM9 Pro doesn't see that external ODBC connection. Can I configure a System DSN to import the records? I'm using OS X.4 Thanks in advance.

I have 150K items in a main table. I need to create another table called "item properties". This will contain information that is specific to the items but that doesn't need to be in the main table. I made the table and arranged the fields therein and created the relationship. I then exported the main field "model number" and imported it into the new table. Now the ITEM PROPERTIES table has all the same records as the main table. However, when I create a new record in the main table, It does not automatically create one in the ITEM PROPERTIES table. How can I automate that. I am not the only one entering records. Thank you

Hi, How can I use SQL INSERT/INSTEAD-OF INSERT triggers with FM9. Filemaker 9 accesses SQL Server 2005 database via System DSN. Only views are visible to FM9. I get an ODBC error when trying to create a record in FM when the underlying view has an INSERT or INSTEAD OF INSERT trigger. Looking at ODBC tracing I see that FM is trying to execute: "INSERT INTO tablename(column) OUTPUT INSERTED.ID VALUES('Joe')" which is illegal and therefore results in error: "The target table 'tablename' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause". Apparently FM is not using the INTO clause which is…

If we have an FM5 application already in use and want to switch everything over to mySQL, is PHP capable of accessing an FM5 database? When we try to come up with it (because we're trying to figure out how to export all the fields in multiple FM5 datasets), mySQL reports "Cannot find structure". Please note: We are unable to export using FM5, just won't do it because FM5 crashes right after a full export is requested. Tried 150 times. So now we're trying a back-door approach. I think FM5 is so ancient, this is doomed. But what do you good people think? I think if we could get in with PHP talking to the FM5 dataset, we might be able to set up a program to str…

I have a SQL server database of students in the college. I am using FMP9 as a GUI front end to access the data. Created a form that shows studentID, name, gender and locker number. I have successfully connect to the database and had success in updating the gender field in the student student table. When attempting to update the locker number field in the same table, FMP returns an ODBC error with no further details. As far as I can see, this fields have the same attribute(text and no links to any other table). Am I doing something wrong here which causes the update to fail?

I am planning to include an ODBC Installer in our windows application that adds information to our FileMaker DB from different users around the globe but encountered a problem, how can I make a DSN-less connection? there are a lot of suggestions that was pointing me in using RDAC but we are using FileMaker 8.5 and I have read from "www.filemaker.com/downloads/documentation/fm8_converting_databases.pdf" that 'The Local Data Access Companion (LDAC) and the Remote Data Access Companion (RDAC) are no longer supported.' in I think, versions lower than Filemaker 7. I have found this DSN-less connection in several resources but it requires RDAC: (FileMaker's Remote Data A…

Hi Everyone, I'm a newbie both to the forums and to Filemaker. As with a lot of people on the forums, I'm making a move from MS Access, etc to FMP. Here's my situation... we're making a move from MS Access and Windows to OSX and FMP. As with every transition, we need to have the ability to use our DB's and apps on both platforms for a while. I'm starting the redevelopment of our systems from Access to FMP but have run into a problem on my windows dev machine... I have setup a system ODBC source pointing to an Access db. I need to link to this DB in real time, using some of the information on one of the tables. When I go to manage database -> relationships an…

Here's some basic information: The ODBC DSN Entry is: ALPINESQLODBC Server Information: Path: //xxx Database Name: HomeData SQL Server Version: 2005 Here is the recordset field names for each of the procedures above. dbo._xxx_getJobHead( jobKey # ) jobKey custNo designer jobDescription address city state zipCode I have all the same fields created in a jobHead table in FM8. I'm trying to write a script that will have FM8 run that procedure and populate a record with the SQL result set. Is this not possible in FM8?

Hi All, I have a field called task_name. On data change in task_name field I want FileMaker to call a script call Find_tasks. Can FileMaker Pro do such a task? If yes, what is the function called or please provide en example. Thanks in advance, A

Hopefully I can explain this enough for you guys to understand. I recently setup ODBC connections to several MySQL databases using Actual's ODBC driver on a Mac running OS X 10.5.3. I setup the databases and relationships with my FMPro 9 Advanced without any problems. I can edit fields within any record and the change takes place in the server almost instantaneously. But that's my problem. Is there a way to setup fmpro so that I can make all the changes I want to a record without actually executing the queries on the ESS until I'm satisfied with the changes I've made? I love the ability to change the data on the fly, but there are times that I would rather make…

I administer a custom EMR developed in filemaker 8/9 for a small office. This office uses full versions of filemaker on virtually all the machines and i recently found out server advanced was required to support an odbc connection to our hosted files. To work arround this i wrote a local file and had it run on a single machine to allow an ODBC connection between us and a lab to easily allow exchange of demographics for billing purposes. This odbc bridge for about a month (may-june) and then suddenly stopped. After some investigation I realized the driver was still getting the response it needed, but after about 60 seconds, long after timeout of the request. It was prev…

Hi all, I have the following code in javascripts: Can someone help to convert it into FMPRO 9 script? Or is this possible in FMPro 9? for (var i = 1; i <= controller.getMaxRecordIndex(); i++) { controller.setSelectedIndex(i); if ( i==1 ) {globals.Num1 = subj_num; } else if (i==2) { globals.Num2 = subj_num; } else if (i==3) { globals.Num3 = subj_num; } else if (i==4) { globals.Num4 = subj_num; } else if (i==5) { globals.Num5 = subj_num; } else if (i==6) { globals.Nu…

Hi All, In one of our FileMaker Pro 9 forms we have a field lets say Validate. What I'm trying to do is when the validate field gets populated with any charecter, then make that record read only to all the users. I coulden't find any script or any calculation to do that. Thanks for any help. Regards, A

Hi, I am currently evaluating FileMaker Pro 9 to see whether I can redevelop my father-in-law's aging Paradox application to another PC based system. One reason I looked at FileMaker is that I recently bought a MacBook and without all the fuss of running VMWare etc.. wanted to develop on my preferred platform but still supply something compatable with Windows etc.. and whilst Web based is one option, his preference to have PC based applications as his user count is only himself and the fuss on installing web/Apache remotely is more hassle than it's worth... So far have been impressed with what I can do without really needing to resort to anything too hea…

Hello, I would like to display on a web page, using PHP and mySql queries, data from a FileMaker Pro 9 database. It's the opposite of what most people want to do. Is it possible without the server version ? I don't plan to access the database directly with PHP functions, I would like to pull data from Filemaker with mySql queries. How to do that ? Do I need the Filemaker ODBC client driver, the mySQL client driver, or both ? How should I set them up ? I have downloaded and installed the mySql odbc connector, and set it up in ODBC administrator in OS X, with these values Host : localhost Port : 2399 ServerDataSource : fmp_db (fmp_db is without th…

Hi All, I apologias to everyone posting all these questions. I have a meeting on Monday afternoon to review the possibility of using FileMaker pro 9 as our database. Having said that, I need to setup a database in FMPRO 9 and present it as prototype for that meeting. So here are some more questions: 1. How to setup the Primary key in FMPRO 9? 2. I could not find any Save Record function to bind into A button. 3. How to disable the Found Set AutoSave? 4. How to set Forms to Open in Black Mode meaning “Load Omitted Records”? 5. We have a field called USER_ID, any time we issue a new record I need to assignee the next available number to the new reco…

Hi All, New to FileMaker Pro9, and in the process of evaluating it. To start evaluating FileMaker we have few requirements 1. To do live connection streaming insert and update records to our backend database that is SQL server 2000 and soon 2008. 2. To do the record validation: As an example: Using FileMaker forms users create and insert a new record into the backend Database, then for the second time users open the same form and create retype the same record and then compare the second record field by field with the first record and if any filed does not match, then FileMaker informs users about the unmatched field via popup dialog. 3. We will be creatin…

I have the following situation. table_1 = person table ( information regarding people , name , id num, ....) table_2 = list of people that attended an event. (id num, and event related information) Table 1 is in oracle db schema (person)(1 million + records) Table 2 is in oracle db schema (events) I have the following query that I can't get to work. select ID_num, First_name, last_name from table_1 where (person.inactive_dt >= SYSDate or person.inactive_dt is null ) and person.id_num in (select unique(ID_num) from table2) The second select is what I am questioning. I keep getting a table or view doesn't exist error. I have verified that t…

Hi All, Let’s say we are in the find mode and run search for a record and we find 5 records. Is there a way after finding all the 5 records to make Filmmaker viewing each record automatically one after another? If yes, then what is the facility to use? Thanks in advance, Abrahim

Hello, My company uses FileMaker Server 9.0v3 on Windows XP and FileMaker Pro 9.0v3 Advanced on both Mac and Windows. We create reports using JSP with Java and query FileMaker Server using JDBC. Recently we added some new tables and changed table names in FileMaker. As expected our reports were broken. For most of them we would get an error saying that the table is not found. However in few cases when the table name was not correct it would crash the FileMaker Server instead of giving an error. We are not sure if this is a driver issue with JDBC or something wrong with FileMaker or SQL. This is a huge problem because if I ever misspell a table name it…

Hi All, Many apologies in advance, this is a bit long winded. I work for a charity and we're in the process of moving fm data to mysql but we'll still need to carry on using fm for calculations, mailouts, etc. So for example we had a table called 'memberships' in fm, I created a table with the same name in mysql and exported all the data to it. I then deleted the memberships table in fm and linked the external memberships table into fm via ODBC. Naturally as soon as I deleted the fm memberships table all scripts and layout objects also lost the reference to it and linking the mysql memberships table didn't rectify this problem either. I managed t…

I got a weird one. This is only for testing on my 9.0v3 FileMaker Pro Advance Desktop... no server interaction. I set up a MySQL ODBC connection. No problem. Way easier that I would have thought. I went to test it with an import records from ODBC data source.... what do you know! It showed up fine in the drop down. Worked perfectly. I went to add it as an external data source, and NONE of the odbc data sources (either the mysql one or the default MS ones) were visible. Any ideas? I've Googled around a bit and found no hints. -Jeff

Hello, this is my first post. I'm using FMP as a data source for MS Word mail merge. It wasn't easy, but I did get the ODBC link to connect and I can (enventually) get a list of FMP fields to insert into my document. The trouble is that the connection seems REALLY slow, and this is just a one-table test DB with ten records that's on my desktop. Waits of 2 minutes to connect are happening, with 10 seconds or more to move between previewed records! Is there any sort of connection issue that I am probably overlooking? MS Word shows to be running a process of 155 Megs. when the Filemaker DB is connected, which seems really high. There must be some big processing overh…

Hello, A non profit org I work with needs to import data into FM 6 from a remote mysql database. A commercial ODBC driver or solution would be acceptable. Suggestions? Thank you

I would like to know if is there a way to custumize the authentication page?

Every time I open my FileMaker file, I run a script that imports records from SQL tables to FileMaker tables so I can use the SQL information in value lists. In other words, I make duplicate tables (a FileMaker table that is a copy of the SQL table) specifically so I can show the SQL data in a dropdown box (via the duplicate FileMaker table). Unfortunately, this technique doesn't take into account when SQL records are deleted. Importing the SQL records upon opening the file will not get rid of records that no longer exist in the SQL table. So, when I delete an SQL record, it stays indefinitely in the duplicate FileMaker table that I use for value lists. I nee…