External Data Sources

Im new to FileMaker development and have a few (simple) questions. First, what does one need to have ODBC capabilities with FM data. For instance I want the ability to query FM data through excel spreadsheets, SQL DTS, etc. I installed FM Server 8 and Server 8 Web Publishing. Do I need another disc? Please help me get started!

I am trying to create an ODBC connection to FM pro 5.5 file to migrate data to Access. I follow the necessary instructions by configuring the ODBC control panel and configuring the FM pro file for sharing. In the ODBC data source administrator, system DSN tab, I select the Filemaker Pro ODBC driver. In the general tab I specify the FMP filename in data source name but when I try to use this in another application, it gives me an ODBC call failed error. I’ve tried specifying the path of the file in the data source name but it doesn’t allow me. I’ve also tried using File DSN and User DSN with but get the same errors with both What am I doing wrong? When speci…

Hi, a bit of a newb to filemaker & SQL but have got things working ok I'm using the Actual ODBC Driver Pack with FM8 I can connect to my mysql database and insert into tables etc. I have a field in my FM database that is based on a value list probably a silly question but how do I remove line breaks from my value list output so it doesnt break my sql query? any thoughts much appreciated cheers! Peter

We have an SQL database that stores shipping information from FedEx. Everytime a shipment is generated, the SQL table in the database is updated with that shipment's information. Once the data appears in the SQL table, is there a way to write the data from the SQL table to a table in FM as they appear in the SQL table? Update on 02/24/2006: Found a topic about this very thing and all signs point to "not really". I read about a "robot" machine that Wim Decorte suggested and will look into that a little more. Still will leave this topic open in case someone gets a spark of brilliance.

If anyone happens to know, I am looking for a live connection (real-time) to a SQL database via FM. Can this be done? Pretty much every record that goes into FM also inserts into the SQL database. Vice Versa too. Every record that is inserted into the sql database through a different program automatically be entered into FM (real-time). I don't expect one person to know the answers to all of this, but if you know anything about the above mentioned, please leave your input as it is greatly appreciated. Thanks.

Hi all, Simple question I hope. Setup Filemaker Server 8 with ODBC connection to our online web server with MySQL. I can INSERT into MySQL directly from a script on FM ... very handy! But, what happens to the data from a SELECT query using the standard Execute SQL script step? Is it possible to feed the results into variables. I know about the import from ODBC options but need some more control over the data. I guess importing everything into a temp database and then work from there would work, but not ideal. Thanks Matt

Hi, Question - anyone tried to have a database which feeds sales data into SAP? SAP has a rubbish program called MSA which is installed on laptops and handhelds of Sales agents - clunky old peice of crap software. It then does something called CONTRANNSing which is to synchronise with CRM within SAP. Anyone ever tried to create a FileMaker solution which bolts onto SAP as middleware? Can it be done? Anyone have any idea the type of data that SAP wants to import?

In Dreamweaver 8 i use a dsn connection to conect to a file maker 8 database which works. However when i look at the tables they are listed as null.tablename. I can still see all the fields of each table despite the null at the front of the table names. When i try to create a recordset it gives me an error that reads: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Table Not Found: null. My server is running Windows 2000 SP4 with MDAC 2.6 SP2 I'm using the "DataDirect 32-Bit SequeLink 5.4" ODBC Driver Can anybody help?

Hi, I have a MySQL table on a MacOSX 10.4 server and Filemaker Pro Server 7. I am using the "Actual Technologies" ODBC driver for this project. I have a number of fields I am trying to import from MySQL into a client FM DB. The Problem: Two of the MySQL fields are formatted as DATETIME and they serve as a creation and update AUTO-ENTER fields using the NOW() MySQL function. The fields are auto filled with a string that looks like this 20060125132456 (yr, m, d, hr, sec) ....when using the FM ODBC importer these two fields import and look like this 365: 12: 23 .....all other import fields work perfectly..I have tried changing around FM field types...nothing se…

I would like to set up an ODBC connection from another software package (running as a cmd-line program, but with an ODBC connection routine) to a filemaker pro 8 database. I have ODBC admin tool from apple (macos 10.4.4), but I have yet to find a place that describes EXACTLY how to set up the connection. Could someone point me in the right direction? Thanks, Sean

I want to connect to my FileMaker 8 Server advanced, and have enabled JDBC serving on the server. In my Java program, I need to specify driver and url. I found in the FileMaker JDBC documentation, that the URL should be: jdbc:sequelink://192.0.1.202:2399 (192.0.1.202 is the IP address to my server) I tried this driver string: com.ddtek.jdbc.sequelink.SequeLinkDriver but I got this when trying to connect: java.lang.ClassNotFoundException: com.ddtek.jdbc.sequelink.SequeLinkDriver Have anyone done this?

When trying to access FileMaker Pro 7 via ODBC, I am using a third party product (a canned solution) which references a field called "OID" in any table I try to access; I have such a field in my tables in FileMaker Pro, but when an SQL query references that field, it generates an error message to the effect of "Parse Error in SQL". For example, in one table, there are numeric fields called "jobID" and "OID". The query: select * from HVACs where (jobID <> 0) works perfectly; however, the query: select * from HVACs where (OID <> 0) results in a dialog box with the "Parse Error in SQL" message (and fails). I must be able to run a…

