External Data Sources

I am trying to establish ODBC connection from my Windos XP machine to FileMaker database on the FileMaker Server 8 Advanced. I did enabled ODBC shraing on the file, I did check "allow ODBC connections" in Server Admin, I did set the correct Extended privileges, and I did install ODBC driver on my windows machine. When I try to setup a DNS it gives me an error SequeLink TCP/IP error 2306 (connection refused) I tried to setup DNS to the same db on my windows machine - worked fine. I assume there is a problem with the Server. I did put XDBC plugin into Server/Extensions/plugins but I am not sure if it up to date. Where can I get the most recent copy of xDBC…

Does someone know how to get ODBC software in office 2004 for Mac? Thanks for your help

I understood clearly how to import from a OdBC dns but ... I would simply like to connect FM to a ODBC without importing records. With MS Access I would choose to link a form to whatever odbc database. How to do the same with FM ;)

Hi I hope I am posting this question in the right place. I work for a small non-profit that has quite an extensive (and messy) FileMaker Pro database. They want to do things like have members manage their membership on line and stuff like that. We have version 8 and the server software, but our Internet connection is too slow for any kind of hosting. I was wondering if there is a good way or any ideas of putting some small amount of data on line in maybe a MySQL database (such as member number, member name, address info, and membership level), and have FM talk to that data, but keep the rest of it here (in related tables). Then other apps could talk to the…

Hi, I have connected Labview 7.1 with FMP8.5 using DataDirect Sequelink 5.4 (ODBC). The problem is that I cant get a timestamp from Labview to filemaker. It doesnt even work when i just type "18/04/2007 09:41:32" in a text field in Labview and then copy it to FM. FM always puts it like this "18/04/2007 09:41:32" and i have no clue why. Do I have to use a different format in FileMaker or is the problem situated in Labview? Or is it an ODBC problem? any help is welcome Bart

Hi. Glad to have found this forum. I am trying to import data from a mysql database (which gets fed by an php script) via ODBC into FM. Everything works fine, unless the correct splitting into the repeated fields. I had this import working via csv, where i used this special character. However, the string provided by mysql gets not recognized by FM. Your help is very much appreciated! /Alex

I am rather new to ODBC, but have a situation I need to deal with. We have a solution (FMP 8.5 Advanced, served on FMS 8.0 Advanced) which needs to "talk" to UPS Worldship 9.x via ODBC. I have set the ODBC connectivity on the server and on the client machine using the guidelines found in http://www.filemaker.com/downloads/documentation/fm8_odbc_jdbc_developer.pdf. The client driver uses the Datadirect SQL driver on Win XP pro. I can test the connection from the ODBC control panel, but when I try to map the fields in Worldship, the machine gets as far as asking for the user and password and then locks up. I will talk to UPS, but is there something I am doing wrong i…

Does anyone know if it is possible to execute a script after a new record is created via an ODBC connection/import? Just by analyzing the way filemaker handles the connection it seems that the only logical way of executing a script is upon record creation, (there may be a plug-in, im not sure.) If anyone has an solution it would be appreciated. Thanks Jeff England

I'm trying to update a MySQL table via FileMaker. I've attempted this in two different ways. Method 1: Get(FoundCount) I've got an Execute SQL script doing the following: "select id from products where id = " & lasercut::id & ";" Since id is unique for each record, this should either return 1 (if the record exists in the MySQL DB) or 0 (if the record doesn't exist there). Then, if it's 1, it'll update; if it's 0, it will insert. Fairly simple concept, right? Unfortunately, when I use Get(FoundCount) after my select query, it returns the total number of records in my FileMaker DB. Method 2: Get(LastODBCError) The other idea I had was to run throug…

I am hosting a database on 8.0 advanced server and whenever I use the GROUP BY clause from FMP 8 on a client PC, the server goes to 100% utilization and takes nearly a half hour to return results. Can someone tell me if this behavior is normal for FMP when using GROUP BY. I know it's the GROUP BY clause because when I remove it, the code runs fine (still slow but tolerable). I need to know how to optimize this code so that it executes within seconds or if I am SOL. Any help would be appreciated - thanks! The sql is as follows: SELECT "Asset Inventory"."ProductID", "Asset Inventory"."OrderDate","Asset Inventory"."ProductType","Asset Inventory"."MfgrID" FROM "A…

I have asked my IT staff to create an ODBC frontend to mysql. Our mysql database has about 150 tables. I am wanting to construct a report that will run every day. It will use about 20 tables. They are telling me that filemaker can't programatically select a table. In essence, they are saying they have to select each table manually rather than in a script. Is this correct?

I have a new Filemaker Server 8 Advanced database, which comes with a DataDirect Sequelink driver, which in general has proved to be very good, a big advance on the old Filemaker drivers. But I have one very serious problem with it, which makes it almost unuseable, and I'm wondering if anybody can help me solve it. The problem is setDouble(). Our company is based in Italy, so our Filemaker database is formatted for the italian locale. Thus dates and numbers appear in the database in local format. e.g. 25th November is 25/11/2007, with the month after the day dd/MM/yyyy, and italian numbers appear like this: 345,46 with comma for decimal point, instead …

