External Data Sources

Basically i just want to know if it's possible in any way? An import (which i can then attach to a script) would be great! At the moment i can see the ODBC drivers in the 'external data sources' set up, but when i try and select it, it tells me that its not supported. Does this mean that integration is impossible? When i try to do an import, i cant see any files listed in the import from ODBC option. has any1 ever had to play with info from Fox Pro. Thanks in advance.

I have connected to an ESS source (MSSQL) from FMP9, and created a TO to one of the ESS tables. I have additionally created a native FMP table by importing the table definition. I then attempted to import all the records from the ESS table into the FMP table in two different ways: 1. Import from the file itself with the ESS table as the source and the FMP table as the target 2. Import from ODBC source with "SELECT * from TABLE_NAME" Each of these methods skipped records due to errors (presumably validation errors, since the validation options from the ESS fields were copied to the FMP fields) The problem is, that in importing by each method from various tab…

this maybe is easy but i dont find how to do it i wanna to summ a especific field on each record. any ideas?

I have a MySQL database on a remote server that is capturing web orders. I have a FMS9A server on our LAN that stores our company invoices. I have created a shared data link on my client computer (a Mac running FMP9) using Actual Technologies' ODBC Pack v 2.8e (for Mac OS X). I am able to import data from the MySQL datbase just fine but I am trying to figure out the best way to implement a permanent system for transferring web orders to FMP as they come into the MySQL database. A few newbie questions: 1.) What is the best/safest technique for pulling the data from the MySQL into FileMaker? 2.) Let's say I am going to import a bunch of web orde…

It seems that connecting through JDBC is not working on FMS deployed on a 64-bit Xserve. Each executeQuery() call fails with this error: [sequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed. The problem disappears if the getConnection() call is redirected to a DB on a 32-bit machine. Any guidence will be greatly appreciated!

Hello! I‘m good in Filemaker, but new to the integration of a mySQL-database. I‘ve done already some research, but don‘t find real good answers. I‘ve read here already that Filemaker is not good to use as a frontend, but that is what I exactly wanted to do... We have a small company with just 100-1000 records in 2 tables, so I thought that would be easy to do. Usually, opening the file, the SQL-records are immediately shown. But later the day, there are sometimes pauses from 20 to 60 seconds, when a change to a field is updated, or when doing a record-search. I cant reproduce this problem, but it happens quite often, when I try to work again after a b…

I have a ODBC Connetion to a MySQL Server. I have no problem using this connection when I have a single computer connecting. However, I now need to look at hosting the FM Database on FM 9 Server Advanced. I need to have those data tables from the MySql Server availible to the Network Users. Is there a way for the server to control and hold the connection (ODBC) to that MySQL Server?

sorry if this should go into another secttion but it does relate to external sources. I have an Excel report produced monthly that indicates all the G/L accounts that are valid. I would like to populate a database with the number in one field (about a 10 digit alphanumeric string) and the text name of that group in a second field. Yes I know the issues with creating DLL or OLE type links to an external document but to set up the SQL stuff to go into SAP and grab the live data means I need to get into security, major coding and such and I am a total NEWB. I know I can do this once a month by doing a cut and paste into a drop menu but then my concern is making sure the G…

Hi, I am using FMP 9 advanced. I have an external table that I need to import into FM tables so I can use them in Value Lists. The data is on a MySQL server, and I need only two fields (ID and Name). The Id is importing without problems. The name is a utf8 column. It shows correctly when accessed from MySQL. If there are characters other that roman it that field, the imported field contains question marks instead of the text. I am using the Import Records from ODBC with SELECT. I found a workaround, which is not that good but it does the job. I export the data to a tab delimited file with utf16 (utf8 is not working), and then I import the data from that fil…

I work for the Head Office of a group of retail stores. I will be getting 2000 records per store, per week from 45 of those stores. The information will be used for sales reporting, ranking, forcasting, etc. For various reasons I am still using FM 6.04 on Windows 2000 2.4GHZ. As a test I set up a file and started importing records from just 6 stores. It worked okay until I hit 400,000 records. At 500,000 it's gotten too slow. I see that FM9 will work with MySQL and am looking at upgrading the system anyways before June 30. Has anybody had any experience with Filemaker and MySQL where there will be approximately 4.7 million records per year (p…

Connecting (with FMP 9) to a locally hosted MySQL server (within the LAN) is well and widely documented and not too complicated. But what I haven't been able to figure out (or even find info about it) is how to connect to a remote MySQL server. I do a lot of php/MySQL programming. I host my websites at several 'affordable' (cheap is a better word) providers which offer MySQL. My question is, would it be possible to connect to that host's MySQL server?

I am migrating FM9 but have a problem. Because of a ton of Applescripts which interact with some legacy page layout programs, we will still have to maintain one database which was created in Developer 6. I'd really like to share data between the two FM versions but the only way I can think to do that would be scripted export/imports. Does anyone else have a suggestion? Thank you!

Is anybody try to get data from Oracle 11g using ODBC driver 11.1.0.6.0 within FM external table ? Tks ;)