we have a filemaker pro server and some of the data needs to be imported weekly into an oracle database. my understanding is this can be done and it is roughed out in the "FileMaker 7 ODBC and JDBC Developer's Guide"...available here if anyone is interested: FileMaker Documentation however, i know nothing about oracle, but i don't need to since there are people on staff to deal with that. i am presenting this connection option as the best way for the oracle guys here to get the data they need. the other option is for them (non-filemaker savvy people) doing exports and importing them into oracle. they don't want to do this because they don't like filemaker. i…

I am working with a developer who is supplying us with a rate server for shipping quotes. The problem is when we try to update a record via ODBC (System DSN). It connects fine, it searches fine, but when it goes to update it triggers the summarizing Field "FIELD_NAME" in Filemaker. The summary fields are not on the layout, and it is summarizing for EVERY record in the DB. Please help, this is driving me nuts! New info: Although there are no related field on the layout that is showing, FIlemaker opens every database with a related field prior to starting the summary. Almost ready to give up... Desperate... Help....

Hi all, I've just started a new job, part of which is to make a nice snazzy front end for some external customers to access a small part of the massive FMPro database here. I hadn't seen FMP before i came here and i must say i do like it but for this one purpose i would like to use Microsoft's Visual Web Developer Express edition which they are giving away for a year. My problem is that when i make an ODBC connection using either DSN or fileDSN i can use it perfectly with Excel but as when i try to use it from VWD i get to the point of being able to choose which fields i want to include but when i click the button to try the query or if i just go ahead and load …

Hi - I've followed FM instructions for installing the ODBC driver for Windows. Following installation, I can't see the driver in the 'driver's tab, yet when I open registry it's there. FM instructions say to install/reinstall and if that doesn't work to delete the 'default' entry in registry editor for the driver. Reinstallation changed nothing, and I'm unable to delete the 'default' line from the registry (though I can the value of the default option). Your thoughts on how to make the driver visible are very welcome. Thanks for your time and assistance. . Steve

Hi everyone. I'm having a problem with a JDBC connection to a FileMaker database. In a nutshell, I have a table with about 300,000 records in it, that I am using for large data set testing. Searches/queries to this data are very snappy, both from FileMaker and JDBC, except for when I do something like this: SELECT t0.Column1, t0.Column2, t0.Column3 FROM Table t0 WHERE (t0. Column1 = 200000016 OR t0. Column1 = 200000029) Note that Column1 is indexed, and searches on it from the FileMaker GUI are very fast. Additionally, this query runs as quickly as I would expect it to when only searching t0.Column1 = X, but WITHOUT the second qualifier. However, as soon as I a…

Who can tell me, how can i get data from FM tables to Java programm. I will be very gratefull for any suggestion. I dont know anythink in this way. In Java i am new user. I shall be very grateful.

Hopefully this is easy. I am new to using the ODBC connections. I want to use Filemaker to pull data from an existing SQL database. Simple enought to do when there are 2 tables involved. I am stuck trying to figure out how to tell filemaker I want to join more than one table? If anyone could point me in the right direction I would be very greatful.