I am desperately trying to find a solution for connecting FileMaker to a Postgresql database. It is not that it is unable to connect - it connects beautifully via ODBC for Postgresql. But I can only import data which is not very useful. I do need to create FileMaker as a front-end to Postgresql and display data dynamically. I searched everywhere and it does seem that this is not possible, but I was wondering if in spite of this somebody knows of a solution? Many, many thanks, Margita

hello FM forum members, i am a FM novice who has been given the task of linking my companies database to our production graphics server. i have set up according to all the user manuals, but need some guidance as to whether or not im on the right track. here is what i have currently set up -FM server advanced 8 running on dedicated win2000 -ODBC connections turned on and a user account set up for read only access to the file -graphics server is on a seperate box running win2003 server -DataDirect SequeLink Driver installed -User DSN set up as per SequeLink instructions on the Data Source Administrator when i do the test connection in the D…

I have a question that I cannot answer because I don't have the background in IT. It is important for me to understand these questions when I address a committee at my job about a direction we should take (from a user's point of view). We need to develop a solution in house for a particular process from the ground up. A foundation solution was built in FMP 8.5. It isn't perfect but we would like to build on it. (Professional Developer-FMP Partner Level) I've been told by our IT members that we would have to scrap this solution and build something more robust in a ODBC or SQL type database? I want to disagree with this because of the initial solution in FMP se…

I've searched everywhere I know how, and I still have yet to find what I want. We want to pull data from our FM database (on Linux) to a MySQL DB so we then can query the data with other (non FM) tools. The way our Perl script would work is to monitor the FM files and fire off the export routine, using ODBC, when a file changes. But, we can't do this unless we can find a Linux ODBC driver. Does one exist? Thanks! JK

Hi Guys, Ive got my hosted FileMaker database to connect to Word MailMerge using the ODBC functionality in FileMaker Pro 8.5. Everytime Word connects to a FileMaker ODBC source, I get prompted with a username and password dialog. Can I change the connection string so that I can embed the username of the FileMaker client (I have over 200 users in the school). The funny thing is, when you enter your username and password, it asks you to re-key the username and password again for the second time! The first time you enter the username and password in, it adds a UID field in the DSN..... We also use Active Directory with FM External authentication (I have a…

From what i could tell by reading the filemaker ODBC developer guide both GROUP BY and ORDER BY sql statements are supported by filemaker. I am unable to use these two statements together without receiving an error. The statements used separately work painlessly. Anybody else having the same problem? the statment is similar to Select * from table group by item order by total

Hi All, Was wondering how to use 'SELECT TOP n * FROM [tablename]'. Or an equivalent function. Using sequelink odbc driver 5.4 on win2003. Any help would be greatly appreciated!!

Folks, I'm tasked with migrating data from FM Server 8 to SQL Server 2005. I was trying to use the ODBC driver for FM Server, and the SQL Server 2005 Data Import functionality. I keep having odd and inexplicable OLE and COM errors when trying to move the data (less than 100'000 rows - really not a huge amount). Any ideas? Is there another way to do this efficiently (on about 25 tables or so)? What can I check or tweak to make the import work? I have the same problems when trying to migrate the FM data to MS Access 2003, too. Any help would be highly appreciated !

I'm doing lots of applications connecting to FM via ODBC and it's working fine. I just came across another file that I need access to via ODBC and the ODBC sharing for that file was set to off. I've changed it to On and it seems to have the same privilege set as another file that's working fine, but I still can't get access to it via ODBC. Any ideas?

In Access I can use the following SQL statement to return only the last 10 records in the table. SELECT TOP 10 zID FROM Customers FileMaker gives me a parsing error on this. In my research I see that MySQL and Oracle have different syntax for this. Does FileMaker have something I can use for this feature? Any information would be greatly appreciated. Thanks!

Excuse me if i am barking up the wrong tree. I have managed to get an ODBC connection between filemaker and Excel. I can make new records or modify records in filemaker and then refresh the connection in excel for the changes to be made there. However, what I had in mind is to open up an excel file populated with filemaker data. Make changes within excel, and for FMP to update. Can i do this. How? I have been to www.filemaker.com/odbc and to be honest it isn't exactly the most informative area of the site. Any tips/comments would be greatly appreciated. p.s. once i can achieve this in excel i want to move on to Project and do the same there.

Hi all, I am having a minor but critical problem in getting data into SQL Server from FileMaker Pro 7. I have installed the ODBC Drivers (SequeLink 5.4) from the FileMaker site and am able to get all the data over but one particular field is being trunctated to 255 characters. Now I have looked on the web and found that I need to set Max Text Length on the Advanced tab when setting up my data source. Unfortunately that tab is not present. I have definately installed 5.4 and have checked the FileMaker downloads for another version. Any help would be greatly appreciated as I have now spent longer on this that on writing my entire ETL package.

I'm trying to connect to a MySQL (4.0.16) database from FileMaker 8.5. I've downloaded and installed the MySQL ODBC connector from mysql.com and configured it in ODBC Administrator. When I try to specify the datasource in the Execute SQL script step and enter the username and password, I get the following error: ODBC Error:[iODBC][Driver Manager]Specified driver could not be loaded. I've tried different passwords and get the same error. The user I've specified exists and has the proper privs set. I can connect to the MySQL server using any other tool (CocoaMySQL, command line, etc), from any host. Anybody know what I'm doing wrong here? Do I need to config…