We are running Filemaker 9 Advanced on a Windows 2003 server. We have ESS set up through an ODBC driver and this allows us to read and write in the tables of a mySQL database. However the SQL database is now getting very large, with in excess of 1.3 million records in one table. We need to be able to regularly analyse data in this table, but everything just grinds to a halt when we try to run Filemaker finds on it. One possible solution would be to offload the analysis task to the mySQL database, by generating suitable SQL statements in Filemaker, sending them to mySQL for execution and then using Filemaker to present the results. However the Execute SQL [] com…

Is it possible to have a 9 Advanced Server, ESS connect to a MS SQL database and then have an 8.5 client see the SQL data? Or do all the clients have to be ver 9 also? Thank you Alan

I have successful set up the Execute SQL in the script editor (FM9) to push values into an access database, but I would really like to push that data by the field names. I can't seem to find an reference material on how to reference FM field names and/or FM tables to use Execute SQL. Can anyone help me on this?

Hi Guys, Has anyone used this combination before? With Fm 8.5 came SequeLink 5.4 odbc drivers, but are the 5.5 drivers more stable for dataimport back into Filemaker from an ODBC source? Thanks

I am trying to set up an SQL table as an external data source on FMSA 9.0v3. With the assistance our our IT guys, we have set up DSN access through the Windows control panel and all indications are that the connection is fine. In trying to add this table as an external data source in a hosted FileMaker database, I see it listed can easily add it as an ODBC source. But I am not sure what to put as a username and password in the the "Authentication" area [i had assumed that since we had already configured the creditials on the host machine, then we should be able to connect through directly]. Putting in the same username and password as applied through the co…

Hi! Does anyone know how from FM 8.5 I can launch a REMOTE FUNCTION CALL (RFC) to an SAP system, to query the SAP Database? Do I need a plugin? Thanks