I am receiving an error when trying to insert in the following SQL statement via the FileMaker ODBC Driver from within Visual Basic 6. The SQL Insert Statement is this: Insert INTO timer (PassingTime, TransponderID, Hits, Strength, LocationID) VALUES (44796001, 'LK-99381', 0, 0, '123') The Table within FileMaker appears to be correct with the following setup Table Name: timer Field Name Type PassingID Number - Auto enter Serial PassingTime Number TransponderID Text Hits Number Strength Number LocationID Text The error i receive within Visual Basic is this: Error -2147467259 ([Dat…

Has anyone declared and set a variable before a select statement and then used that variable in the select statement with no errors (see below)? I am trying to do this in a SQL 2000 Server db. Declare @title AS varchar (25) SET @title = 'COUNSEL' SELECT * FROM timekeep WHERE tktitle = @title

To make my lengthy calculated SQL statements easier to read I tried using the delcare and set functions (see example below ) so that I would only have to do one concatenation for each variable passed to the SQL statement from FM. Now when I execute this statement I get an error that says there were "No variables defined in the data source". What does this mean and how do I fix it? "Declare @startdate as datetime Set @startdate = '" & table_name::field_name & "'...

I am trying to import from a ODBC data source. When I create the sql statement using a calculation the Query fails. If I take the results of that calc and put them into the FM Query Builder, the Query works like a champ. Any ideas? Here is an example of my calc. Let([ pr = "."; tblcovers = Quote("tblcovers") & pr; C1 = Quote("C1") & pr; C2 = Quote("C2") & pr; C3 = Quote("C3") & pr; C4 = Quote("C4") & pr; C5 = Quote("C5") & pr; C6 = Quote("C6") & pr; CoverColorID = Quote("CoverColorID"); tblCoverColors = Quote ("tblCoverColors") ]; "SELECT " & Quote("tblCovers") & pr & "*" & ", " &am…

Here is my problem: I created a FM7 file to retrieve data via ODBC from a series of Access tables, the solution works well on all my Microsoft Windows XP machines. However I have one Windows 98 machine still in service on our network. I need to run this solution on that machine. I do not have FM7 Developer, and understand it can compile FM7 files to a stand alone application. If this is correct this may be my solution. I do not know how difficult this would be to compile, nor if this is an appropriator request to make. But it never hurts to ask, so here I go. Would someone be willing to look at my file and possibly recompile it to a stand alone application . Or if there…

I'm using Matlab's database toolbox and the ODBC driver to push and pull data from my FMP 7 database. Data from number fields are always rounded to the nearest tens when returned to Matlab. e.g. a value of 123 in my database is returned as 120 in my Matlab workspace. All numbers in Matlab are returned as double floats so there shouldn't be round off erorr. Does anyone have any experience with this? thanks in advance nate

Hi, I´m trying to make an ODBC connection using the SequeLink.bundle driver from FileMaker. I´m running OS X (10.4.3), FM7 and the iDOBC administrator from OpenLink. I followed the instructions from fm7_odbc_jdbc-developer.pdf from FileMaker, I´m using the path Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk18.dylib to add the driver as system. But when I want to add the DSN I get the error "Could not load the driver o translator setup library" I can add the driver and the connection using the Mac ODBC admin. but the FM doesn´t recognize it. Somebody knows what I´m doing or what could be wrong? Thanx

How do I import data from an Access '97 database using ODBC to FileMaker 6,7 or 8 Advanced? I can do this easily using Windows XP and FileMaker 6--but I haven't figured out how to do it--or if it's possible to do it using OS X. Thanks in advance!

Hello all, I am about to update two FM7 tables via an ODBC connection, and need some advice. The tables consist of customers and products. I only need to update the existing records and then add any new records. Problem: After I choose the Update existing records in found set, and check the Add remaining data as new records FM appends to my database. I started with 513 records and ended up with 1056. There were only 30 new customers that should've been added. Did I miss a step? The ODBC source is coming from as AS/400 file. Any advice will be appreciated. Thanks!!!

Hi there.... I have a though nut to crack: we use FM7 on mac as a ODBC datasource for Indesign(plugin) works nice. Eveything works except the update statement for the German content. In other words: i get an errormessage when i want to update the german text (or text with ü, ö etc) from Indesign (plugin) via ODBC into FM 7. ANY help is welcome!! (english text works fine!!! and german text flows correct into Indesign!) Greetings, Marcel.

Here is my problem I need to dynamically update FM7 table records from a series of Access Tables. I presently can, via ODBC import the entire table(s) into FM7, this is being done by a manually run script executed by the user. The user needs to do this often to keep the FM7 data current. What I really want to do is filter the import based on data from my FM7 table. Is there a way to query the Access Table from a FM7 data field, for just the one relevant Access record via the keyfield, and import just that record. Details: I have two Access Tables, "Job_Number" keyfield is "Job_Num" and "Job_Operation" keyfields are "Job_OpNum and "Job_Num". New…

Hi All I've been trying to setup a FM8 database to supply data dynamically via coldfusion. Why? Well I'm used to CF from the dreamweaver GUI end, so it makes some sense for me to make some DSN connections and design my sites the way i always have, while still benefiting from FMP at the database end rather than learning mySQL from scratch. Now I've got the JDBC driver installed into CF7, no problem. I've gotthe class, and the JDBC URL from the driver docs and the guys at macromedia. I'm so close I can taste it - and if you read the macromedia boards you'd think this was a holy grail. However, I have one final problem to surmount. When i verify my…

I'm having problem with inserting or updating data from FM 7 to MySQL via ODBC. Sometimes i get error message "failed to allocate statement". It's a bit frustrating if i'm inserting hundreds of rows and then figuring out which one was left out... Any ideas what is causing this?

***My problem:*** [OS X (10.3.9) client, FileMaker Pro 7v.3, Office for Mac X (v. 10.1.6), Microsoft Query, firewall disabled, TCP/IP enabled in FileMaker 7] ***My goal:*** Installing and configuring ODBC drivers for Mac OS X (Panther) for use with Microsoft Excel (updated to X.1.6). Specifically, I want to use my FileMaker Pro 7 database as a data source for Microsoft Excel files. Generally, I'm looking to troubleshoot ODBC installation and configuration in OSX for use with PHP, Oracle and other solutions where FileMaker may be a client or a data source. ****My process:**** 1.) Clean install of FileMaker 7v.3 Pro. [did NOT run ODBC import …

I went through an example from a book I bought that imports data into FileMaker Pro using ODBC. My question is can you send data out to an Excel page? I tried and I was getting errors. I need to send data out that can be printed from Excel. When I tried to get Excel to collect the data throught ODBC from FileMaker it came up saying that I was not authorized by Data-Direct Technologies to do it and then it moved on and let me do it, but no data came up. Any ideas?

I have an importing script that uses ODBC when I use in my FM 7 Developer (full running version) and the records that I'm importing from an ODBC DB works just fine. When I create a Run-Time solution that same script fails. The ODBC driver name and settings are exactly the same (because I test it on the same machine as the full version of FM 7 Dev.) The error I'm getting is "Import Records has been Canceled. Do you wish to continue with this Script?" Can it be that the ODBC is incompatable with the runtime soulution. If so, does anyone have a workaround? Thanks

When I attempt to read a FoxPro free table from FileMaker 8 with ODBC my where clause will find the record I'm looking for only if it is within the first 2130 records of the FoxPro table. Is this possibly a known problem with FileMaker? I'm thinking it is probably a corrupt index in FoxPro because if I remove the where clause altogether it gets all the records. Any advice? Thanks, Jim

I've just installed the ODBC driver from the FMP 7 Dev CD per the instructions, but the driver, "DataDirect 32-bit ..." doesn't show up in the list of available drivers in the Data Source Administrator. I'm running Win XP SP2 and have rebooted since installing. The install directory is there as expected. Any suggestions? Thanks in advance.

Can I use ODBC/JDBC without Filemaker Server Advanced 7? I have filemaker pro 7 database. It must run with MAC and Windows. How can I get it?

I was wondering if I plan to have my database files accessed by ODBC or JDBC, can I have spaces in the relationship names of the FM databases? I know not to have weird chars and spaces in field and table names. Use only underscores in place of a spaces. Are these rules for field and tables the same for relations? Or can I omit the rules, because ODBC and JDBC do not interact with FM's relationships.

I'm trying to use the Filemaker Dashboard Widget available from http://www.filemaker.com/support/downloads/tech_preview/index.html and while I was able to get the widget to work with the demo file on FileMaker Pro on my local computer, I can not get the widget to see the database on our FileMaker Server Advanced system (on OS X). Seems to me that I don't have JDBC properly running on the server (I had to install a JDBC plug-in on my FileMaker Pro setup to get it working locally), but I don't know how to do this. Has anyone been able to use the dashboard widget with FMSA running on OS X? Thanks.

Anyone have any ideas what this might be? Hi all, I'm having some wierd ODBC issues. These issues didn't show up until we attempted to move our program onto a real production server. My program (a Windows Service, written in C# using ADO.Net) watches for files, parses them, then attempts to find and update a record using FM 6 Unlimited's ODBC Local Data Access compaion. Usually things go fine; sometimes however, FM 6 reports that no records match the criteria (even though there ARE records that should match), we get a Field Not found error, or we get some other kind of error such as ERROR [HY000] [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Re…

Hi there, I have a client who is attempting to install the PDM SQL Plugin on FM Pro 5.5, running on OSX. He downloaded an ODBC driver and set up data source to an external MS SQL database. However, when he tries to call/connect to this data source from filemaker, he's getting this error: EXCEPTION java.lang.NullPointerException PDM SQL is supposed to be jdbc/odbc compatible, so I'm not sure whether we need one or both to be set up. I was assuming odbc would be fine, same as on a PC. I'm not very familiar with OSX. On PCs, it's very simple, you just set up the Data Source and the plugin connects to it. Anyone have answers or direction on OS…

I've finally got some free time to work on an ODBC project that I've been meaning to do for some time. My purpose of this posting is certainly not to have someone else do the work, but rather get suggestions and direction on the best way to make this work, from others that have done something simular. I've got a good understanding of ODBC commands and how to set up the drivers, etc... My solution has multiple tables, about 20 of them have actual information that I would want to pull/push from. I would estimate 1,500 individual fields from these 20 tables are going to be used for this operation. So in other words, there is a lot of information I want to …

I'm having a horrible time trying to figure out how to query data from a FileMaker database using ColdFusion. I've managed to set up a datasource linking to the FileMaker Pro database with "ODBC Socket" as the driver, but when I try to run a simple SELECT query, I get this error: [Macromedia][sequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL My select query is simply: SELECT * FROM testODBC There are only three fields in the database, two text fields and a number field. I've tried querying one field at a time, and when I query one of the text fields I g…

Help! I'm trying to set up ODBC on FMP 7. Heres what I did: Installed MDAC 2.8, the database is on the local machine, the odbc sharing is enable for All users, I'm using port 2399, Network sharing is also enable but I dont think it has anythign to do with ODBC. I get error 2306 "[datadirect][ODBC Sequelink driver][sqequelink] TCP/IP error, connection refused" when I use 127.0.0.1, localhost or the ip address of the machine in the "SequeLink Server Host:" field. Additional note: I used MySQL to create the same database and was able succesfully do a test connection and prcoess queries via ODBC, so I don't think is my machine. Please point me at the right d…

I need to access a Filemaker Pro 7 database via ODBC, but cannot figure out how to share the db via odbc. Filemaker help says to share by selecting Edit>Sharing>ODBC/JDBC. The problem? That menu choice does not exist (I am using FM PRo 7 Developer). Only Filemaker Network and IWP options are available. I have enabled ODBC permissions and made an ODBC driver using the DataDirect 32-BIT SequeLink 5.4 driver. But until I can share the file with ODBC, I cannot connect to Filemaker as a data source. I have also searched Filemaker's online Knowledge base without success. Any help is greatly appreciated.

I have an sql query which works fine when the query is pasted into the import box, however I want to do a calculation where the last 5 digits are a job number which changes like this SELECT "JobDescription"."JobNo", "JobDescription"."Description" FROM "JobDescription" WHERE "JobDescription"."JobNo" = XXXXX where XXXXX is my job number which changes but I cannot get it to work as a calculation either by pasting the above text plus the job no. field or by creating a field which holds the result and using that in the calculation. Sorry if a little muddled first few steps into Filemaker and SQL

Hello all, I updated a table via ODBC and now when I run my reports the records no longer show up. I tried creating a new table and imported the records again, then created a relationship, but still nothing will come over. I did notice that in the first field that along w/ my data there was this in the field: ģЈH:FilemakerNEW DATA 031605Backup Database July 12Filemaker 7 Graphics DB I then did a find and replace and after it replaced everything the table blew up and said I had to recover it. Now I have two tables, the original and one that says recovered, which one do I use, does the recovered table replace the original now? Someone please help!!!

Hello, I'm brand new to FM Pro. (one hour brand new to the demo). I have a test database running on MySQL that can be accessed from MS Access through ODBC. When updates are made in MS Access they appear immediately in MySQL. MS Access considers this "linked" or linking to the table instead of replicating the database to the local drive. I've setup FM Pro using the same ODBC design. However, when I create the connection I'm prompted for a filename and the data is saved locally. I really don't know if/how updates are being sent back to the database on the MySQL server. Is it possible to use FM Pro as a user interface to a remote MySQL database and have up…

I have created a simple contact database in order to learn about JDBC programming. Three tables... Names Phones PhoneTypes So far I have been able to connect to the database. However when I try to execute a SQL command, I receive the following error... [DataDirect][sequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL I know the statement I'm executing in correct it is simply SELECT * FROM NAMES my goal is just to retrieve data for testing purposes. My database is set to share via ODBC/JDBC, the account I log in with has full access to the db, and I've just downloaded the lasted J…

Hi. does anyone know where i can download a jdbc driver for filemaker. I have search on filemaker.com but can't find anything

Hi there! I have got the ODBC thing working perfectly, but I can't seem to guess the keyword in the DSN for the password, so it always pops up that annoying dialogue box for user name and password. Obviously this is not ideal for an automated solution, so can anyone tell me how to avoid it? My configuration for the DSN Test is as follows: Host 127.0.0.1 Port 2399 ServerDataSource TestDB LogonID admin password admin Thanks in advance! Cheers, Chris W.

I was hoping someone out there can help me out... I'm trying to set up a connection to a FM database through JDBC. I have installed the JDBC driver according the user docs, ie, into my bin folder that contains java.exe. I'm using java jdk 1.5 in the Eclipse enviroment... However, when I run a simple app to test the connection, I receive an exception stating... "java.lang.ClassNotFoundException: com.ddtek.jdbc.sequelink.SequeLinkDriver" It seems to me that the app can not see the driver, or that the driver is not compatible with JDK 1.5? Has anyone encountered these issues before? Below is the code I'm using to try to connect to the dat…

Hi you all.... I need some help form some pro's!!! This is the situation: we have mac clients and a mac server. A (homemade) FM database ("Mainmodule") is our CMS running on the server (each client connects to the server for FM(CMS) and the Indesign workfolder). This CMS is the content of our catalogue. We use a plugin in Indesign to extract the data from filemaker, into Indesign. Now this is done through a snapshop file. However I want to use the ODBC function of the plugin to link Indesign directly to Filemaker: bi-directional. With the plugin comes a ODBC dataprovider. Now my question: WHAT must i do to get this to work? What must i do on the serverside and what…

I have a series of scripts that I use to bring records from a MySQL 4.0 database into a Filemaker 7 database. About every couple of months I have to go back to the import portion of the scripts and step through them again. What I mean by this is editing the script, selecting the ODBC, verifying the logon and password to the MySQL DB, looking at the files to transfer and selecting OK. Nothing seems to change as far as what was placed in the script it just seems to loose it way. In the master script there are about 6 different Import scripts, all importing from a different MySQL table into a different Filemaker Table, and when this happens only one of t…

Hi. I am trying to connect to filemaker from a jsp web site. I have set up the odbc connection and it works fine from excel. When i try to connect from my jsp site i get an error " database not open" The web companion is enable and i have shared the database.

Hi all, I need some help. I

Can I run online my filemaker pro 7 database with only Filemaker Server 7 installed (without FM Pro 7 and FMSA 7) and using ODBC/JDBC and PHP or JavaScript? And I need many connections (not 5) and good desogn (not like Instant Web Publishing) I need it working with MAC.

FMP 7.0v3, Actual ODBC drivers, MacOS X Tiger Apple seems to have changed the locale settings in 10.4. FileMaker ignores any number format in ODBC/ex/Import, while it formats dates and times correctly in current locale. so 100.0000 reads as 10000000 when using a comma (,) as decimal separator. Strange thing, in Tiger you can set date & time formats, but NOT change the decimal separators in the prefpane for any given locale. Any solution apart from quitting FileMaker, set the MacOS to US, import, quit, set OS to DE, restart database?

Ok, maybe if I feign ignorance someone will have pity and answer a question for me in this forum. That was meant to be humorous sarcasm. I am actually just glad that I have somewhere to put all of my questions where there is a chance that someone will see them that might know the answer. I am working on a (hopefully) cross platform conversion tool that transmits data between FMP 5.0 and another binary file format. If am able to use ODBC on the Mac then I feel pretty confident that it will work out. So, ODBC works on a Mac, right? Michael

Hi everyone! Can anyone public a exemple of how i execute a script in FM over a JDBC connection?

HI, I wonder anyone out there who has been intergrate FMP with Coldfusion? or know any resource that I can contact or review Thank you in advance.

I am attempting to set up an ODBC connection so that I can get a Filemaker 6 database maintain a Filemaker 7 file hosted on a FMP7 advanced. I am using the ODBC client driver from the FMP7 Pro CD on my WIN 2000 machine. I can start the configuration process but when I try and test the connection, I get an error dialog box titled Sequelink Error: 2306 [DataDirect][ODBC Sequelink Driver][sequelink Client]TCP/IP error, connection refused. As far as I can determine, this is an error at the FMP7 end - it apparently relates to the number of concurrent connections but the server is very lightly used and presently hosts several databases. One of these supports a CWP app…

Does anyone have experience with QODBC? I am succesfully importing into FM using the Import command, but when I try to script it, I am not getting any results. Thanks in advance for any help!

I need to inner join 2 tables using JDBC.I am using SQL Server database and my tablenames are BS_1137_2_8 and ReservedInventory and I am using following code: String str="select top 1 t1.ticketinfo , t1.seat from BS_1137_1_28 t1"; str+="inner join ReservedInventory RI1 on t1.ticketinfo=RI1.id and " + "RI1.status=-1"; ResultSet rs=stmt.executeQuery(str); When I run the program then it gives error saying that colum prefix t1 does not match with a table name or alias name used in the query.Though I have given alias t1 to table BS_1137_2_8 and when I execute only this part "select top 1 t1.ticketinfo , t1.seat from BS_1137_1_28" then it successfully executes.I a…

I am getting ready to do some work that uses FMP 7 via ODBC to connect with Oracle 9 so data can be pulled down into FMP. Does any one know which drivers work best for this and what port number should be used to address Oracle via ODBC? Should I use a System DSN or what? Thanks!!

Hi, I am using an ODBC driver to query and import data from a DB2 database. Users have their own passwords and login id to the DB2 database. There would be a button to be clicked to query and import the data from DB2. I want that the users should be prompted with the password dialog box and once they enter their password, the entire import process should be automatic. I have tried working and it works fine when I save the user name and password permanently into the script. As I said that each user has its own login and password, if I don't save the user id and password, all the steps in the import process(eg: clicking on ok to select the import order, clicking on ok…

I've recently installed FM 7 Server advance on a Mac OSX server (10.3) and sucessfully establish an ODBC from a Windows 2000 server with the new Datadirect ODBC driver. I was surprise How slow the performace is compared to FM 6 and the regular ODBC driver..In some cases it is twice as slow.. My question is: is the culprit the Datadirect driver? if so, are there any other option? tks Otto Krauth

Yesterday, FileMAker made available the long awaited ODBC client support in MacOS X. Only there is no documentation. The install file refers to the Help files and related info on FileMakers Web site. But there is none (but the statement that ODBC Client is Win only). Did anybody have success in installing it? It would be of great use if it supported the "CREATE TABLE" command like Windows ODBC client driver does ...

Hi, I'm really new to filemaker and can anybody tell me if it is possible to do webhosting using filemaker serer 7 on mac osx 10.3.9. I mean to say my clients are working off-site and they enter the data into my filemaker database in webform, can I be able to view the data in xml form at the server side? If so how can I do that? I guess I'm clear enough. Regards, Vineel

(Excuse the crosspost - I didn't put the original in the correct forum) OK I am new to SQL... and I think I am doing pretty well. I have a mySQL server running on Linux with a database setup and the myODBC working happily. I wrote a script which can do a insert of data from Filemaker over to the mySQL server... and it works great. Now... I can execute a SQL query - such as a SELECT blah from blah; and the SQL statement is working fine on the server... and the server is giving back to Filemaker the result... but.. what is Filemaker DOING with that result? How do I do a select and get that data into a field of a record? It is driving me nuts! I…

Hi I am a newbie trying to hire a programmer to develop a database solution. I prefer using Filemaker over other databases including MySQL. I have seen that Filemaker is compliant with ODBC and JDBC but does not clearly know what it means. Does it mean I can ask the developer to develop an application using Java and make it communicate with my filemaker tables. Which one is better or easier to use on a mac? JDBC or ODBC? I want to be able to create filemaker databases using my mac but also be able to use them on windows. If I ask the developer to create the application using JAVA, can I create databases in mac and distribute them on windows? Will I st…

In FM6 our ODBC tie to a Oracle server was slow on the first connection but very quick after that. Now with FM7 every time seems to take a long time to connect. It looks to be acting as if after each time I connect and perform my SQL statement, it closes the ODBC connection again, rather than leave it open. Is there a way to keep this as an open connection? This script has to verify the information in 1 field from a database that has to match on 3 other fields up to 400 times an afternoon. 3-4 seconds each record is just too slow.

Hi all, I am looking for a way to update data in FileMaker 6 Windows from a mySQL database via ODBC. The mySQL database is part of a web application. Each time a record in mySQL is edited also the corresponding record in FileMaker needs to be updated. The records would be updated via ODBC by an automated FileMaker client that is running on an untouched Win 2000 machine. Because the database on the FileMaker side is rather complex there are 2 things that we cannot do: 1. Upgrade to FM 7, 2. solve the issue by just deleting the records in question from FileMaker and then reimport the newer version of the record from mySQL (this is not an option because there are a…

Hi, when importing from mysql , get the error: "string data right truncated(1)" any ideas? cheers!

Hello all: I'm meeting with a client next week who wants a system built which will connect with his current MAS 200 system. I know absolutely nothing about MAS 200 other than it is a SQL system, and I am hoping that someone here has worked with it before and can give me a general idea of what I'll be dealing with. I'd also be interested in hearing from anyone working with SQL and FMP - what plugins work best, if there are any pitfalls I should watch for, etc. The system I'll be installing will be FMP 7 and FM Server 7. Thanks -Stanley

Hi, I am trying to use "Execute SQL" to pass a Filemaker field value into a MySQL database. INSERT INTO `tbltest` ( `title` , `Picture` ) VALUES ('" & Art Database::title & "'), ''); I cannot get the field value to pass, instead the uploaded value is " & Art Database::title & ". Will BLOBs upload using this method? Thanks, David

Hi .... my final step to databasepublishing: setting up Filemaker 7 as ODBC datasource for 3-4 clients. How can this be done withoutr buying Server Advanced? I think that would be a total overkill for such a small workgroup.... thx. MAcB

Hi you all.... I need some help with a SQL statement. I've setup Filemaker as a ODBC datasource for Indesign CS. The test setup works fine (through Indesign plugin). The only thing that i need to do is use a SQL statement to have bi-directional setting. I must update Filemaker from within Indesign. Therefore i tried this statement: UPDATE

So I'm trying to get FM Server 7 Advanced (v3) to serve up some data via ODBC. I've installed the ODBC drivers, and they're enabled according to "fmsadmin list plugins". I've set the permissions under extended privilages on one of my DB's to allow access via xDBC. The server is running, and the "Allow Access via JDBC/ODBC" is checked. When attempting to connect via DataDirect 32-BIT SequeLink 5.4, I get this result: [DataDirect][ODBC SequeLink driver][sequeLink Client]TCP/IP error, connection refused To ensure that I have a clue how ODBC works, I had a local copy of FM 7 Pro host a database with ODBC, and was able to set up the sharing correctly so …

Hi, I'm currently writing a Java application and I need to get/set data of a container field but I can only read the filename when it is stored as a reference. If the container holds a picture that was pasted into the field then I can't read the data. For text, number, date fields I don't have a problem.

Hello. I have a bizzare problem I have been troubleshooting the last two days. I have a windows 2003 server with filemaker odbc drivers set up to allow coldfusion pages to access a Filemaker 5 database residing on another Mac machine running filemaker 5 unlimited server . The database is open in both FM server and filemaker pro on that mac machine to allow multi-access. This system was working fine for ages, but in the last few days suddenly stopped working (ODBC driver seems to not access the db). It seems there's something funky going on with Win2k3's ODBC datasource. When I tried deinstalling filemaker and reinstalling it on the Win2k3 server, the filemaker …

Hi Does anyone know how to get FM on OS X to see ODBC drivers that aren't part of the DataDirect set you get with FM. I've tried the whole remove DataDirect thing and just landed up with no ODBC support in FM. Thanks

I need some help, I am using FileMaker Pro as a front end to an SQL backend, I have the insert and update scripts going, but I am having trouble in getting a Find & Replace script going. Any idea's are welcomed.

Hi How can I get a FM7 client data source to appear as a DNS source within FM7 execute sql script step on a mac. I've tested the odbc connection outside FM7 using odbctest and it works fine. I don't seem to have a problem with it on a pc. I've tried removing the DataDirect sql client as stated on the FM site but that just left me with no odbc support within FM at all. Thanks

Hi you all.... I need some help form some pro's!!! This is the situation: we have mac clients and a mac server. A (homemade) FM database ("Mainmodule") is our CMS running on the server (each client connects to the server for FM(CMS) and the Indesign workfolder). This CMS is the content of our catalogue. We use a plugin in Indesign to extract the data from filemaker, into Indesign. Now this is done through a snapshop file. However I want to use the ODBC function of the plugin to link Indesign directly to Filemaker: bi-directional. With the plugin comes a ODBC dataprovider. Now my question: WHAT must i do to get this to work? What must i do on the serverside and what…

Hi All, I need to make sure my source table has a matching memberID before i try to update it in a ExecuteSQL step. Any ideas on which is the best way to go... 1) Perform an import/count: SELECT COUNT (*) FROM myTable WHERE memberID = 1234 with that answer placed in a temp_table decide to update or not based on result (1 or greater has found a match; 0 means not match was found). I would have to perform this for EVERY record i want to update (put in a loop) 2) Perform an import of all the memberIDs in myTable then compare them in FileMaker with the memberID i want to update (not sure how yet!! maybe use a relationship or a find script step and test i…

Hi All, After posting and getting help on my update query... I am now trying to figure out how or why when no matching records are found the ODBC returns no error messages, same goes for FM.. It seems that regardless of what happens with the data, if my execute SQL script step works - but does not update anything - no error is returned. Any ideas on how to generate an error if no matching records in my remote Access table?? Thanks Dan

Hi All, I'm new to ODBC and I am just trying to understand the basics... I want to update record in an access table with FM data for a matching field (memberID)... All examples I found on the Dev CD or in help files point to an "update statement" UPDATE remoteTable SET myStatus = updatedValue. My understanding is that updatedValue is a "hard coded value"... How can I set myStatus = a value from a field in FM for the matching record?? thanks Dan

Hi all, I can't figure the structure/syntax my SQL statement should have... When i use the ODBC import... my fields are enclosed in `field` sometimes they are like this: `tblName.fieldName` ... If i want to update an access 2000 tbl with data from fileMaker how would I write that??? UPDATE tbl SET fields etc.. with commas or semicolons? with ` or ' or " ?? thanks

In previous versions, it was easy for me to add a connection to a FMP db via OBDC. I would go to filesettingscontroladmin toolsdata sourcesadd FMP Driver... and then add the connection by naming the file. Then I would go to Excel when needed and do a "import external datanew db query and I would see my old FMP file there. Now in FMP7Dev I don't even see an OBDC drvier at all. Has this easy to use feature been eliminated? Help! -- Barry [email protected]

I had written an ODBC connector to FM Pro using VB.NET application, where I get data via following two lines that work just fine. connection.Open("Provider=MSDASQL.1;Data Source=FMTest;User ID=sa;Password=sa;") recordset.Open("Select * from PMProTest.fp7", connection) where, connection and recordset are initialized as follows: Dim connection As ADODB.Connection = new ADODB.Connection Dim recordset As ADODB.Recordset = new ADODB.RecordSet However, writing a similar application using C# is failing with exception System.Data.Odbc.OdbcException: [iM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified The…

Can I use FM7 to view the live data via a link (like Access) to a backed database in real time without importing? I do not want to have to sync, but view only. I am able to connect to the AS/400 data but can only import its data into filemaker.

I thought I found a solution to my question but after speaking with the driver developer, I discovered it wasn't. I need to connect or retreive data from and IBM AS/400 system. Does anyone know of the ODBC drivers that I can use, both on Mac and PC? My only option is to have our IT department do a dump of specific data every month to a delimed file which I then import into another FM database where the date i need to look up will live. Obviously I do not wish to do this. Any thoughts would be moust appreciated. Michael

I want to create a customer number field in an existing FM6 db, and create fields for the customer's address, phone, etc, which will use the customer number and go out via odbc to grab the pertinent info from our enterprise system, which is an Oracle 9i db. Can this be done? How about with v7? I can't seem to create a relationship with the external oracle table, and when I tried importing, I can't say "where customer_nbr=external_cust_nbr". Help!

We are beginning to migrate away from Windows 2000/FMP6 to Mac OS X/FMP6 [FMP7 will be migrated to at some point, but not for a while]. Under Windows, we've got FMP able to update our MySQL db via ODBC and the MySQL AB. free driver, MyODBC. I downloaded MyODBC for OS X on Friday, yet FMP6 would not see the MyODBC datasource [eg: when using the File->Open->ODBC Source]. I tried this with FMP7 as well, and came up with the same results. After doing some research, it appears that the reason for this is because FMP6 [and 7?] is a CFM application, and the MyODBC driver is a Mach O application, as is the OS X ODBC administrator application. I had to download i…

Hello. I'm successfully using jdbc to call a database running on an FM Client. How can I call it if it's running on a server (v 5.5) Is there a web companion for a server? Thanks

I am trying to write a Data Connector for FileMaker Pro using ASP.NET. I have used respective ADO.NET drivers for other connectors for MSSQL, Oracle etc., and wondering if there is any ADO.NET provider (from FM or even third party) available in the market. If not, I guess using ODBC is my best bet. There are several postings about writing applications using ODBC, but does anyone know of any code-sample around? Also, according to most of the readings, ODBC driver that comes with FMP is known to be too slow (?). What are my options here? Is sharing the DB through "Instant Web Publishing" and accessing hence shared data through ASP.NET a better option from perf…

OK - I'm officially baffled. Is it possible to use a FM7 client to query a MySQL database that runs on a separate server? Even though the MySQL people provide a driver for OS X, I can't get FM7 to 'see' it, let alone use it. Also - when you run an SQL query from a FM7 machine, where does the result get 'put'? The scripting command for running an SQL query doesn't seem to have any way to specify a destination for the data. Thanks in advance, AJB

Hello All! I am running FileMaker 7 Adv. V3 in a Win2003 server, where I host a database to access in the LAN, using FM7Pro clients and I am trying to serve it outside the office, through the WEB. I tried the FM Server WebPublishing, however a lot of commands in my scripts are not web-compatible and, besides this, it is a little slow. I tried to use the JDBC connections of FM Server Adv 7, but I was not succeeded. I downloaded the update of the ODBC/JDBC plug-in and installed it according the instructions. It didn