Hi all, We have both FMP and SQL Server in our company. Most of my company's data is on FMP. What we are trying to do is have an "Export to PDF" functionality available on the IWP version of our database. We have the database online but the Export script does not work in IWP (its greyed out in web-compatibility). 1) Is there any work-around for this functionality? We are also thinking of having SQL Server as a middle tier between FMP and Web Interface (most probably built in .NET). I have made both FMP and SQL Server talking. I can send and receive data to and from FMP. 2) Is there a way we can automate this process of synchronization so that if we have new da…

I have two questions re OBDC link to Filemaker Pro: 1. We are using SQL calls to write info into a database, and then importing the info into Filemaker Pro. Is there any way to write direct into Filemaker Pro via OBDC? If so, how? 2. Is it possible to do the above importing a graphic file into a container? Thanks, patriciag

I can establish a database connection nicely via JDBC to only one of my Filemaker tables. All other files, I have discovered, are only findable by JDBC if a relationship is established to that first table. This is frustrating because I would like to have 2 separate databases. The relationship to the first table can be completely spurious, using completely unrelated fields, and JDBC is happy. But this is a very untidy solution. I can get a connection to this first file either declaring or not declaring the name of the file (called NuoviContratti incidentally), and jdbc only wants the username and password. So what I am saying is this: If I connect using the…

I have a fairly extensive FM Pro solution used by about 30 staff to document and print (via XSL) student information. It's served using Server 8 Advanced. Recently, our state developed an online system for conducting and recording student meetings - about 6,000 a year. Staff are currently re-entering a large chunk of data back into my FM solution, along with a set of information not contained in the meeting data. I receive a SQL backup of the state hosted meeting data nightly and restore it to SQL Server Express. I'd like to retrieve a subset of my SQL data into my FM solution to keep folks from entering the same data twice, and do it as automatically as possible. I know …

It'll be easy to know more than me about SAP. I know nothing. There's a chance we'll have to tap into the SAP system at our agency. I've tried to find connectivity details about the two working together. Nothing. So, what is SAP based on and can it talk to FM? Or perhaps just export to.

Hi, Does anyone have a WORKING JDBC example (Java code) that connects with Filemaker?? I've been trying for a week ( ) now with the examples Filemaker Server 8.5 has on the disc... Can't get it to work... Please help...

I'm looking to have my FM solution communicate with a SQL based solution. I was told that I need drivers for ODBC DB-OLE. What is the DB-OLE? I looked for drivers and cannot see anything relating to that. Thoughts anyone? M

Our FileMaker system consists of roughly 20 files or so. I've been working with in FM with ODBC for a little bit now and have never come across this issue. Usually, any table occurance displayed in a FM file's relationship screen is available to me via ODBC as a table. Also, any file I open within FM gets added to the Window menu and can be switched to. I have a couple of files that when opened do NOT show up in the Window menu of FMP and they also do NOT show up in my ODBC connections. However, if I go to Open Remote and select my server they show up there just like every other file. I can open it up and it displays perfectly fine in my FMP client. But i…

When querying a calculated field over ODBC I just get a empty result. So any data that is pulled from another database using a calculation basically comes up blank. Right now the only method I have of resolving this is to run a script in FM which copies the calculated values and pushes them into a static field which can be read using ODBC. Is there a way to either access the calculated field directly through ODBC, or automate the execution of said script so that it does not have to be run each time the calculated field information changes?

Hi, I would like to know if it is possible to use ODBC drivers to connect to a FMP 8.0 DB without Filemaker server. If so where do I begin? Thank you Nick

Hi, I have a FM database in FM8.5 advanced and I have created a runtime for distribution. I have an import script that connects to a ODBC SQL data source and imports the required data. After I have created the runtime I try and run the import script and finds that it cancels itself and asks if I want the script to continue. I have run this runtime on my own pc so the ODBC connection should hold true and allow the database to connect and get its data. I have looked to see if it is a permissions error, but I am testing the runtime with full admin permissions to no avail. Has anyone else experienced this? Am I missing something? I have looked i…

I bought the optionpack which now enabled me to enable ODBC access to my hosted databases.. Well on my client computer I set up a datasource as per FM instructions. I can see all the hosted files on the server, and it sucessfully tests to the file I'm trying to access through VB Script. Well when I attempt to retrieve information from the lineItems table that's in the file configured as a windows datasource I get a parse error. What gives? I have tried every possible syntax change in my SQL Query. The parse error comes on the line of code that is Executing the query. Here's my code. Any ideas? It tests find in the windows datasource manager. '--------…

I just installed the Actual Oracle driver through the ODBC administrator (Mac OS X), but nothing shows up in the "Select ODBC data source" window when I try to import records. The connection test in the ODBC administrator is successful, so I know that part is working. How do I get the driver to show up in the ODBC data source window in FMP?