Hello All, I need a script/code to connect my database without a DSN for a plugin I am trialling. Does any body know how to create DSN Connection String for communicate with FileMaker 8 (although I'm testing with 9) My Database is called Purchases, TO is callled Purchases, UID is manager and pw is temporary. Thank you

I'm trying to use FM as host. But when I go to Edit->Sharing ODBC/JDBC does not show up as an option. What am I doing wrong?

Hi I am an application developer and quite unfamiliar with FileMaker. I would like to retrieve data using ODBC from a FileMaker database (with a .fp5 extension) that is located on a windows server machine running FileMaker Server 5.5. Is this possible? I cannot figure out what level of ODBC support is offered with FileMaker 5.5. Some information says that two way ODBC data exchange is fully supported. I telephoned FileMaker customer support and as a legacy product they were not able to give a decisive answer but felt that ODBC support was excluded from Server 5.5. Can anyone please tell me if it is possible to access a FileMaker database via ODBC on a Windows Server …

Can someone tell me what problems there are using FileMaker 9 Adv Server as a data source through ODBC. The I ask this is because the software that I am using to use FileMaker as a data source seems to be having issues. One problem is that the Sequelink gives an out of memory error and sometimes it seems to time out. For example, I am using an email software package that connects through odbc, and if it queries 3 records from filemaker, it works, but if it queries 20,000 records, it times out. Another example is that when i create an access database to pull in 130,000 filemaker records through odbc, that gives a sequelink error to. I have tried both sequeli…

mySQL has GPL connectors for various operating systems, including Mac OS X. Has anyone had any success using it with FileMaker Pro? I installed it but it seems to be stuck using dbname.dbname as the table for everything instead of dbname.tablename. The Actual Technologies driver (demo version) seems to work perfectly but I'm trying to save the end-user non-profit from the licensing fees. As it is, we're hosting the mySQL database for free, developing the FileMaker interface for free, etc.

I am a developer and familiar with db's, but new to Filemaker. In Access it is possible to create a "linked table" which links Access to a table in SQL Server. Is this possible in FileMaker 8? Basically, I need to link the data in a table in FM to an identical table that exists (and must exist) in SQL Server (2005). I was going to use a script to execute a query on the sql db but the client would prefer to use a "linked table" if it is possible. Any help would be greatly appreciated. Thanks!!

Curious which method is preferred, when creating a record thru ESS in a script. Should you create the record and then commit, then proceed with setting other fields- then committing again. Or is it fine to create new record do a bunch of set fields then commit the record?

I am wanting to jump into the huge world of MySQL. The problem is, its so huge that I'm not sure where to begin. I'm running 10.4. I've already downloaded MySQL from mysql.com. What books, sites, does everyone recommend? Thanks

This may be a crazy question but, is there a way to connect ms access to a Filemaker 9 Pro database? In other words I've created a Filemaker database, is there a way that people using MS Acess can conect to it.

I am Using FM8.5, and have been using SQL statements to import data from our AS400 system into FileMaker for quite some time now. Now, I would like to send data to the AS400 system. So I have been trying to use an UPDATE statement, but I guess I'm having trouble with the syntax. In actuality, I have no clue how to compose an SQL statement, so maybe that's the problem. Can someone here share with me the proper syntax to use to update an AS400 system from FM. I basically want to update a field in a record in our AS400 system for a specific part number.... So, where the part number in the AS400 equals 123, update the drawing number field in the AS400 wit…

Hi, i am using ODBC connection and sql query for importing data from mysql database. I am importing password it is in the encrypted pattern how can i decrepit it and get original value? I know function which is used for encryption in php. Many Thanks and Regard, -Rishali

Situation: in FMP Table A = 2100 records External Table B = 900000 records Table C = 9Mill records Table A calculated field B = if Table A field A is empty then field B value = value from Table C field b else table A field b = "No Value" (I'm doing this is a case statement. The actual calculation is a little more complex than I have stated.) The relationship is table A keyfield1 = Table B keyfield1. Table B keyfield2 = table C keyfield2. I have a layout that displays the calculated field. My question is when I sort this layout by calculated Field b it takes forever. The DBA here at worked wanted to know how FMP queries the oracle tables. Does…

When I attempt to add a table to the relationships graph, I have the option of choosing my external datasource. The window then displays all of the tables I have in my sql database referenced by the datasource. The problem is it only lists all of the tables and not the Views that I set up. Is there a way to reference my views in the filemaker relationships graph?

Has anyone had any experience integrating Fm and DHL's Easyhip? Does it work similarly to UPS worldship? Any thoughts/issues would be greatly appreciated.

Is there a way to open an external datasource based on the value from a field, variable or function?

Hi there everyone! Ok so I'm just a web developer, not a FileMaker user, but my client is needing something kinda tricky here. They have a website hosted on CentOS 5 in the Midwest US, and their FM9 Server is located remotely on Maui, on their lan in their office. I have been contracted to create a php script which can either (hopefully) use the existing php odbc drivers or, as they were instructed by a FM rep, to use the DataDirect Unix ODBC driver. All I'm trying to accomplish first off is telling the PHP script on the CentOS box to connect via IP and correct port to the FM9 server at their office, query 1 table, and return the resultset to the php page. If…

I am setting up some email marketing software called Campaign Enterprise. It requires an ODBC connection into FileMaker, in this case. The software has the ability to run stored procedures or SQL statements. In this case I am trying to write a procedure to compare the current record in the email software to those in a table in FM, if there is a match, it will increment a field value by 1 in there is no match it will create a new record in the table and insert a uniqueid. I have successfully used 2 different sql statements to either create a new record and insert the data or to update an existing record, but I cannot seem to combine them into one IF THEN ELSE sta…

To make a long story short(ish); I am developing an application for virtual trading of OMX listed tickers and the old code imports Oracle data (batch import) in raw text for stocks (for fusioncharts output). The graph gathers data from a textfield in the form "x;y;z...." where the variables represent ticker values. Now I need to get the data elsewhere as the Oracle feed will cease to exit in the near future. My question is; what is the easiest way of importing ticker data into a textfield (delay is ok)? I have had a brief look at Yahoo Finance quotes that has *.csv files for download. I have a string function that will take care of the conversion from text into …

Hi! I am using MySQL 5.0.45 with FMP 9.0.3 (in trial mode), and my problem is this: I am researching the possibilities of editing a customer's MySQL database using FileMaker. Connecting with ODBC works fine, except from the following: 1) The UTF-8 encoded MySQL database content is not shown correctly in FileMaker (I guess because FM is assuming another encoding). I have tried to specify the ODBC encoding as UTF-8, but then FM crashes when I open the project. 2) When editing data loaded from the MySQL database, editing numbers work ok, but editing text results in only one character strings. E.g. changing "hello" to "goodbye" results in "g" only. I …

I think I am barking up the wrong tree here, but I will give it a shot. I have FM Server 8.0 and many clients of FM Pro 8.5. Basically what I am trying to do is to set up an ODBC connection to our mail list database through one of the clients, but the actual file is hosted on the server. I guess I assumed that as long as the client was running the file and I set up the ODBC connection to the client, it would not matter where the file actually resided. I noticed in the "Sharing" settings, I am only given the option to ODBC host a local file and not one I am remotely connected to. Is this correct or am I missing something? I really don't want to drop another $1200 to upgrad…

Dear All, My yesterday's question (answered, thank you), one concerning drop-down lists on fields imported from an external odbc source, brought up another for which I can't seem to find any answer in any FMpro guidebook or tutorial. I notice an enormous difference in download/display speed between fetching odbc data with fmPro's 'native' query and when using scripts: in using the 'default' layout just after managing my odbc source, it manages to load data and switch between form, list and table views without any lag at all; yet should I perform a lookup using a script, the download takes ages. Does anyone have any explanation for this difference, and is there …

Hi everybody ... I have this problem ... I use a filemaker pro7 table, with data that import from an other table created in mysql (using mysql odbc ... ) The issue is that when i modify information from the table created in File Maker, "this changes" are not in the mysql table ... I need to know how can i update the records in the mysql table using the layout form created in file maker Would somebody please helpme telling me what i´m missing or which is my error ? I think that if modify information in the table in File Maker this changes will be reflected in the mysql table ... Thanks in advance... BTW .. i also already setup the tab…

Dear All, I am an absolute Newbie in FMpro - apologies in advance if the answer to my question seems obvious. I am using a remote mySql db as a source (through ODBC) - my attributed fields display data fine, but when I try to give any of those fields an auto-fill or drop-down menu option, I come across a myriad of roadblocks: the source can't be indexed (tried doing this even on the remote server) is the foremost problem. I got the idea that I would have to somehow import data through a second FMpro-created field (that could be indexed), but I always get an "unrelated table" message. Also, I have yet to find any "entry-level" ODBC/fmPro tutorials - can anyo…

Anyone using MySQL 6 enterprise as an ESS?

I wonder if it is possible to fetch information from within an Excel document for example a certain cell value.

I am using FileMaker 9 as mostly a front-end to an SQL database. Unfortunately, at this time, FileMaker does not allow me to create value lists using the tables from my SQL database. This is what I was thinking might work as a work-around: duplicate all the records from the SQL table into a table in the "local" FileMaker file, and somehow update the records in the "table copy" every time the FileMaker file is opened. Once I have an exact copy of that external table now in FileMaker, I can use the FileMaker table to make a value list. I have no idea how to do any of this. And if anyone has a better idea for a work-around, I'd be very happy to hear it! Thank you i…

Hi, I am using an ODBC connector for importing an external mysql database. i wrote sql select query for that ....i am having problem with one of the table. In the address table form mysql database having address_id and customers _id in this eg. address_id = 1 and customers_id =1 for shipping address And address_id = 2 and customers_id =1 for billing address so there will be always two rows with same customers_id ...... now i want to import this kind of data into filemaker but while importing in FM it is not taking same id number only once it is taking.... Please suggest solution for this

From my PC's control panel I have managed to load the ODBC drivers for mySQL, and it passes the connection test. But when I go to manage external datasources in FM9 advnaced I do not see the sql table to add. What am I doing wrong? :)

Dear All, I am still new to the world of filemaker. anyhow, i have here in my work , one excel sheet for our products, that we used to enter the price for this material . I also, attached the excel sheet with this question. anyhow, i create one dadtabase file , with this name 1.fp7 & it has many tables inside this database. I made the tables as per the name of the product. for example, i am working with one product called ( C9 ), so i create one table called C9. The fileds inside this table, is exactly as the one which is in excel sheet, i attaced. The excel sheet have the followings - 1.Date 2.Low Price 3.High Price 4.Avg Price. 5-Week Chang…

Hello, I am using odbc connection for data transfer and wrote sql query for updating the value in the database. query is working fine and data also getting updated.... but i am getting one error/warning and which is not for all the tables only for some 3-4 tables ... it is as below ODBC Error:[MySQL][ODBC 3.51 Driver] [mysqld-4.1.22-standard-log]You have an error in your SQL syntax; check the manual that correspondato yor MYSQL server version for the right syntax to use near"

Is there a way to import ONLY the structure of table from FM to MYSQL?

Hi, guys. I am a beginner,and I want to judge that whether the ExecuteSQL works fine by using the function of Get(LastODBCError).But everytime the function will get the last ODBC error code, regardless it worked fine or not.So I have to clear the ODBC error code before the ExcuteSQL script runs. And my question is how to clear the ODBC erroe code? Is there any script or function in the FileMaker can do it? And sorry for my bad english :

I have two oracle date fields that are causing me problems in Filemaker Session Start time, Session end time, When I import these date fields into filemaker all I get is the date no timestamp infomation. I had my oracle DBA look at the field contents in oracle and the date fields contain both date data and time data. (2/1/2008 12:00:00 am). I've tried importing these fields into FMP date fields, timestamp fields, and time fields. I always get the date no time information. Is there anything I can do? Is this a FMP 7 issue and if I upgrade it will be fixed? I have also tried opening the oracle table from filemaker (You know where it will create …

Hello - I'd like to ask some advice before going forward with a complete switch to FileMaker. I'm the system administrator for a photo-rental company. Our stock changes quite frequently (additions, aged material, etc), and we need to track what comes in and goes out (and for how long)... we thus need a constant read/write connection to our database. We have around ten posts (that I plan to switch to Mac/Filemaker client) and a central server (that I would like to fit with Filemaker Server) that would connect to our database in another remote location. Can someone please give me some informed advice about the possibilities of this setup using FileMaker, and …

I am working on a way to interface FMP to FMForums with ESS, the dates of posts here are stored as GMT Unix such as "1204660734" = 03/04/08 11:58 AM (GMT -0800) I need a way to convert a FileMaker TimeStamp into that format, vice versa.

I have made this work just fine. But we have a problem. We have the FM server on our LAN and we want to conect to a MySQL database outside the LAN. This workes fine when we connect from our LAN to it through a SSH tunnel. But if the tunnels die then the updates to our MySQL databse fails. Is there any good practise to do this in a safe, non failure way? Can I in someway keep the ssh tunnel alive? Can I make Filemaker put the SSH tunnel up again? Thanx alot for all imput. Regards Joakim

I am accessing SQL data via an ODBC link and I am finding that performing finds is incredibly slow. Has anyone else experienced this and if so found a solution to speed it up. My long term aim is to use Filemaker 9 as a frontend to work with multiple SQL data sources. Am I expecting to much from Filemaker??

Can't get Allow Creation of Records to work directly with SQL Tables through ESS. Is this possible?

I've been using FileMaker to mashup data between several of our SQL Server and mySQL databases. I have one mySQL database which crashes every time I try to add a relationship to it in my database. Other databases on the same server behave fine and I can also use ODBC to import from the problem database; but creating a direct relationship always causes a crash. The database is hosed on mySQL 4.1.18 and I'm using FileMaker 9.0v3 on Mac OS 10.5.2 with Actual Open Source driver 2.8c. Any ideas on what could be causing a problem with this one database? Thanks, Sean

Anyone manage to work successfully inputting data through FM on two SQL Tables directly with an associated SQL Join Table. I can't get the Join/Link table to update in SQL even though i have allow records to be created etc in FM

It's not listed anywhere in the Filemaker documentation, so there's no reasoin why it should be. But I've been trying to connect anyway, and am getting a message that the file type is not supported. Has anyone else tried and failed - or succeeded?

Hi, I'm trying to connect to my other job FM server from the college which I am working. The problem is that I need to go through a proxy. How do I enter the proxy's IP adress in FM8.5A? Thank you

Does the new SQL linkage capability in Filemaker 9 make it easier to periodically publish information to a SQL database? In our case, we have a Filemaker database of content. At present, CSV files are exported once a day from various tables and then batch imported into the SQL database that drives our website. It's inefficient and there are hundreds of thousands of records across dozens of tables, but it works reliably. Is there a good way to improve on this using the new capabilities? Note that we don't need to see what's in the SQL database, and don't need live updating of the SQL database, only periodic synching with the Filemaker one. Looking further ah…

What is the best way to handle date fields in an SQL2005 table when working through Filemaker. In SQL, there is two options for date but both include a timestamp. How can users just enter a date etc. in Filemaker. Thanks, Sully

I have FMP 7 Developer. I have databases that connect to an Oracle database to pull data down from certain Oracle tables. I need to be able to give a database solution to another employee. This employee doesn't have FMP. The likely hood of this employee being able to get a licensed copy is slim. I figured that I could create a Runtime app so that he could use the app to run the monthly reports so I don't have to. Here is what I did. I created a Runtime app and then ran the application and tried running one of my scripts that has the ODBC import function in it. The script immediately canceled and asked if I wanted to continue. I ran this on my machine so everything s…

Can Filemaker 9, within a layout display a list of files within a given subdirectory, eg PDF's, .pages, etc.? Can that list be made to be link-able, that is click on the filename listed within the layout and have it open? Would that list dynamically update as new files are added, if it can do that?

I am looking for help connecting to our AS400. We use a manufacturing program (CA-KBM) that stores its files in DB2/400 format. I am using the data from this program for reference only. Presently I get a daily .csv download which I manually import to my Filemaker file (I must first delete all records). The act of deleting and then importing is time consuming and interferes with user displays. Does anyone have ideas how to get from DB2 format to a format that is supported by ESS? The .csv file is currently being generated automatically everyday. Can I use ESS if the output file is an Excel file rather than .csv? Any suggestions would be appreciated. …

Whenever a table is added from MS SQL Server all fields, in that table, have the "Required Value" option enabled. We can "uncheck" this requirement, however after saving the change does not "stick". Has anybody else had this problem, if so have you resolved it? Thank you. Garry Claridge

Hi, In Filemaker9 I have tables, data from SQLServer. If we add new data in Filemaker is it directly added to Sqlserver tables without doing the export? Is this feature available in Filemaker9? Thanks in advance

I have a FileMaker database called "source" that has a table called "names" that I want to "link/share" with a second FileMaker database called "customers". I have added the "source" database to the "customer" database and have successfully added the "names" table to the relationship graph. My problem is that the "names" table is not listed when you go FILES>DEFINE>DATABASE>TABLES. Any ideas on what I am doing wrong? Thanks

Greetings, all. When I try to add a table (in the relationship window) using the Firebird ODBC I get an error saying "The ODBC data source you have selected is not supported." Are there any plugins I'm missing for Filemaker that can resolve this? Or are there any other work arounds that I'm missing? I'm not using FileMaker server at all for this. This is opening a backed up copy of the database from my desktop (I couldn't see the ODBC at all when connecting to our sever, I would guess because it's running Server 7.) Thanks for any help you can provide me.

We have a Mac X Server 10.3.9 that we installed FMServer 8 Advanced on. With v8.02 the ODBC works fine... when we update to 8.04 the ODBC stopes working, not even responding on port 2399. Anyone have any clues!?!?

I cannot get WIndows or Mac ODBC clients to connect to FM Pro Server advanced 8.0v4 running on OS X 10.03.9. The Filemaker knowledge base #6451 says "FileMaker Server Advanced 8.0v4 and Mac OS X 10.3.9 FileMaker Server Advanced 8.0v4 ODBC/JDBC connectivity does not work properly when the Mac OS X 10.3.9 update is applied. FileMaker, Inc. is aware of this problem. A workaround is to not apply the Mac OS X update or to upgrade to Mac OS X 10.4.x (Tiger) where ODBC/JDBC connectivity works properly." When I do a port scan, or netstat -a it is obvious that port 2399 is NOT open on the host. Does anyone have an idea what 10.3.9 'broke'. It is not an e…

Hi, we have a system in FileMaker that uploads information to 7 tables in an oracle database. The software developer of the oracle database has provided us with some API's that we could use to upload the information instead of just using execute sql script step. I don't know where to start to understand how FileMaker could use an Oracle API. Would anyone be able to point me in the right direction? Thanks, Constance

I linked Filemaker to a MSSQL-Database through ODBC. I need access to some fields, which works well. One of the fields is a timestamp-field on the SQL-side and is always displayed as dd.mm.yyyy HH:MM in FM, but I need it displayed as dd.mm.yyyy without the time. I've been trying for hours now. If I change the SQL-Query to format the field differently I can no longer update it. :B

What is the work around for moving BLOB/Container data to SQL server, Shadow Tables do not show/support BLOB fields at all. I don't have Advanced server for ODBC. Need possiblities other ideas. Need to do it over the net. Am I stuck? Note: DTS not an option. Thanks

Hi, How to expor data from Filemaker to Sqlserver? Thanks

Hello, I'd like to use my FMP data (8.5)a simple email list with the Constant Contact interface. I haven't done anything like this before, but I've heard there is a CC API which allows the information about the email (Subscribe/unsubscribe/bounce etc) to work with my dataset if I can figure out how to implement it locally on our webserver. Has anyone done this? Would you recommend it? I think the churn on the emails the first time might be a few hundred, so its not a big deal, I'd just like to get on the right track. If this is the wrong forum for this question sorry! Linda

I have some FileMaker Pro 5.0 files that I would like to query via ODBC. To test this, I am using MS Excel and MS Query. Most of the files work fine. However, one of the files crashes MS Query every time, even on a simple query of one field. MS Query gives the "submit error report" window. What limitations or requirements might cause this to happen? J

Hi, I’m having troubles with value list, well let me explain a little bit about my project: I have a database in SQL Server, with 3 tables: 1.- Vehicles Report 2.- Models (for example: BMW, AUDI, etc) 3.- Submodel (example: from audi: A3, A4, etc) I connect to by database using ODBC, so I import al the fields in to my layouts, which it’s working great, I create a new record, and can see it in the Database without a problem. The issue is that I need to enter a new Vehicle Report which has several fields, the once i need to work depending on each other are: Model and Submodel. So I need to select the model (AUDI) from a Drop Down List, which has a…

Hi, Anyone out there with a bit of ESS experience??? I've developed a FileMaker solution which predominated uses ESS to connect to MySQL. Filemaker Server 9.02v Mac deployment MySQL Actual Technologies Open Source ODBC driver. In our development environment I have created a system DSN specific to the development SQL data source. While on the live server a system DSN specific to the live SQL data source has been set up in parallel. This DSN has exactly the same details apart from the IP number of the data source. Deploying the solution has resulted in a major issue. Even though the DSN is named correctly, all tables in the relationship…

Hi, we curently have a database solution consisting of two files (GUI.fp7 + DATA.fp7) i.e. data separation model is in place. Our goal is to move all the tables from filemaker file DATA.fp7 into SQL2005 and still use GUI.fp7 as the front end for the SQL server. Exporting data to SQL and connecting filemaker to SQL is not a problem. The major problem we're having is that filemaker does not preserve field order when an SQL table is referenced. For example, GUI.fp7 file has a Contacts table that is referencing Contacts table in the DATA.fp7 file, the idea now is to change this table's reference to a Contacts table in the SQL server with same field names and field order. Howe…

I have my FM9 setup to access a SQL table. The only thing is that I can not make changes to any data within a recored. If I try to change any field data, I just get an error: ODBC Error: Update or insert of view or function "PRO01.dbo.ARTRAN_Sales" failed because it contains a derived or constant field. Anyone seen an error like this?

Quick question: I have setup an external data source...using ODBC to look at a Microsoft SQL 2005 database. Everything is working fine. I can access the various SQL tables and add them to my FM solution. ONE problem...SQL views. How do I access a view? I know how to access different tables...under manage database...relationships tab...I just double click my table, choose my datasource, and then I see a list of all the SQL tables to choose from. But I only see a list of tables...no views. How do I choose a view?

Hi I was wondering if I must use the drivers found at https://www.actualtechnologies.com/product_opensourcedatabases.php to connect to a mySQL database or if there is a free alternative? if the server is running the ODBC driver can I manage with 5 connections? Or will it grab one connection per FM client logged on to the system?? Regards Jocke

I have managed to successfully create a connection to a MySQL data source and added a table in my relationship graph, creating a shadow table in my filemaker database. Text and number fields etc have been mapped correctly, but a BLOB field that has been setup in the MySQL database does not appear in the shadow table. Does anyone know why this is. I am planning a solution that will need container field contents to be replicated to the MySQL database.... Any help would be greatly appreciated...

I bought and installed ODBC Administrator in order to directly import members data from my server to Filemaker. But I only get errors [color:red]1. ODCB Error: [Actual][MySQL] lost connection to MySQL server during query. Why it always lose the connection? [color:red]2. This file could not be translated using the selected file type. There is no option (greyed out) to choose? What am I missing here?

I'm looking for a way to execute SQLServer stored procedures without requiring a DSN setup on every client machine. We have about 80 clients, with some Mac, some Windows. The solution I'm building is largely driven via stored procedures within SQLServer, using FileMaker as the interface. Currently I'm using the ExecuteSQL script step to execute the stored procedures, but that will require the extra step of ODBC drivers and a DSN on each machine. Using FM Server Advanced (or other means), is there any way to use the server's DSN to execute the procedures? Any other suggestions?

Newbie question: I've set up in my Datasource (ODBC) a link to our companys MSSQL 2005 (Native and normal SQL ODBC link) from my computer to the SQL server. Testet it OK (both with Datasource admin tool and in Excel). I've also turned on ODBC/JDBC in Filemaker but when I try to connect nothing happens - i do not get the tables in the dialog (I've read through the documentation, online help etc). Does anyone know what to do ? (I've heard some rumours about than FM does not use port 1433 (sql standard port for communication with ODBC - but another port ? Does anyone know ? - I have access to the SQL server as well.) Hans Jakob - frustrated FM user... (I…

We have a FileMaker database that we'd like to connect to a MySQL database. The FileMaker database is hosted with MacUSA.net However, our current host for the MySQL database (another company) does not allow external connections to their database server, but does allow connections through an SSH tunnel. Is FileMaker Server (or client) capable of establishing such a connection?

OK i have this awesome database nice and working thanks to the people that helped me on this forum. OK, so now that I'm done i would like to create a runtime of this database, because I'm leaving the country for an unknown period of time, (hopefully many years) and the people that work in my business don't know s**t about computers and i don't want to leave filemaker installed on this computer either. but after i have done it i found that runtimes don't have support for network. after explaining that this is what i want to do. Database Runtime on a computer (MachineA) that can be accessed from both computer in my gym (MachineA + MachineB) through wi-fi …

I just lost several hours of work because on my local network the hosting FMP tables were closed before the remote had logged out (though several hours had passed before this happened). Nom I want to prevent this happening again and I want to know how/when data is written from the remote to the host. My guess is that the command "flush cache to disk" might do this. If not what can be done? Once more data loss occired because the host had closed down before the remote had logged out.

So, I've got MyODBC 3.51 installed and set up, in OS X Leopard, as my system DSN, and it's working. I can open up FileMaker 9 and connect to the external data source. I can then open up the "Relationships" area in FileMaker, and create a local "table", linking to the fields in my remote MySQL table. Fantastic. Now I can see remote MySQL records, viewed directly through a FileMaker layout. I've wanted this for YEARS! My problem is, if I attempt to alter one of these records, FileMaker blanks out the field, and the field's data is cleared out in MySQL. Oddly, this doesn't happen in int (numeric) fields - I can edit those just fine. Only in varchar (…

I have a customer still using FileMaker Pro 6 and FileMaker Server 5.5. I know you can make a database available via ODBC when running in FileMaker Pro 6, but if memory serves, that same database hosted by FileMaker Server 5.5 will not be available via ODBC. Is that correct?

Does the new SQL linkage capability in Filemaker 9 make it easier to periodically publish information to a SQL database? In our case, we have a Filemaker database of content. At present, CSV files are exported once a day from various tables and then batch imported into the SQL database that drives our website. It's inefficient and there are hundreds of thousands of records across dozens of tables, but it works reliably. Is there a good way to improve on this using the new capabilities? Note that we don't need to see what's in the SQL database, and don't need live updating of the SQL database, only periodic synching with the Filemaker one. Looking further a…

FM 8.5 Should we be able to use ODBC JDBC to Connect a Mac to MSSQL on a PC ? We simply want to import all the data for ease of use in FM. If yes, is it via ODBC or JDBC ? Should the FM provided drivers work ?

Will FM 9 allow me to connect from a Mac to a live MSSQL database running on a PC ? Simply want to read or import the data and leave the PC side untouched.

My company is going to be rolling out a tool from our corporate parent that is based on FileMaker 6 (argh!). This tool will handle things like P.O.'s, employee timekeeping, etc. I'm looking for a way to extract certain bits of data from this FileMaker 6 solution so that the data can be used in a variety of other apps. Right now, I'm just looking to pull a list of job numbers along with a few other fields (client name, date job was created, date closed). Ideally, I'd like to set something up that can pull this information on a regular schedule, say hourly. This data would be stored in either a MySQL or a FileMaker 9 database, so that it can be used more easily across other…

Hi All, Here it is the starting point: Clinical research DB in FM 9 adv and FM server 9 adv both on Windows platform. The database has 10 tables, ~ 600 variables and ~ 1000 records. I would like to convert the entire database to MySQL for a couple of reasons: 1) Learning more about SQL 2) Being able to construct more complex queries 3) bring the Database on a *nix/LAMP system I have read a lot of treads, many people actually ask how to do that but there are only few replies. One of the most common is: 1) Build another DB in MySQL, corrispondent to the FM one 2) Export all the records from FM in .cvs 3) Import in MySQL (usually wi…

The subject says it all, I have a SQL table in my FM file but I've noticed after a few hours of imputing data into the sql table the data is still not showing up in FM. According to the Missing Manual FM keeps these tables live and I don't have to run a update script or import new data, is this true?

Hi, I like to migrate my Filemaker Dabatabe to Mysql. I use PHP as an API in mapping database schema and Adodb class library in connecting to Filemaker via ODBC connectivity. I have more than 25 filemaker databases that need to be imported to Mysql and it's a tedious task for if will create DSN for each of FM databases and so I prefer to use DSN-LESS connection. The problem is I got an error in my connection string. here is my code: require (ADODB_PATH.'adodb-errorhandler.inc.php'); require (ADODB_PATH.'adodb.inc.php'); require (ADODB_PATH.'drivers/adodb-odbc.inc.php'); $db = ADONewConnection(DBASE_TYPE); $dsn = "DRIVER={DataDirect 32-BIT SequeLi…