External Data Sources

Evening all, I'm trying to figure out the best setup for an independent estate agent (realtor to our American friends) with an office based Filemaker db and a web based MySQL DB for serving the website via PHP. I would like to have all the new property details put into the Filemaker db and then 'publish' this info to the server based MySQL DB. The question is how do I manage a Filemaker->MySQL workflow or will i have to forego Filemaker and try and manage everything online via the MySQL/PHP web application or maybe enter the info twice; once for the office and once for online? As for the images, I'm thinking that whenever anyone adds a new property …

We have a FMP 10 solution that talks to our shipping software via ODBC. We are looking to upgrade to FMP 11 but have heard that they are using a new ODBC driver. What we want to know is has anyone had any experiences (good or bad) during the upgrade with the old drivers. We don't want to change the old drivers unless we just have to. For us to change the drivers would be a major pain on the shipping software side. Thanks for any input. Ron

Here is my problem. I would like some of my filemaker files to figure on a site I administrate. I know that normally I would do this by establishing MySQL databases on the site and then have them communicate with the appropriate FM files on my FM server via ODBC. The only problem is that my provider does not allow ODBC communications. I found a suggestion of using a SSH tunnel, but my provider does not allow SSH either. Does anyone know of a workaround for this type of situation?

Im trying to use ezRETS ODBC driver to connect to my MLS (MiREALSOURCE Macomb County Michigan wich Uses LSP real estate groups Paragon system). But issue may be for for all RETS ( Real Estate Transaction Standard ) systems. I'm using a Mac and have configured and tested the demo using ODBC Admin. I have corrected the permissions problem. ( Error upon saving the System DSN file because permissions were set incorrectly on the ODBC.ini and ODBcinst.ini files) I'm connecting to it from Filemaker Pro 10 Advanced I can see the data source in the list but when trying to connect I get an error message " ODBC Error: [iODBC] [Driver Manager] dlopen(/Library…

Hello, somebody can help me please? I have been a migration FileMaker 10 to 11 Pro and I have some problems with the ODBC with “.ASP”. The old queries do not work. I use Any SQL maestro to make the queries, but some queries do not have some of text fields”. Even, if they worked before (with version 10). With this version of ODBC our web pages ASP do not work properly. We use FileMaker ODBC driver Version: 11.2.70.0 We use Windows 7 for development. The web server test is "IIS" and FileMaker Pro Advanced 11. We use Dreamweaver for ASP Web pages development. In the server machine we have “IIS” too and FileMaker Server. Last Saturda…