Hi everyone! Here's my problem: I connect from FileMaker to an SQL database to retreive data and display it in FileMaker layout. I do an import data on the odbc connection. Everything works well, but when I need to retrieve only some data (where clause), FileMaker only display table from the odbc connection. I need a select * from odbcTable where odbcTable.field1=fileMakerLayout.field (or =variable)... Thanks!

i'm new to using the 'execute sql' script step and i'm not very well known with sql statements. what i'm trying to to is insert all data in a found set into a mysql database: INSERT INTO MysqlTable( CustID) Values (" & "'"& FMPTable::CustomerID & "'") with this code only the first record is inserted, even though i have 10 records in the found set. doest this mean i need to loop this script step for every record in the found set? or can this be done by modifiying the sql query.

Hi Guys, I'm doing a little bit of testing here regarding FileMaker and SQL based interaction. I've got a MySQL system uploaded onto a web server and I've created a DSN. I've basically got 3 fields in each database (MySQL (table called employees) and FM (table called TestSQL)); name; Text; dob; Date; age; Int(11); I wanted to test out the different field types and how both systems handle them. I've created an Import via ODBC that maps the fields and imports the data from MySQL to FM. This was very easy with the SQL build wizard. Unfortunately, the Execute SQL command (which I presume pushes the data out out of FM into a SQL backend). I cant…

Currently working with JDBC connectivity to mySQL data tables and wanted to share my experience and configuration parameters. If anyone has questions regarding JDBC connectivity to mySQL, please feel free to ask. It would be great it others would share there experiences here. All the best from Prague, Dean. Current set-up which works: PDM SQL Plug-in (www.profdata.nl) -------------------------------------------- mySQL = 3.23(www.mysql.com) JDBC Driver = mm.mysql-2.0.8 (www.mysql.com) ClassPath = C:mm.mysql-2.0.8; FMPro Configuration: SQL Driver = org.gjt.mm.mysql.Driver SQL URL = jdbc:mysql:// -------------------------------------------- …

When I attempt to output an image from a filemaker database 'container' field to the web using ASP, I only get the start of the image - the rest is missing. After a bit of investigation, I found that I receive 2048 characters of the image's binary data. That number seems a little unlikely to be a random thing but I cannot find a setting that lets me increase the limit or remove it completely. Any help much appreciated. Can I really be the first one with this problem ? No mention of it elsewhere on the forums. Thanks -- Pete

Hi, I've been going slightly mad trying to integrate my filemaker solution with a SQLServer database and the latest problem is FileMaker not returning any error msg (via the Get(LastODBCError) script step). Infact it returns nothing! (Don't worry I'm calling it immediately after my execute sql script step). It's quite frustrating as the update i want to perfom on my db is entirely dependant on the error msg I get back. Does anyone know why nothing is being returned? Thanks in advance, Dave

I need to use data retrieved from an Execute SQL script step. My SQL query count the number of records according to a condition, the result will be 0 or 1. How can I tell to FM: if (numberOfRecords From SQL Table = 0) then do something... Thanks!

I know there isn't from FileMaker but is there such thing as a Solaris JDBC Drivers??... All our company webservers are on Solaris (SunOne) but would like to access some data for a low load query from a jsp page. no such thing out there in the 3rd party/open source/bored programmer world?

when i do sql queries to filemaker using a php file that connects with ODBC it takes forever to get the results out. is this something i have to live with or can i make this go faster???

I'm very much a newbie with FM. I've been using MS Access on a Windows machine to make changes to a MySQL database on my web server. Typically, I would used Access by creating linked tables, viewing and editing the data "live". I now work on a Mac with FM7 (no longer have access to Access). What would be the easiest way to set this up in FM7? I have the odbc driver from Actual Technologies and am able to connect to the MySQL database with no problem. What I want to be able to do is... see the entire pricing table (this is an e-commerce website database) and be able to make changes to the "live" data, without having to push-pull. Is this possible. Please exc…

I'm looking for some basic instruction on creating a SQL/ODBC query from a web page. Below is sample from the ODBC/JDBC forum using PHP. Mostly I am uncertain how to code the client location. I am also unfamiliar with how the remaining objects need to be coded(odbc_exec,odbc_fetch etc.). What I really need is a simple primer or tutorial on connecting to FileMaker ODBC data via the web using SQL. Can anyone help? PHP example: <?php $conn = odbc_pconnect(client, user, password); $sql = 'SELECT * FROM Companies WHERE clientnumber=10100'; $rs = odbc_exec($conn, $sql); $row = odbc_fetch_array($rs); print_r($row); ?>

I'm trying to run a simple SQL update via ODBC and I'm getting the following error: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker] (-1) What does this mean? The SQL it's using at the moment is: UPDATE Auctions Set Notes = Notes + ' 10/10/2006 - 2:02:01 PM - Drew Angell: Successfully filed NPB.', Auction_DisputeID = '342343', Auction_Status = 'Loser', Non_Paying_Bidder = 'Yes', Date_NPB_Filed = '10/10/2006' WHERE Auction_ID = '221267' I've also tried removing the single quotes from around the number fields: UPDATE Auctions Set Notes = No…

I know FileMaker, XML/XSLT, JavaScript and SQL. I need to access FileMaker data using SQL via the web. The documentation explains how to enable ODBC, but I need to learn how to write html links and forms to query FileMaker data using SQL. Any suggestions? Thanks!

I have FileMaker 6 and UPS world ship v7 communicating via odbc. UPS World Ship pulls info out of FM6. However I can not get UPS World Ship v7 or v8 to work with FM 8 server or FM 8 locally. I was on the phone with FileMaker yesterday to make sure I configured the driver correctly. When I tested the driver set it worked just fine. When I go to setup UPS it will get as far as asking me for a User name and password and then fails. The error is that this a invalid import. I do not even get to mapping of the fields because of this error. Please help. Has anyone do this successfully? Thank you for your time. Todd Dignan

[color:brown]I would appreciate any guidance on the matter. I am trying to create a two way connection to my SQL server. So far i am able to reeteive my record from SQL but unfortunatly i have not been able upload my records to QSL form Filemaker. Can any one offer a little advice or tell me where imight be able to find related insight? I would like to get this dialed in soon and i figure it can't be that difficult. Thank you all for viewing my post. And thank you in advance, FMP Pros, for all of your help and support. pryjda

can i query fm using sql? if i install an odbc driver can i then use sql to get data out of and into fm? i want to use php file and simply do a: ODBC_connect(dbname, user, password) and then do a: ODBC_query("select * from staff where id = '001';") is this possible? can it be that simple??

Hi all, I have just started using ODBC to send data from Excel to a fileMaker server. Everything was working great until i stumbled upon what I think are a few limitations. FileMaker documentation states that you can SELECT up to 170 fields at one time from a FileMaker file and can UPDATE up to 100 fields at a time. All was working fine until my database table went over 89 fields. At 89 fields SELECT * FROM works well and you can sleect all the fields from the database and go on to update them At 90 and over fields you receive an ODBC error against this line. So I tried splitting my select and update code up into sections so it would only r…

I have a MySQL 5 database. I have a limited PHP web interface to update and display data to & from MySQL. PHP is escaping out ' characters fine, no problem here. My main interface is on Filemaker 8.5. This is where all the data is created and updated. It's working great using import and MySQL commands with Actual Technologies ODBC. HOWEVER it does not escape the ' characters and produces ODBC errors. I've tried the substitute command in Filemaker, but it doesn't substitute ' for '. Not a major problem, just can't use those 's. Any ideas??? THANKS

hi all My FM8 solution manages a regional volleyball competition. Periodically, I want to update the games, results and other things on the web, where the data is stored in MySql tables. For now, I'm calculating SQL queries and copy/paste them in phpMyAdmin. But there should be this "perform SQL query"-thing in ScriptMaker for this, shouldn't it? I was able to set a ODBC-DSN on my Mac (10.4.7) to a local hostet MySql server. But I didn't manage to create a working DSN to put my FM data to a external MySql Server hosted on my ISP. I'm sure somebody has this done before. Thanks for help Gerd

Not sure if this is the correct forum. I am still getting my feet wet around here. Is there way using SQL to push data changes back up to another DB app from FM? So in other words, with ODBC I get info from another DB into FM and then make changes, can I push it back up to the other DB using SQL commands? Thanks

Hey guys, I'm trying to connect to a FM Pro database using ODBC from a Perl script. It works fine if i have the database open and shared in FM client. If i close the client, i get an error message: "database not open". How can i connect to the database without having the client open? thx

Hi all, I have a database running on FMS8Adv ODBC sharing is enabled I have the ODBC client running on my machine I can open up an ODBC cnnection between the 2 no problem. So far so good. What I'm after help on in the next step... I have an excel spreadsheet storing quite a lot of information, what I want to do is add a button to Excel, which when pressed send information from certain cells to the hosted FileMaker database. I know I need to use SQL commands to do this but not sure where to start. has anyone any experience with this who could give me a few pointers, or perhaps point me to a good tutorial? many thanks

Am having a problem connecting FMP 7v3 to Crystal Reports XI using DataDirect Sequelink 5.4 ODCB driver. I recieve the following message in CR: Failed to retrieve data from the database. Details: HY000:[DataDirect][ODBC Sequelink driver][sequelink Client] Network problem, session aborted due to internal error in remote procedure call, connection closed [Database Vendor Code:2217] Some tables work fine, others cause the above error message. I think the problem might be in FileMaker or ODBC - any thoughts?

Is there the possibility to link data contained in a database without importing them (this fuction is available on access)? The database is managed by our contability program which upgrade all the data and data are recheable by odbc. I need to "manipulate" data (create dinamic reports using scripts) without modifing data. System Win 2003 Server Sql server installed Thank you Cristian

Hi, I am new to FileMaker but am an experienced VB.NET/VB/ASP/SQL Server Developer. I am now working for a University where we have many FileMaker databases of varying versions from 5.5 to 7. I am trying to figure out how to query a version 7 database from VB.NET. I have read that I must do it via ODBC. So, I have installed the Version ODBC driver that I got from FileMaker's website. When I go to create a System DSN, these are my only two FileMaker related options: FileMaker Text Driver (*.*) FileMaker Oracle8 Driver Using the Text driver, it only asks for a directory and not a specific .fp7 file. Can someone point me in the righ…