I am trying to connect FMP to MySQL. I got the MySQL ODBC driver, setup the DSN and added the ODBC data source to FMP. When I go to the relationship page and add my tabe I get an error saying: ODBC Error: [MySQL][ODBC 5.1 Driver][mysqld-5.0.51b-community-nt-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''myDatabase' at line 1 I can import the data from MySQL into FMP without any problems. The ODBC driver is v5.1.7 osx 10.6 x86. Is this an ODBC issue or FMP issue? I have the MySQL driver v 5.1.5 running with no problems with FMP 10.

We have filemaker server 9.0v3 advanced, ODBC sharing is turned on. We want to connect to our V2 database to get parts & other information into filemaker. I installed on the ODBC driver on the server: DataDirect 4.10 32 Bit, Progress SQL 92 v.9.1E At first I was getting a network daemon error. One time I tried to add a table from that data source, it prompted for user name & password, then got a message data soucrce not supported. Now, when I try to access the external data source filemaker unexpectedly quits. This happens from different workstations, all running 9.0v3 Does the ODBC driver need to be installed on all client machines or just the server.…

I'm trying to write some data from a windows program (specifically FedEx Ship manager) to our FMS11 hosted database via ODBC. The system seems to get data just fine but I cannot write data back. I've also tried using other programs to read/write the data via ODBC and I can see all the data fine on the client computer but cannot write back any data. Any ideas?

I'm exporting a table and need the uniquely identifier number. On my table I see two Ids, one serial and the other user-generated. However the serial is missing for some records(DO HAVE DATA). I need these unique numbers to be able to update my the tables in the new database that I'm exporting all my data to. How does file maker identify records and how do I export those ids. Any help is clearly appreciated. Thanks.

Is there any way to attach a word doc to a record that can be opened from different computers on a small local network. Container field seems to work great for the computer it is stored on but the other computers on the network cant open it.??

I'm using an ODBC Connection from Mac to a mysql DB. The mysql DB is UTF-8 The connection works but FM shows me "é" instead of "é", so Céline would be Céline How could I change this? Thx by ChiSao

Text file in a container field I have put word files into a container field. Any change has to be exported out, changes made, then imported back in. Is there a better way to have a word file stored in filemaker that you can open in word, make changes and have it remain in the record that it is stored?

I've got a Filemaker database connected to MySQL using ESS. I've got a basic layout in FileMaker that simply displays the MySQL data and allows me to edit it accordingly. For some reason, though, any values I place in text fields from within this FM layout get chopped down to the first character that I placed. The MySQL database is using varchar field types with 250 char maxes. Updating records directly in MySQL works just fine. In FM, again, it's trimming all of the text fields to a single character. the number fields are just fine. I've never had this problem and I've used ESS quite a bit so I'm completely stumped. Any information on this would be …

I am interested in finding a filemaker person in central new York state. Who could help me set up a very simple filemaker database having an odbc connection to a mysql server. Any responses are appreciated. Thank you Dave Ps. If I can do it with someone remotely. That will work too

I currently set my FMP database to IMPORT the data from an ODBC connection that is linked to an MSSQL server. This is the SQL server that we use for our ecommerce website. In that SQL server I have an area called photoitems. This is set up to show a relative link back to a specified location for photo's. When I imported this in to FM, it shows in the photo box as /picturecategory/123456.jpg How do I set this up so that this is pulling the actual image from the location on my SQL server and displaying it on my FM design? I assume I need someway to tell it that the location of the image is //servername/picturecategory/123456.jpg, but for the life of me c…

I am brand new at the sql server stuff. I think my hosting plan will let me use mysql. I would like to know how to connect to a sql server. It seems daunting to me. Is there training somewhere specifically how to do this? Thanks for your time and answers

Hi, I am trying to search a FileMaker 11 database with a SQL statement shared via ODBC using Microsoft Query and directly via the 360 Works Scriptmaster Plugin. The query is: SELECT A_kfWertID FROM DataAdrELEMENTE WHERE AdrElementWert Like '%GmbH%' AND AdrAttributLevel = 3 I encounter the problem that searching in a FileMaker table with SQL statements seem to be case sensitive. Searching for '%GmbH%' returns a proper result, while '%Gmbh%' or '%gmbh%' gives an empty result, apparently because the records all have the value "GmbH". According to my information MySQL on the other hand is insensitive for uppercase/lowercase search terms. Is the SQL engine in FileM…

We currently pull data from FMP-A back to some sql tables to be merged with other data from other sources using obdc. Currently using server 9 advanced and just upgraded clients to ver 11 of FMP-A. On testing the new odbc drivere that is requirerd for ver 11 of FMP-S the DSN sets up and test okay and I can place my select statement in the connector inside the SSIS package but the fields from the select statement do not return in the connector under column mapper. Also I notice just testing using excel and the DNS that the odbc driver is now case sentative on it return data. If my select statement pull from a field that have states in it and it should = 'ga' it pulls just …

I thought this should be fairly easy, but I can't seem to find the answer. I started one database file with many different fields. Then I obtained a .csv file with which I opened in a second FM file. The .csv file had about 96 fields. I am trying to get the FIELDS from the .CSV file into my original database. I am not concerned about the content (data) in the .CSV file. But I am just trying to get the 96 fields into my original table. Can this be done, or do I need to make each new field manually?

I have a MySQL database that contains request for quote information. The database only contains one table with a few basic fields name, email etc. Right now I run a script that downloads the data to a filemaker table and then deletes it from the MySQL table. However, It works on the client side. So I have to configure a system DSN on each computer that uses this "update RFQ" script. Is there a way to configure this so that the server automatically updates the data? I know I could use the MySQL table as an external data source but I'd rather keep the data on the local server. Thanks in advance for the tips

I have a complex MySQL database that someone else has created. It has a couple hundred tables. I have no documentation for it. It is my task to make a front end in FMP11 for it. Is there any software out there that can take a MySQL database and automatically build a FileMaker database with the correct relationships between all of the tables? I would like to keep the MySQL database as an External Data Source.

I'm trying to deal with a SQL database (over which I have no structural control) via ODBC. In this database there are numerous fields which are to remain empty the great majority of the time, but they are configured to not allow null values. Instead, an empty string ('') must be used. So far as I can tell, FileMaker doesn't think very highly of that tactic, and I am slowly being driven mad. Why are you even touching those fields, when they are unmodified and not even on the layout, FileMaker? Why? If anybody can proffer a method to make FileMaker send an empty string that would be grand. Or make it stop updating unmodified fields. That'd work too. Also, the…

So I downloaded the MySQL ODBC connector for Mac. Installed it, and configured a System DSN with all the relevant information. When I go into the relationships pane in FileMaker and Add ODBC source my source is there, I select it, and after entering the username and password again, I get my list of tables. I select one and hit okay but get this error message: Why does it say tablename.tablename ? That seems wrong. Did I miss filling in an essential field or something?

I've been wrestling with this for a while but don't know much about external sourcing and can't find a suitable solution. What I want to do is to have two separate databases such that one sources data from another. database A: where users will be free to manipulate a core set of data. database B: where whole tables of data are sourced from database A and cannot be changed. other tables and layouts can be built as needed off of this core. I would appreciate some words of Filemaker wisdom.

Hi to all, I am trying to migrate a table that contains documents from File Maker Pro 6 to Mysql. For to do this I'm using FmPro Migrator, the problem is that DataDirect 32Bit SequeLink 5.4 drivers are required to perform the ODBC connection. But when I go to Control Panel > Administrative Tools > Data Sources and I click the System DSN tab, then clicking the Add button in this section doesn't appears the DataDirect 32Bit SequeLink 5.4 drivers. I have tried do re-install Filamaker but the problem is the same. In the list of the ODBC drivers DataDirect 32Bit SequeLink 5.4 drivers doesn't appears. Can anyone help me? Flavio Refrigeri

Hello, I' need a data base shared through Filemaker Server 10 to be able to get some info from a MySql database on the company's network. Test on my computer (Filemaker Pro Advanced 10) 1- installed MyODBC drivers 2- created the connection to the newtwork MySql database 3- Define the MySql database as en external source Eveything ok. On the server, point 1 and 2 ok. But when I remotely open the filemaker database that's shared on the server with my client and try to set the external datasource there is not ODBC database in the external sources menu. Should I do something else ? Is it supposed to work at all ? Thank you for yo…

Greetings, We are trying to install Filemaker Pro Server 10 Advanced onto our new Windows 2008 Server. That worked fine... everything is connecting properly. But now I need to Re-create my System DSN that connects to our SQL 2005 SP2 database. This worked on our Windows 2003 Server... but the driver I need isn't compatible with 2008. Is there a driver that will work with 2008 server 64 bit and FMP will see it as a possible DSN? I believe the one 10 needs is: SQL Native Client 2005.90.3042.00

We use ODBC to connect from an Oracle database on a Windows 32-bit operating system to a Filemaker database, using "DataDirect 32-bit SequeLink 5.5" on the Windows system. After some help from the local rep getting it set up a few months ago, it has been working very well. Now, however, the Windows machine is being upgraded to a 64-bit system, and the "DataDirect 32-bit SequeLink 5.5" ODBC does NOT work on the new 64-bit server... I contacted the rep to ask where we can find an ODBC client that will work with FileMaker on a 64-bit Windows operating system, but the answer that I got -- after the rep consulted with FileMaker -- was that "there is no version of Dat…

Hi Guys, Im new with Filemaker Pro and main objective is start a new database for Asset Management. Assuming that the Filemaker Server used has successfully authenticated to Active Directory service, is it possible to define a field in the database and link it to a user in Active Directory? Thanks. Hoping for a response soon.

Hi Folks: I'm pretty new to Filemaker (11 Advanced). I have connected to an Oracle database (xe on the same computer as Filemaker is installed). I am able connect Filemaker to Oracle Xe using ODBC with no problems. I am able to add, delete data, etc. I am able to see all of the data within Filemaker (and I created all of the relationships, etc. within Filemaker). The Problem: When I create a runtime solution, I get the following error in each field where the data should be: "" I am running the 'runtime' on the same computer (after closing out Filemaker). I have been unable to figure out why the runtime solution is unable to connect with…

Is there an alternative ODBC driver for Mac OS 10.6 other than the one recommended by filemaker from Actual Technologies? Looking for a free solution that will work on OS X 10.6 Server. darren burgess

Is there another way of getting filemaker to communicate with a MySQL database when your provider does not accept ODBC communications and the provider only accepts phpMyAdmin?

I have run into a problem with what I thought would be a simple task. We have just upgraded to a new version of our accounting software (DOS to Windows). I miss my DOS app. BACKGROUND: I need to recreate some things that we could do with our old-version. We use reports that have been spooled to a text file (no delimitations inserted) to do other things with the data. We take the check registers to create the positive pay file that is sent to BoA. We use the AP Edit listing to validate data going in to history. In the DOS version it was really easy to view the printing report and visualize the datafields: vendor number, name, invoice date, invoice num…

I am very rusty when it comes to fmp web interface. I need to create a web interface that allows user to input fields, upload files and click submit - and the data and files eventually automatically go into fmp shell (or files go on a server and fmp gets a data link to said file that can then be clicked). User should not get access to any of the data but their own about to be submitted. Security is key. Company has fmp9 server and fire wall scenarios. What is the best solution for this type of thing? Receiving fmp database is already developed so they are married to that. They currently have an input page that creates a txt file that gets emailed and they then import …

I'm using ESS with FileMaker 11 and a MySQL database. When I have the FileMaker solution open and data in MySQL gets edited, the only way I can get the information to update in FileMaker is to close and reopen the file. Is there some way to force FileMaker to re-read the data from MySQL? Thanks, Chuck

MySQL v5.1 FMP/FMPA v9,10,11 Windows XP, MacOSX 10.5, 10.6 A MySQL field is defined as NOT NULL (e.g. name VARCHAR(255) NOT NULL). The database and the table where the field is located is linked via External SQL Sources. When a value is deleted from the field, making it empty, I get the following error on Windows: ODBC Error: [MySQL][ODBC 5.1 Driver][mysqld-5.0.32-Degian_7ethch1-log]Column was set to data type implicit default; NULL supplied for NOT NULL column '' at row 1 ...and on a Mac it is: ODBC Error: [Actual][MySQL] Column '' cannot be null Where is the name of a MySQL field set to NOT NULL. At that point I'm stuck! I need to enter…

I am attempting to insert from filemaker a date into a mySQL date field. mySQL dates are configured as yyyy-mm-dd. I am using this calc to convert the date: Year ( Workshop::Start Date ) & SerialIncrement ( "-00" ; Month ( Workshop::Start Date ) ) & SerialIncrement ( "-00" ; Day ( Workshop::Start Date ) ) This will correctly convert the date, however the script generates a 500 error - Date value does not meet validation entry options. The filemaker field is a date field. the mySQL field is also type date. Any ideas? Darren Burgess

Dear All, I am hoping to find either an answer or purchase an hour of 1-1 training (perhaps via an online meeting and telephone call) to answer a question that the Apple one-to-one training staff couldn't:- -------- I have developed software in MS Access for a number of years, and have been looking at filemaker having recently converted to Mac. Before making the switch and investing what will no doubt be many hours in filemaker, I had a specific demonstration that I wished to see to see how easy it was to perform a task that access has not been very good at. I'll set out my notes, am looking to know if this is within filemakers capabilities (And …

Hi, I would like to connect to myDB (FMP 10) from ASP without using DSN. The driver ODBC (DataDirect 32-BIT SequeLink 5.5) is installed. How can I do this ? what connexion string do I have to use ? Thank you I tried this without success ... Set myBD = Server.CreateObject("ADODB.Connection") myBD.ConnectionString = "Provider=DataDirect 32-BIT SequeLink 5.5;SDSN=ASP_TEST;HST=localhost;PRT=2399;UID=Mano;PWD=123;"

Can anyone reccomend a FREE plugin to perform SQL commands in Filemaker? I've seen demos where SQL commands can do things without needing relationships and want to play/learn a bit of SQL

Hello everyone. I encountered a little problem when importing records using the Filemakers ODBC SQL query and 'calculated SQL text' option. I can make a very similiar query using the Query Builder, but then I cannot use any variables defined in my script window. The query I get from the Query Builder is: SELECT "my company$Sales Shipment Line"."Description" FROM "my company$Sales Shipment Line" WHERE "my company$Sales Shipment Line"."Document No_" = N'10101' This should be altered so that the last number could be a variable like $document_no. I simply Cannot get this to work properly. Just replacing the ":s with ':s won't solve the problem. The b…

Hello, Is there anyway of importing all the tables and data from an ODBC source. The database has lots of tables (like 70 I think). Most of the tables have 100 of thousand of records. Would love to convert it to an FMP file. Thanks

Hello, I would need to connect FM Pro 11 via ODBC to an Oracle Database (10g), I need to read data from Oracle. The FM Pro 11 is on a Windows Server 2003 64-bit machine, where we already have the DSN defined, based on a 32-bit driver. However, this system DSN can be viewed only when going directly to windowsSysWOW64 directory and running 'odbcad32.exe'. Launching Administrative Tools form Control Panel you can not see it, being the DSN based on a 32-bit driver. Unfortunately in FM Pro 11 we can't see either the DSN. Does anybody know how the let see to Filemaker the DSN under the directory windowsSysWOW64? Somewhere on the net I found, that co…

Hi, Has anyone tried to connect FM 10 on a local mySQL DB everything on Windows 7 64bit? Here's my configuration Windows 7 64bit: MySQL 5.1.36 : ODBC Drivers 5.01.06 64bit I have created a system DSN using the MySQL drivers. And tried to add an external data source in a FM file, But the "Select ODBC Data Source" window is still empty. Does anyone know how to fix this issue? Thanks

We use FileMaker with IWP but also want to access a remote SQL file - not at the same time. I have installed the latest driver from Actual Technologies and it will allow me to access our SQL mailing list. All is fine until I put the layout into Table mode. I can scan down the list and it will stop and look up more remote records, then it will very soon crash corrupting the web.prefs file. If I try to restart FileMaker, I says there is a port conflict. Once the web.prefs file is deleted, we can use IWP again. Any ideas?

Well ive seccsussfully created my first Database and coverted it to a Runtime Soution of it as well. I only have one problem that i am hopeing that someone can help me with. i am using a primary data base but i link to a sperate document Library. Prior to creating a runtime soultion everything works perfect, example when i click on my Data buttion it will pull up the document library and open it in a new window which is perfect. when i create the run time soultion the primary data base works perfect but when i click on my data button i get a data base not found error and it opens a file window which shows the document library. when i select it it opens right up. and yes w…

I just updated my Actual Technologies ODBC driver for open-source databases. Before the update I was able to store the login information so that users going to the external tables weren't prompted for a password. It was stored in the ODBC connection on the FM Server machine. Now every user gets prompted for username/password. Any ideas?

I am unable to create an Oracle 9i ODBC instance in the relationship graph on a customer's system (just hangs), we think because the Oracle login doesn't have read permission for the Oracle schema. The ODBC connection works fine in Oracle SQL*Plus, but my contact tells me that the login is "pretty locked down" and wants to know specifically what I need access to. Can anybody tell me, please? Or suggest a different remedy? Thanks, Doug

I have been using Rental Hosting Server. One of the advantages to use that server is MySQL. Now, I would like to access that MySQL with FileMaker, and see MySQL data on my local PC. Is there anyway to do that? If anyone knows, please tell me.

Guys, Is there any function to get the user input in account password field while logon?

I have a shadow MySQL table in FM to which I've been able to write data for well over a year. Now, all of a sudden, when I try to change any field data, FM is seemingly trying to validate fields in the MySQL table which it never has before. Nothing has changed in my ODBC connection, FileMaker or the table itself (I can write directly to the table via Navicat without validation errors). Has anyone ever encountered anything like this?

I put in this line in as an SQL query to import data... SELECT `orders`.* FROM `orders` and i get records, I then enter this as a calculated sql query.... "SELECT `orders`.* FROM `orders`" shouldn't I get the same result? I get no records when I try a calculated result Edit... so I found that if I do the script step with dialogs and step through each step it will pull up a result but If I switch to no dialogs no records come up just fine. any ideas?

Hi, I try to insert a picture into a Microsoft SQL database using the Frontbase SQL Plug-In, but it does not work. The situation is like this: -Windows Vista Home Premium (SP2) -FileMaker Pro 10 Advanced (version 10.0v3) -Frontbase SQL Plug-In (version 1.32) -SQL Server ODBC driver (version 6.00.6002.180050) -Microsoft SQL Server 2000 (version 8.00.818) -Database Name: Test -Table Name: Files -Column Name: FileData (Image) -Picture: C:TempTest.gif I use External("FBSQL-Connect"; "datasource|username|password|timeout") to connect to the database. When I try to insert picture Test.gif into table Files through External("FBSQL-ImportBlob"; "I…

After reading the extremely simple and brief ESS documentation I have deducted that you can sort a SQL View and have that sorted view show up in a portal or on a layout. However I cannot for the life of me figure out how to get this done? any data views or layouts all show a seemingly randomly sorted bunch of records. The only thing that I can figure is that by choosing a "unique identifier" when I add the table I am unintentionally specifying the sort value? unfortunately I want to sort the non-unique values! I am actually allowing the user to select the sort field in FMP and the view will dynamically use the new "sorting field choice" to re-sort the …

Hello! I'm posting here after not having any luck on the FilemakerToday forums... hope to get some guidance from the community! I'm new to FileMaker but familiar with mysql and need some help bridging these two worlds. We want to push some of our data from FM to an external mysql db on a schedule we choose. Here's the setup: * large, sophisticated in-house FM system managing our inventory, contacts, etc * new mysql database on a remote web server, connected via ESS My main question right now is how to update product prices on our mysql-powered web page. Updating fields manually via ESS is obvious, but for our workflow we need to be able to push updates …

Hi , I have Filemaker 11 advanced and I am using it to manage may data on MS SQL server 2008 , my question is , how I can use " View Index dialog " using Ctrl+I or Cmd+I on Mac to view the indexing list My sql database Table is configured with index Thanks

Hi, I have an Asset Management System through FileMaker Pro. But I am using a SQL server back end database. I am trying to write a trigger in SQL Server so that once a new record is inserted that it updates the barcode number according to the assessment centre that this asset belongs to. The trigger is as follows: ALTER TRIGGER [dbo].[Create_Barcode_Number] ON [dbo].[AssetManagement] AFTER INSERT AS BEGIN declare @var varchar(255) declare @code varchar(255) SET NOCOUNT ON; if (select AssessmentCenterContractor from inserted) = 'Carlton' select @var = 'CTN' if (select AssessmentCenterContractor from inserted)…

Hi guys, just wanted to run a set up by you to see if it could work. We have an office running FM server and about 20 users.. we also have a website, SQL server driven. What I wish to do is create a live link between the two systems. The website is hosted externally so a VPN would have to be created between the 2 locations. The purpose of the live link would be 2 fold... The fist purpose is for filemaker to host a catalogue of about 10,000 products. The 2nd purpose would be for the website to write any incoming orders directly to a table in filemaker.. So my first question is would this set up work in theory and practise! And 2nd.. am I right in saying I would hav…

I'm trying to install the Filemaker ODBC drivers to a computer that will be trying to access my Filemaker server via ODBC. I am following the instructions to a "T" but all of my drivers are .bundle packages, which I have no idea how to install. The Filemaker instructions it says; 1. Do one of the following: 1 If you received your software electronically, double-click the disk image icon (.dmg file). 1 If you have an installation disk, insert the disk into the drive. 2. In the FileMaker Pro or FileMaker Server window, double-click the xDBC folder. 3. In the xDBC folder, double-click the ODBC Client Driver Installer folder. Chapter 3 | Installing FileMaker OD…

Hi All, I am an old time FM user. Versions 4-6. I stopped developing in FM about 6 or more years ago. I am now a .Net developer. I miss the ease of creating FM layouts. But hated the lack of in memory variables, non separation of BL, DB and UI.. I know many of these issues have been dealt with in one way or another. SO i have downloaded version 11. I am specifically trying to figure out if and how i can create a UI frontend that runs completely off of MS SQL DB. In the olden days i used ODBC DSNs to connect to databases to make queries. It worked but was a pain as i was basically importing and exporting result sets. A few years ago, maybe ver…

Hi , I have filemaker 10 advanced and MsSql 2008 server , I have a problem making relationship one to many between 2 Sql Tables , when I am trying to do it I will have just one to one , also I tried to remove the primary key from the MsSql and Its the same Is there anything I am missing ?? Thanks for your help

I have an issue getting data from an Oracle 11g database using ESS. FileMaker is seeing the Timestamp field as a Date field and only showing the Date, but not the time. I talked to the Oracle developer and he said the view has the date and time included. What can I do to see the date and time from Oracle

Hallo, I'm trying to share data between Filemaker 10 and Mysql. I have MySql as source data. I've set two different ways: 1. Filemaker 10 client -> ODBC manager on the client computer -> MySql on a remote server 2. Filemaker 10 server -> OBDC manager on the server - Mysql in the same server It works, but when I refresh window on FileMaker sometimes the data displayed are not the same.. But I haven't problems updating MySql data from FileMaker. I think (but I don't know really) it could be a Sql error.. But FileMaker doesn't display any error.. I see for a while the "omitted" record.. but after they disappear..!! What can I do? …

I am using FM10 as a presentation layer to MySQL, with generally good results. The problem I have is when I use the Execute SQL script step to do modifications in MySQL. What do I have to do to have the data appear in FM shadow tables? When the Execute SQL operates on a small amount of data, a Commit Records and Refresh Window script step, the latter with flush cached join results, flush cached SQL data seems to work. However, when the Execute SQL operates on a large amount of data (1000 rows, say), it doesn't work. If I refresh (manually, with a script that just does the commit and refresh), the changes appear within two tries. I'd like to be able to do somethi…

Hi - I'm trying to figure out if FMP's ODBC connectivity allows me to import the database schema into one of the programs (eg Dezign for databases, Enterprise Architect, etc) that will read SQL or ODBC databases and then draw a diagram for documentation. Can FMP look like an ODBC source? Or can I export to XML so I can import that way? Thanks, Michael

Hello, I have a Filemaker solution that I'd like to integrate with a PBX (telephone) system. The PBX system uses a Postgres database. I've used external sources before (MSSQL, etc..) and never had any trouble, but I can't get it to play nicely. I don't need to write to the Postgres DB, just read (if that makes things easier). Any ideas/suggestions would be helpful! Thanks!

Does anyone know if there is an ODBC driver (Windows) that would allow me to connect to a FM 5 database from FM 10?

I have multiple SQL databases, all exactly the same format and structure, that I talk to using FM9 scripts, standard relationships, and ODBC drivers. I only need to talk to one SQL database at a time. At this time, each database has it's own ODBC DNS and it's own relationship hook through a shadow table. Is there a way I can dynamically allocate, connect to, and talk to any one of my external databases. I only need to communicate with one database at a time. I also do not want to impose any restriction at all on the number of SQL databases I can access. I don't mind having multiple instances of DB shadow files, each with a different ODBC DNS, that I open and cl…

I have a database which will be using a SQL table on a SQL 2005 server that is replicated with another SQL server using the internal SQL Replication feature. When I try so save a record in the table 'Box' I get the following error: The target table 'Box' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause. I found some old conversations on this from 2008 but none suggest a resolution. It's 2 years later. Has anyone found a fix for this?

I am trying to figure out what I need to configure to fix this. I have 2 Filemaker Databases on the same Filemaker Server. In one of the databases, I added the other database as an external data source. I then created the table occurrence, and built a relationship. It is accessing the other database fine.... but what is weird is that it never prompted me for a password or username, and no matter which user is logged in, they have access to edit the other database. How am I to prevent them from editing the record in the other database without locking them out completely.. I can't find where to configure it. Now, coincidentally, my admin account ha…

I am trying to connect to our Filemaker Advanced Server, (ver. 10) via ODBC and VBA. Let me say that I am not a VBA guru, and have not used it in a while. I setup the client application, (RSView SE running on Windows XP, SP2) to connect to SQL Server as a test and it worked. I setup the DataDirect ODBC SequeLinc driver, (ver 5.5) to connect to FileMaker with a DSN and that works. I am able to see the database and update records with a simple SQL Client, so I know that works. The error I am getting right now appears to be in the connection string. Here is the connection string I am building. I will keep things simple and not post a bunch of code. …

I am running FMP 10 and cannot access my company's Oracle 10 DB via ODBC. When I first loaded the new version of FM, I could. Then, all of a sudden, I can't. I have looked in the windows XP control panel at the ODBC tab. There is no driver for FM. Silly question, where do I go for this? Remember, it used to work.

I have a mailing list in a remote server that is stored in a SQL database. How do I access this with FileMaker? I'm using FileMaker 10 Advanced with Snow Leopard. Thanks,

I have the FM5 ODBC driver and I was wondering if: (1) I can use the driver to connect from FM10 client to FM5.5 Served files? (2) If so, could someone give me a high level view on whats needed to make that happen. I tried a number of different things : enabling the Local Data Companion and Remote Data Access Companion on the FM5.5 file & and setting the same options under application preferences to no avail, which brings me back to question 1 - can it even be done. DJC

The selected columns contain some non-unique values and therefore cannot be used to uniquely identify each and every record in this table or view. Question: I get the above mentioned error when adding a SQL table from an Oracle db that does not have any non-unique columns - Is there a workaround from this error to get the data into FM (besides adding a column to the Oracle db)? Regards, Rick

Hi I have a few questions concerning linking to Oracle external data sources in Filemaker (FM) 1. Is ODBC the only non-FM option to link to external Oracle tables in a FM database? Is JDBC an option? 2. In our FM database, we would have different users with permissions to only see certain records in a FM or Oracle table. Is there anyway to limit the records these users would have access to in a layout in both the FM and Oracle tables AND not have to scroll through all the "no access" records? In other words, only see the records they actually have access to? 3. Our external Oracle tables contain a lot of records. Is there any way to limit the amount …

I have created a web form with php(not FM published) and it allows users to book appointments with available times. These time slots need to come from FMP, is there a way to update the avaialable times in the form. So for example company sets filemaker to have specific times on certain days available in FMP for users to schedule bookings online. Each available time is market by a field that is check if it is available for web. This identifies an available time. I want that "checked" time to be published to the web form so that when a users selects the drop down menu for the available times on the form, it shows available. So basically what I believe I need…

I'm trying to use an import records script with FM 10 Advanced for Mac. The data source for the import is a SQL Server database. (Connecting with Actual ODBC driver.) The core of my problem is that I can't seem to store the username and password for the database I'm connecting to. So 1) everytime I run the script I have to enter credentials, and 2) there's multiple import steps in the script, each from different tables in the same SQL Server database - and I have to enter credentials each time. There's an option to save the username and password, but it doesn't work. Not sure if this is a bug in FM, or in the ODBC driver. I'll settle for any viable workar…

Any idea what was cause that error while trying to import FM records into mySQL. There is a subset of records that do get imported. I'm just not sure what to look for as the error code description is pretty vague! Thanks, John

I've got a client that I setup a solution utilizing ESS for. Everything was working just fine for a few months. Now when he tries to open up his FileMaker it stalls for a couple minutes and he gets a message that the MySQL connection failed. I jumped on their server and I can see that in the ODBC Admin panel the connection is no longer working. I've double checked the un/pw which is still accurate but when I try and view the database or test the connection it stalls the same way and eventually tells me it can't connect. I jumped on the web server to double check the Remote MySQL settings to ensure that his FileMaker machine's IP address was still showing up t…

Hi, i am using a MySQL server, I am connected and everything works fine. I was told to created a longblob field in MySQL to store pictures. I can't see the field in Filemaker field table even if y click the sync button. Anybody have a idea how to use a Filemaker container in MySQL

The following is the environment in which this is occuring: Platform: All windows Server: FMS9 ODBC Source: far away Word Press server connected by System DSN on server Local File: Has one local table and references to 2 ESS SQL tables from previously mentioned ODBC source. So I created a script for use with the server side script tools to run an import on the ESS tables into the local table within the file. Tested, worked flawless, then went to run it on the server and it died. After alot of time wasted hunting for the issue, I discovered that ESS cannot be used on server side import scripts. Next step, do a straight import from the DSN into the lo…

Has anyone tried using Excel as a front end, filemaker pro 10 advanced as a back end via an ODBC connection? Positive results for people who can't give up excel? Known issues?

I've got a FM layout with a portal I want to show related rows from a MySQL table. It works fine as long as the relation is based off a "single" entry. FM field has "Open" in it MySQL field has "Open" in it My problem is I'd like to expand this to show fields with one of two values, such as "Open" or "Pending" Only way I can think is with another FM table with a calculation in it, but that calc can't be used in a relationship (non-indexable)

I've finally gotten Filemaker to see the MySql Database-Table. Now I need to be able to edit the table in Filemaker and it update my MySql. I can add records and delete records and it updates. How do get the privilege to update from filemaker?

I have fm10 server connected via odbc to a mysql source. There are a dozen mysql tables with shadow tables in FileMaker. 11 of the tables are read only to the filemaker/odbc account. But 1 table is read/write. It has only 4 fields and 10 records. But when I click "new record" there is a delay of around 30 seconds before the new record shows up. The fields are: CreationTimestamp - auto-entered by mysql server ModificationTimestamp - auto-entered by mysql server RecordID - auto-entered by mysql server UserName - text field What could be the reason for this? Does FM not work well with values that are auto-entered by MySQL? Thanks, ft. …

I have a DB in Filemaker 8.5 for inventory. We use barcode scanners and upload the collected data into Filemaker. With the scanners we previously used I was able to develope a program on the scanner and use the Troi serial plug-in to get the scanner and Filemaker to talk. Well those scanners are no longer in production and all but the last one are broken. We now have new scanners that are manufactured by the company that aquired the comapany that made the previous scanners. Long story short the proprietary software from the scanners has OLE controls and it came with examples of how you can use it directly in Excel and Access. Well Filemaker says it can do OLE. I hav…

Hi I am trying to get parameters OUT from a Stored Procedures running in MySQL backend. My Stored Procedure is(In MySQL) CREATE PROCEDURE sp_grandtotal (IN orderid INT, OUT gtotal decimal(6,2)) SELECT SUM(quantity*unitprice) INTO gtotal FROM OrderedProducts WHERE _kf_OrderID=orderid Now I am trying to run/call it from FMs Execute SQL Script as Calculated SQL text: "SET @gtotal:=0.0; call sp_grandtotal("&Orders::__kp_OrderID&",@gtotal); Select @gtotal" There are two problems: Not sure about the syntex here in Calculated SQL text because its not running successfully though it runs in MySQL backend and how to capture the ou…

Since ESS still does not support PostgreSQL, I am assuming ODBC is still going to be the best method for connecting the two databases. I am running an import on a FM database, which then has to be audited against a PostgreSQL database. I am currently running FMPro 9.03 on WinXP. What is going to be the best method for running these audits. I have FM10, but have not upgraded. Is the ODBC support better in 10?

Im wondering if it is possible to have a link in an email that will send a windows user to a specific record number in filemaker or IWP. Logic tells me not... but what do i know. I can not change the start up script in this solution either. Please post either way so i can stop my brain on this one

Hello When trying to set up an ODBC connection to a FM database using DataDirect 32-BIT SequeLink ODBC 5.5 driver, I am getting a TCP/IP SequeLink Error 2306 for 'connection refused'. Any ideas? The FM file is on a network NT server. I am running Filemaker 9 with Windows XP SPII.

I am not sure I am in the right forum. But I am going to ask here. I would like filemaker to open a window in safari or any other browser but is there a way to set the browser window size? I have a good reason to open the browser over using the web viewer. I am just wondering if that is possible.

Hello all, I'm facing a new problem and I hope you can help me solve it.. My web site is based on MySQL (latest version) and - after trying using a External data source (ESS?) - I decided to update record via DSN (odbc driver MySQL connector latest version 5.01.05 febraury 2008) and Execute SQL script step. Until 3 weeks ago we used mysql 4.1.2.. (I can't remember the exact version but sure it wasn't 5) and the same driver on PCs; since we upgraded to MySQL 5 some SQL instructions stop working w/out returning any error (using Get(LastOBDCError) function). using debug tool and data viewer I copied the SQL instructions and paste them into another application w…

Hi, I want to synchronize my Filemaker 10 contacts with my Quickbooks Online customer information. I've looked into Fmbooksconnector and Qodbc, and both require PCs, (which isn't an impossibility but would require my buying Filemaker for PC, correct?) I know there might not be a perfect solution but can anyone advise me on the best course of action? XML? ODBC? Building a MySQL intermediate? Some elaborate AppleScript or Filemaker script? Thanks, L Kudos!

Hi when I use a script to open a url. My browser opens as firefox. I need it to open safari. How do I do that?

Hi I've been doing a lot of work recently with FileMaker and ODBC, and one of the issues I've encountered is that when you have server hosted FM file that requires an ODBC data source, even when you install that data source on the server, the client machines using the file don't seem to be able to read the data from the ODBC source. This basically means that installing the ODBC data source on the server is pretty much useless, and you have to install the same data source on every client machine that wants to use the file, in order that they can connect to the remote SQL table and view the data. Does anyone now of a way around this? Are there any special co…

I have a database that reps use to enter their visits. I would like to be able to retrieve the distance between postcodes of their visits so that I can produce a reasonable estimate of distance that should have been travelled.

Specifically, I've mapped a Sharepoint drive on my computer so that I don't have to access via the web. If I put xyz.doc on my sharepoint, is there any way I can develop a script that will: 1. Go to the network 2. Log-in based on the user's credentials 3. Open up xyz.doc Thanks, Ryan

Hello, I'm using the MBS FileMaker plugin to run some SQL queries on my FileMaker 10 file. I am not using an external data source, the SQL acts directly on the tables in my FMP file. One oddity with SQL in FileMaker is the syntax surrounding date and time fields where you have to enclose the field name in quotes and the value in curly brackets {} like so: MBS("FM.ExecuteSQL"; "INSERT INTO table_a ("date", "time") VALUES ({" & table_b::date & "}, {" & table_b::time & "})") This query works as long as the date and time fields of table_b are not empty. That is to say that the following query works: INSERT INTO Untitled ("date", "time"…

A potential client is currently running VersaTrans FleetVision and VersaTrans RP. Those programs running on a PC using SQL Server Express and accessed on the client side by PCs. The client likes the software overall, but wants some more options and the company is unresponsive to his requests for changes. He wants to know if he can use Filemaker to integrate with the SQL tables to add data directly to the system, to create reports based on the SQL data, and to create his own FMP tables to capture new data. The IT guy won't give me access until I'm under contract and I can't get under contract until I get a proposal and I can't give a proposal unless I know …