I have been advised that if I want to share data and automate an export to another ODBC client application we will need filemaker server. Is this so?

Hello all. I have a FM7 file/layout with approx 10 fields on it. I want to add two more fields (that are on my SQL Server from another application) I already created the DSN in control panel. I would like to just add these two fields on my FM layout. One of the SQL fields is the same as my key field in FM. How can I do this?

We use Microsoft SQL as a repository for all our data. In my FmP 6 application I used the ODBC connection in FmP to push and pull data from FmP to MS SQL. All worked fine. With version 8, I was hoping to do the pushing and pulling from the MS SQL side. Among other things MS SQL can run scheduled events; I was hoping that it could run out to FmP and get data in the wee hours when I wasn't looking! MS SQL uses what it calls a Linked server to permanently connect to external data sources - other MS SQL servers, Access, ODBC, etc. This works fine. I can even set up a linked server for FmP that actually shows me the FmP tables. But I cannot for the life of me do…

Using php + ODBC. I have a table where each record has a unique id, maintained by filemaker, and i need to know the unique id of the record i just inserted later on the page. Is there an equivalent to MySQL's LAST_INSERT_ID() using filemaker + ODBC? I couldn't find anything on their site. here's a description of LAST_INSERT_ID: http://www.mysqlfreaks.com/statements/90.php As a workaround i suppose could calculat e my own unique id, and not have filemaker do it.

I am trying to add the ability to export data from a 100% java database (HsqlDB) to a FileMaker 8 database in a java application. I am trying to find example java code which shows the jdbc connection specific to using jdbc with Filemaker. I'm having a hard time figuring out how to use the included jdbc driver and I'm hoping some example code would help. Anyone know how to do this? Thanks PD

I have Filemaker Server Advanced running on an Mac OSX server. The same server acts as our webserver. What I would like to do is use PHP to present and edit data through the webserver. With a Windows server I have been able to achieve this using ODBC (Filemaker as the data source, php as the client). From what I have read I believe it is possible to do the same thing on a Mac OSX server, but have not succeded. Filemaker on the Mac is set up to share data through ODBC. ODBC drivers are set up in OS X and checks run through ODBC administrator show a working connection. However, when I try to connect to the ODBC data source through a php script (odbc_con…

Can FileMaker Server 8 Advanced for the mac be used as an ODBC Host? I know it works as a client but how about a host?

Is it possible to use FMP to build a front end that can change the data in an ODBC database? I'm using a program utilizes an ODBC database and I'd like to extend its functionality with FMP.

I've got my web site setup and connected to FM and everything is running great. There are some scripts within these FM files, though, that are activated by pushing a button within FM that activates the FM script. Is there a way to activate that with a command of some sort from a web page? Any information would be greatly appreciated. Thanks!

I have a customer who wants to be able to use Filemaker to pull data out of an AS400. From what I have seen on these forums and elsewhere, it can be done with ODBC. My problem is I don't know what info I need to know about the AS400 to make this work. Plus, once I found that info, how do I make the connection? Is it standard SQL, or something different? Any pointers to info, or advice would be appreciated.

Hi, My company has a web tool that publishes our intranet pages.. I think it works with javascript.. but I'm not sure.. In any case, the web guy told me it does not support PHP, but they can configure ODBC drivers. Could someone tell me how I could educate myself about how to display and update a Filemaker Server 7 or 8-hosted database database by using ODBC ? There are 2 servers I'm interested in talking to: Filemaker Server 7, and Filemaker Server Advanced 8 Any help.. or options you can suggest would be appreciated.. I'm quite clueless about my options.. (from what I had read, it seemed as though most people were using PHP w/XSLT, but I'm n…

If this is in the wrong topic sorry, it was a toss-up between ODBC and scriptmaker. This has to do with using the Frontbase Plugin for automating SQL connections and queries. I open the connection using a differnt command for the plugin and it works. I am having trouble getting the syntax correct for the sql query. In the calculated result in script maker I have: External("FBSQL-Query"; "SELECT OrderQuantity FROM ScheduleShipmentLineItem|||"). If anyone has experience this please help.

Hi all, is it possible to write directly into a FM table from the outside (via odbc connection)? Thanks Berny

Hi, Can anyone help me on how to set the ODBC connectivity in FM6. I am trying to export data into Oracle database from FM6. I am really not sure how to go about setting up the connectivity and aceess the data residing in FM6. Thanks & Ragards Satish

Is there any way filemaker can have a permanent connection through ODBC into sql. So that when new entries come into the SQL Server 2005 they automatically update in filemaker, without using the import function in filemaker. Also if anyone knows of a better way to do this I'm all ears.

Does anyone have any experience hosting databases in Filemaker Server 7 Advanced and activating the ODBC features so that other programs can communicate with the server? I followed all the steps and still no ODBC client can connect to the server. If I run Filemaker Pro 7 instead of the Server, everyone can connect to it, so the problem is with Filemaker Server, not with the clients. Anyone have any tips?

I'm connecting to FM via ODBC from web scripts and inserting, updating, and deleting records via SQL. I've come across a particular field in FM where if I simply try and update it or insert something into it, the web script hangs for awhile and eventually times out. The funny thing is, immediately upon timing out the data that was suppose to get inserted does indeed get inserted. The problem is it takes the length of the scripts timeout setting and you end up at a timeout error page in your browser. The web server is Windows 2003 running IIS 6.0 and the scripting language is ASP VBScript. Every other field I've dealt with in these FM files has worked great except…

Hi I have FM server 5.5 and FM Pro 6 clients. I'll be importing data from an Access database every week via ODBC. I thought it would be best to keep the Access db on the same computer as the FM server in order to make the import as fast as possible and not to have to go across a network, but the problem with that is I then need to install FM Pro on that machine as well, right ? And one shouldnt install FM Pro and FM Server on the same machine, right ? Or can they both be installed on the same machine but just not RUN at the same time ? Or am I going about things in the wrong way - should I store the Access database on a different machine ? Apologi…

Hello I'm trying to connect FM6 with UPS Worldship. I created system DNS with Filemaker Pro driver in ODBC control panel. I launch FM and open the file. I launch WorldShip. It recognize my database, and my table with the fields. I assign the fields from the table with the fields internals of Worldship. And Ok. But when i search for anything in worldship, it can't find any matches... Somebody can help me? Thanks!!!

We're writing to advise that the ODBC Router system has been updated to support FileMaker Pro 8.3 and the brand new ODBC driver manager that Apple included in Mac OS X 10.4.6 (part of their April 2006 Software Update). ODBC Router enables every release of FileMaker Pro from 4.1 through 8.3 on OS X, Classic and Windows to access virtually any SQL database (every revision of DB/2, SQLServer, ORACLE, mySQL, Access and hundreds of other mainframe, mini, Unix and PC databases). Pricing starts at $169 (for an entire network of machines) and the system is available for download now from www.odbcrouter.com

In the Win XP Control Panels/Administrative Tools/Data Sources ODBC I can make a successful ODBC connection to my database when hosted by FMP7 or FMD7 but not when hosted by FMP8 or FMPA8.... aaargh! The message I get is "SequelLink Error: 2309 ... TCP/IP connection refused" Has anyone else come across this? I'm using the DataDirect 32-BIT SequekLink 5.4 ODBC driver as supplied on my FMPA8 installation disk. I'm read, reread and reread the instructions in the FMPA8 developers guide and I can see no difference in the set up from version 7. I've checked a 100 times that the file is set to share via ODBC, I've even tried uninstalling and reinstalling the drive…

Here's my insert command: INSERT INTO Customers (BillingName, BillingAddress1, BillingAddress2, BillingCity, BillingState, BillingZipCode, BillingCountry, PhoneNumber1, BillingCompanyName, PhoneNumber2, ShippingName, ShippingAddress1, ShippingAddress2, ShippingCity, Shipping State, ShippingZipCode, ShippingCountry, EmailAddress) VALUES (Andrew Angell, 805 E. 14th Ave., House, Lee's Summit, MO, 64030, United States, (816) 256-3866, Angell EYE Designs, (816) 256-3866, Andrew Angell, 805 E. 14th Ave., House, Lee's Summit, MO, 64030, United States, [email protected]) And I'm getting: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [DataDir…

Ok, I've a quite big problem for which I couldn't find a solution yet. I've a FM8-DB with ODBC-connection on and with the drivers from http://www.filemaker.com/odbc The connection is working, tested with iODBC and also with FmPro Worksheet 1.04 from .com Solutions. There I can also do queries which are working correctly. Now to the problem. In my DB I have two fields, a number-field and a text-field. I have 42 records in it. When I do the following query with odbc_exec: "SELECT ID FROM dns" it works perfectly and I get all the numbers. When I do: "SELECT text FROM dns" I don't get the first 9 datasets. When I add another dataset I just don't g…

I was developing on my WinXP Pro desktop. I have 2 ODBC entries registered in my Windows Data Source Control Panel. (ALPINEODBC & SBTODBC) I have a couple scripts that import data from these 2 data sources, and they work fine when I have the database running locally... but now that I have put the database on a trial version of FM8SVR it wont import from the databases. It gives me an error of: "There are less records in the data source than in the target table. Not all records were updated" Any ideas?

In the past I've successfully used Filemaker with my ASP applications by installing the DataDirect ODBC driver. It worked great with Filemaker 7. I just got some Filemaker 8 files, though, that I'm getting back into this and I'm having trouble with the ODBC for some reason now. The files are the same exact files that I used with 7, but have been upgraded to 8. There are about 5 different Filemaker files that I use, and with Filemaker 7, each of these would show up during the creation of the System DSN when I went to select the Data Source. Now, though, only 2 are showing up here no matter what I have open. It shows Auctions, which is only 1 of the Filemaker files I'…

Hi. I’m new here. I have a database that eventually is to run on FileMaker 8 server. One of the part of the solution the user wants are these forms. They have these forms in Microsoft Word and what they would like is each new record to generate the forms in Word (not in FileMaker) and then have the form file saved for each record that they can then edit. (They have fields on the form they do not want stored in the database) I thought the best solution for this would be to do it connecting with ODBC drivers. I finally got the drivers installed properly but still have not been able to get the connection to work properly and this is just in a stand alone setup. So…

Hi, We are attempting to move data between FileMaker version 6 and HandDBase via ODBC Import, Export. We are receiving the following error messages. Export "HanDBase to ODBC failed. ODBC Error was [FileMaker][ODBC FileMaker Pro driver] Create Table statement is not supported" Import "Import from ODBC failed. ODBC Error was [FileMaker][ODBC FileMaker Pro driver] Cannot open table" The process seems like it should be very straightforward. We created a data source for the FileMaker file. This file correctly appears as the import table data source. Our current FileMaker ODBC driver is version 3.60.00.00, file FMFMP50.DLL, dated 4/16/01. Is there …

Hi, A similar question was asked, but the responses have been dry. Hope someone can help me on this. I've been developing on MS Access for quite some time now, and recently I have been asked to do a few things with FileMaker Pro. With MS Access, I've been using Access as the front end client (with all the business logic), and MS SQL Server Database as the back end database / data repository. This was achieved by 'linking' the SQL Server tables via ODBC (system / user DNS) - this integration ability is seamless and logical, especially for scalable deployment. As I'm hoping to duplicate this deployment model for FileMaker Pro - i.e. use FileMaker P…

anyone out there know and have used filemakerpro with a mySQL database? not just a query, but actually sharing the database, so that if i edit on fmpro, updates the SQL db and vice versa. can this be done with this version of fmpro 6? if so, can you explain how to do this? (not just import export but dynamically sharing the dbase)

I'm certain I've hit a limitation of the jdbc driver that comes with FileMaker 8 (SegueLink 5.4), but I'm wondering what limitation exactly I'm hitting. I've gotten pretty far, and here is what I'm currently doing: I'm running FileMaker 8 Server Advanced 8.0v2 with the jdbc driver installed and configured successfully. I've downloaded WebLogic 9.1 and configured a Data Source successfully to connect to the FileMaker 8 Server. Once this hurtle was crossed, I made a simple JSP page to pull some data from a sample database and simply display it. This test was quite crude, but established the fact that I had a working connection. Now, I'm not a java/jsp/weblo…

SequeLink Error: 3061 [DataDirect][ODBC SequeLink driver][sequeLink Server]Authorisation failure. I'm trying to connect to a FilemMaker Pro 8 database over the network using ODBC. The "DataDirect SequeLink for ODBC Setup" or "Connect to the SequeLink Server" dialog does not prompt for a Database User Name and Password when I press the "..." button. I've searched online and it seems like other people are having the same problem without a solution. How do I connect to the database over a network with ODBC?

I'm trying to setup a FileMaker script to import records from a MSSQL database via a calculated SQL query in an Import Records script step. The problem is in the "Import Field Mapping" screen, it does not show field names or data from the ODBC source. If I run the scrip with the default map it imports the fields with no errors returned. The odd part is that I thought it was working properly just yesterday when I was doing some tests. Here is my calculated query: "SELECT RecordId, TimeIn, TimeOut FROM EmployeeHours WHERE UTCDateModified >= '" & Punches::LastImport & "'"

Hello – I program and maintain a handful of intranet web-based applications. These are all built using ASP.NET and run on IIS on a Windows 2000 server. I have been handed a couple of Filemaker databases with the hopes that I can utilize their data in our applications, while keeping them in Filemaker format. It appears that this is possible using the ODBC drivers that come with Filemaker Server. Where I’m concerned however, is that these databases utilize container fields that store a variety of document types. (Mostly MS Word and Adobe PDF.) It is hoped that the files in this database can be available for a user to download through the web application. The…

OK...here goes!...dont shoot me for asking!!!... I have an oracle db which maintains the explicit path to a stored PDF (on a storage raid system). which i use to view a thumbnail of the PDF on another system i use. I want to also be able to view this thumbnail in my Filemaker Pro 8 Adv database. Is this possible using ODBC or any other method to 'get' this explicit path and pull it in to my FM Pro 8 Adv db (in a container field or any type of field)? Thanks in advance.

Hi, I am using the "Actual Technologies" ODBC driver to import data from a MySQL database to an FM 7 DB (using MySQL 4.1, Mac 10.4.2, FM7). All columns import just fine , except one. I have a MySQL text column that I am trying to import into an FM text column and I am receiving an error in the FM 7 import field (text.dat) instead of the actual data. I am positive it has to do with the query. I am currently using a SELECT * .....and I think that I am going to have to modify the query a bit for that particular column ......trouble is ...I do not know how .... Anybody out there know?

I got FileMaker pro 8 running on the Macintosh machine, and it hosted some database files there. Can I access these files through ODBC in other apps but FileMaker pro on the Windows machine? I don't have FileMaker pro on Windows machine, and I want to use Delphi to develop a new app through ODBC driver to connect the FileMaker database on the Macintosh. Is it reasonable? Thanks in advance.

Greetings, I would like to be able to link up FMP DB tables with JMP, the SAS Institute Stats analysis and graphics application. Does anyone have experience doing this? Is their an available ODBC driver that would allow this? Thanx in advance for anyone providing advice and info. .../jsa John Abrams, PhD