External Data Sources

Hello. When I try to issue a sql command to delete some records, or when I try to call a script using CallableStatement, I get the following error: java.sql.SQLException: [3] Unavailable Command I can run queries with no problems on other files, and, most strangely, a query that doesn't return any data runs without an exception on this particular file. The .fp5 file is running in FM Developer 6. Thanks in advance for any advice.

I am trying to import a large test field that could contain up to 10000 characters via ODBC from an SQL server, and the follow error appears... ODBC Error: [Microsoft][ODBC SQL Server Driver] String data, right truncation. Should I try a different driver? or is this a problem with importing large fields? Kieron

Hello Everyone, I'm runnig FileMaker Pro 7 v2 on MAC OSX-10.3.8. I am tring to configure odbc sharing; I got the xDBC plugin from the filemaker website. I put the plugin files under "/FileMaker Pro 7/ Extensions/"(two files 1.xDBC Support 2. xDBC.fmplugin), so now I can see "ODBC/JDBC" sharing under FileMaker menu, but when I try to share a database, it is giving me an error message "Could not initialize the xDBC service" !! please let me know if anyone of you have any idea to fix this problem !! and also odbc client driver for MAC is now available, does anyone has any documentation or a set of steps to configure it on MAC ?? Thanks for your help. Sincerely, A…

I have been able to establish the odbc connection on my server correctly for both User and System DSN. However, Crystal Reports is on my local computer, so I somehow have to get my client computer to have the ODBC drivers oh it. I try and setup the same thing using the server name and port 2399 but it gives me "authorization failed." any idea why I would get that. I'm an administrator and I also have the FM7 ODBC turned on. Any help would be great.

Hello, I am using Filemaker pro 6 unlimited. I want to connect my user interface with the use of JAVA application to the Filemaker database. Can you tell me how to do that? Even, I tried with the DataDirect sequelink 32-bit driver for ODBC. But, I got confused, because I was unable to put that driver in the Administrative tools of the control panel. Can you help me with some small Java script? Thanks, Hetal [email protected]

What steps are to be followed to use FM 7 Server Advanced as ODBC host and FM Pro7 as client? I have created an .fp7 file having account with fmxDBC privileges and ODBC sharing is turned ON for same file. This file is copied to Fm Server Data/Database folder. Now what i need to do, to acces this through FileMaker pro7 (client) machine.

Hi, I'm complete FileMaker newb here, so please forgive my ignorance. My setup is simple. I have a FileMaker 5.5 Server running, and would like clients to be able to connect via ODBC. Is this possible? From what I've read this can be done in 7, but I can't find any info for 5.5. Thanks!

I'm trying to do a mail merge (Microsoft Word 2003) using FMD 7 as a data source on Windows XP Pro (SP2). I have installed the ODBC driver and believe that it is properly configured (localhost, port 2399, default). At least I have followed the instructions on the FM CD. I can see the driver as a System DSN entry. I test the connection in the setup dialog and enter Admin as the user name (no password) and the connection tests OK. But here's the problem. When setting up my merge, I select the proper driver as a data source, and a dialog comes up asking me for a user name and password. I have never set up any accounts in filemaker, so I don't know what to enter. I enter…

Hello. I'm new here and with FM. I have a problem with it and I can't solve it. help please! I have a FM7 database with information such as people names and surnames. When you look up for a name, for example, it shows the information of that person and many other information from other FM files. Now, the identification of a person must be done through a central database wich contains the people information centralized. So I've decided to do this. First I construct the query with a kind of "look up interface", connect with that database using ODBC, I import the remaining user information (address...) and now... what? With this new information I must get the rema…

Is it possible to use Filemaker Pro 7 as a front end to a SQL Server database?

Hi, I have this problem, perhaps someone already tried. I developed an application plug-in (macintosh), with this plugin I make ODBC connections to a MS SQL server (using openlink drivers), to this point works all fine. What I want to do now is to connect via ODBC to a filemaker database (either mac or pc). Is there a driver to do that? Thanx Ernesto

I keep getting the following error when trying to bring my table into SQL Server via ODBC: [DataDirect][ODBC Sequelink Driver][ODBC Socket][DataDirect][ODBC Filemaker Driver]Invalid character value. Error in column 62. I look at field #62 and it is a global field with nothing in it. I can't figure out what is going on. I have other tables that I imported that had global fields but not this one. Any input would be appreciated! Thanks! John

Ok, I'm trying to import from Filemaker Pro 7 into an Access database, and I've installed the datadirect sequelink driver, and I've got the FMP database open on my local machine. But when I go to import it, it asks for a SequeLink Server Host and ServerPort. Since I know nothing, can anyone tell me where I find these? Thanks, Jeff

i have a filemaker database that runs on a windows-based webserver. i need to access the database via an ODBC connection and im having a very hard time finding answers.... i have filamker7 pro. will the pro version be good enough? do i need advanced or developer or server? where is the ODBC driver? what does the connection string look like if im not using a DSN? if anyone has experience with this i would greatly appreciate the help. thank you

Hello All, I recently installed the ODBC drivers that were on the Filemaker 7 Pro disk. I go to access them, but they are no were to be found in the ODBC Admin. What is odd, is that I go in to a different program that I what to map Filemaker to (UPS Worldship) and they are there, but there is a blank line seperating them from the other drivers. Any ideas??

Under Administrative Tools on my computer there are a number of default Data Source files installed with Windows XP(SP1). However, the only ODBC file present is: Microsoft ODBC for Oracle. Version 2.575.1022.0 File MSORCL32.DLL Date 20/02/2003 So to be able connect to FileMaker using an ODBC datasource at some time in the future I thought I would download the relevant file from the Filemaker website which can be found at http://www.filemaker.com/support/updaters.html I downloaded the file for Windows, clicked on Setup and everything installed it appeared with no problems. Went to C:ProgramsDataDirect and all seemed OK. So I selected the OD…

I am trying to Import External data into Microsoft Excel from FM Pro 7 through ODBC Connection. Fm Pro 7 is Host and Microsoft Excel is Client. Error "Parse Error in SQL" occurs at final step of "Query Wizard". Why it is so?

I have set up ODBC so I can import records from Excel using ODBC. Each time I do, the dialog box it says that all the records were skipped due to an error. Is there a log file or somewhere I can look to find out what the errors were? I tried the get(lastodbcerror) code, but it just returned 0's. Thanks.

I am trying to issue the following TSQL command against a FMP database: Select * from OpenQuery(HWSWDATABASE, 'select "Servers"."ServerName" from "Servers"') I set up a FMP DSN, added the DSN as a linked server on our SQL Server 2000 machine. I receive the following error when I issue the query above: Server: Msg 7341, Level 16, State 2, Line 1 Could not get the current row value of column '[MSDASQL].ServerName' from the OLE DB provider 'MSDASQL'. [OLE/DB provider returned message: Requested conversion is not supported.] OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetData returned 0x80040e1d]. I didn't know if I had the correct syntax that …

I'm wanting to do a daily import from MS SQL2000 into FM Pro 7. I'd like to place a timestamp field into the importing table so that I don't duplicate records previously imported. Can anyone give me a clue to how this might work? jp english [email protected]

My PHP says that it is connected, but I suspect that only means it has found the ODBC. Then on trying the query I get: [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Database not open. Everything I can find in the help files seems to indicate that just having the *.fp5 open in FM 6 should work. But it doesn't! I suspect I'm missing something obvious, but I'dstill be grateful if someone could put me out of my misery. As ever, Sandy

I am trying to connect to a FMP database using JDBC, and I can get it to work with JDK 1.2.2. Does anyone know what version of Tomcat is compatible with fmpjdbc12.jar and JDK 1.2.2? I tried 3.3.2 as well as 4.1.31, and I can't get either to work. Thanks in advance!

Any ideas on how to make FileMaker faster on the ODBC queries. One of our smaller databases (2500 records) can't seem to perform a query without timing out.

Hello! I am trying to connect to a Filemaker 5 (.fp5) file from a Java program using JDBC (driver fmpjdbc12.jar). No matter what I put after the second colon in the getConnection("jdbc:fmpro:c:test.fp5") function, I always get the following error upon execution (it compiles fine) JAVA.SQL.SQLException: [973] invalid database It appears that I have the driver installed correctly, because I can comment out the second line below and it compiles fine. Also, I am able to connect to an Access database using a different driver. I have the file "test.fp5" in the correct folder and open. My code is pasted below: Class.forName("com.fmi.jdbc.JdbcDriver"); C…

Hello, I search the folder "xDBCODBC Client Driver Installer" on my Filemaker CD byt I don't find anything! I have FM Developer CD, FM Server 7 CD and FM Adv. Server 7 CD and I don't find the "xDBC..." folder. Anybody can help me ? Thanks! David

I've been trying to use Dreamweaver to develop some simple pages connecting to my filemaker db at work. I've got a successfull connection going with my Filemaker DB and I have successfully displayed some information from the DB on a page for testing...that worked. I am having issues with inserting records and mostly issues with spaces in these field names. Almost all of the field names in the Filemaker DB have spaces. For instance I'm trying to do a very simple lookup based on an item number... <% Dim rsResults__MMColParam rsResults__MMColParam = "1" If (Request.QueryString("itemNumber") <> "") Then rsResults__MMColParam = Request.QueryStr…

Hi, I'm trying to share data from FM7 with an Access database. I installed SequelLink according to the FM help pages, but it doesn't show up as a datasource in the ODBC section of Administrative Tools. What am I doing wrong? I'm on an XP machine, running the latest MDAC, fresh installation of FM7. Thanks. Aaron

Hey all i am trying to download a picture from a container field in a FMP7 database ... i checked the conversions from filemaker types to JDBC sql types and Container converts to BLOG so after connecting to the databas i executed the following code public void executeSQL(String statement){ try{ Statement stat = con.createStatement(); ResultSet result; System.out.println(stat.execute("SELECT thing FROM TEMP")); result = stat.getResultSet(); result.next(); ResultSetMetaData md = result.getMetaData(); System.out.println(md.getColumnName(1)); System.o…

Hi all, Is it possible to include logic in a SQL statement to start an internal Filemaker script? If there are posts on this topic already, please feel free to point me in that direction. Thanks! Kevin

Does anybody has an example of JAVA working with JDBC and FMP?

i'm trying to get an id card printing program called idworks to connect to my filemaker db using odbc. the idworks computer operates on windows xp pro. i'm using the odbc drivers that were installed with fm6. i'm able to get the idworks design program to recognize the fm db and then link tables and fields. however, when the time comes to actually access the information in production, the program freezes and so does the fm program running on the host computer resulting in a force quit. any ideas on what may be causing this? up until now the idworks program has been using a local access db. however, it does provide the option to use a remote odbc data source. …

I have spoke with FM Support and they can duplicate the issue but are not sure how to solve it as it is with the Filemaker Pro ODBC driver developed by Merant (no longer Merant). It has a problem accessing several 1,000 records. I receive an error along the lines: unknown error an attempt to fetch forward... I am trying to link to FM6 via the Filemaker Pro ODBC driver from Excel and MS Access 97. Please help!

Is there a way to connect to more than one ODBC data source in FM 7. I need to be able to connect to a SQL server and a MySQL server and pass data between. I know I can connect to one get the data in FM and then connect to another and pass it on. I am basically wanting to do a "Insert into SQl select from Mysql" statment. Hope this makes sence. Thanks, Brian

Hey, all. I have a very simple SQL statement that is only doing a SELECT on one field (and it's an indexed field, too) with no WHERE clause. When I get to this part of a Windows Scripting Host script: iAffect = 0 msgbox "cmd.Execute(iAffect)" set rs = cmd.Execute(iAffect) The command takes about 20-30 min. to return. The .fp5 (under FM Pro 6) that I'm querying is about 7800 records. Does anyone have any ideas as to why FM would take half an hour to just process that query before I even got to walk through the recordset?

I added an auto-enter text field to a layout in an FM7 table to hold an SQL command. When left, this field automatically uses EventScript to launch a script called "SQL Test" (with the parameter being the field contents). The script has one line: Execute SQL (specified by Get(Parameter)). The table is correctly set up in ODBC. The script runs, but nothing happens--I expected a window to popup to display the SQL results. I've used FM's SQL Query Builder to import records, but apparently this feature cannot be used to directly query an FM table. I can use MSQUERY to query any FM database (including the current one), but I'd prefer to do this internally through a t…

Okay, I've been through the nightmare of getting the SequeLink 5.4 ODBC driver to pass the "Test Connect" but now I am still having problems. I have my database open with all the ODBC/JDBC file sharing options enabled. I've installed the ODBC driver on a test server. I use an ASP page to query the database that has code like this: Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, dbConn, 3, 3 recnum = rs.RecordCount rs.close On the test server, it's slow, but it works. I then installed the ODBC driver on a production server, and ran the same ASP code. This time it had an error: Microsoft OLE DB Provider for ODBC Drivers error '80040…

I'm happy to say that I was able to reproduce the problem and found a workaround. Please use this test case for problem reproduction and workaround in version 7. Problem: Memory locking by jdbc driver when inserting records. Your program can generate the following exception and crash when inserting 100 or more records: java.sql.SQLException: [DataDirect][sequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Out of memory. Workaround: Prior to an insert statement (e.g INSERT INTO Database), append text to a text field, in this case JTextArea. This is a strange workaround. I'm not quite sure why inserting text to a text field relea…

I am trying to update tables within a MS Access DB. I do it using the Execute SQL script command. I can't seem to make the statement move from the FM table to the Access table. The command I'm using is the following: INSERT INTO WebOrders ( F1, F2, F3, F4 ) IN LunchRecords SELECT Orders.OrderID, Orders.StudentID, Orders.OrderDate, Orders.DeliveryWeek FROM Orders; Where WebOrders is the MSAccess table, F1 - F4 is the field names LunchRecords is the ODBC name and after the SELECT are all the fields that I want to take from the FM DB to the Access DB. The problem is, that the fields (after the SELECT statement) are not being transfered to the Access DB. What…

I need a simple code example for connection ODBC of FileMaker with CodeWarrior, where i found this example? tank for you help.

Is it possible to use Active Directory authentication to connect to a Filemaker database with ODBC? Does anything special need setup for this? Thanks, Enzo

Please forgive my newness to these issues. I have been working with databases for a long time, and Filemaker for a long time. All of this work has been seat of the pants, and while some of it has been complex, I am not a

So I have ODBC running, and been nicely coding PHP w/odbc, I ran into some minor issues and was able to resolve them, but now I see a bug in the driver or FM. - or so I think - When I perform SELECT name1, name2,...name[N] with odbc_exec I get result but if N > 35, meaning if I select more then 35 columns I get the result in a circular fassion. Values returned for name[36] go into name[1] and so on. This overwrites my values in name[1]... brrr.. Is there a limit on number of columns you can select on? Is this a bug? Basically I cannot select on more then 35 columns, which I despratelly need result for. The browser does not time out don't worry. And I a…

I admit it. I got a job I'm not really qualified for. They know it, and they hired me because I'm cheap. Anyways, I'm trying to synch UPS's WorldShip software with the database. They provide a method for doing this using maps and ODBC. The problem is, I have no idea how to use ODBC with Filemaker. I don't have any documentation here, and I'm at a loss. Is it done one the server end or what? I've managed to do most everything else they've asked, but now I'm begging for your help. Anyone know of an example of setting up ODBC with Filemaker Server 5? Or am I barking up the completely wrong tree? Thanks. Ben

I am using FMP 7 server advance to host a database called "AdmissionApplication". I am running a tool called "testjdbc provided on FMPro 7 server advance cd" to communicate to the database. This tool uses the SequeLink JDBC Driver to communicate with the database. Problem: 1. I can't seem to setup any password to access database. It only accepts Admin with no password. I have setup an Admin password on the database. Connection con; try{ con = DriverManager.getConnection("jdbc:sequelink://129.78.231.177:2399;databaseName=AdmissionApplication",userName,password); }catch(Exception e){ System.out.println(e); } 2. The connection works fo…

Does anyone know if there is a JDBC driver for FileMaker Pro 7? I am trying to implement a solution where I want to send some data from a HTML page to a database and I do not have the Server or Advanced version. I read that to send stuff using GET method it uses a grammar called fmresult.xml which comes implemented on the Web Publish Engine. Thanks!!

I want to be able to extract data from an Oracle database running on a Sun Unix machine. To date, I have been using SQLGrinder on Mac OSX to issue simple SQL commands, but I want to do more advanced things than SQLGrinder can do. I have been told that it is possible to access the database using ODBC and FileMaker. However, I am an ODBC novice. What I would like to do is to be able to access the data from Oracle, and use FileMaker (or something else) to produce reports for me. Neither the FileMaker nor the Apple support sites contain any useful information about ODBC that I can find -( Could someone confirm for me that what I want to do is possible,…

I have had adequate success using ODBC to send simple SQL queries to FMP. But I'm now having difficulties querying tables that have Summary field types. When I run a simple query like "SELECT `company name` from Clients" the FileMaker interface mostly locks up (as it always does on ODBC queries) but I can see a dialog about calculating Summary fields. Eventually my program making the query raises a spectacularly uninformative exception*, although FMP continues to chew through 99% of the CPU until I eventually kill it. If I delete all Summary fields in a test copy of the database, the query works as well as it should. Through experimentation I've found I can som…

this is probably not FM's fault for poor ODBC/JDBC usability. as i was just trying to see if FM's ODBC/JDBC connections work well, i got stopped once and once again by SequeLink's annoying error messages. ODBC: - cannot connect to remote FileMaker sharing file at all (shared by FMP). returns error code "authorisation failed." - cannot connect to local hosted files if the filename has spaces - Crystal report cannot access to the database if it contains complicated structure and foreign characters JDBC: - cannot connect to remote FileMaker sharing file at all (shared by FMP). returns error code "authorisation failed." (stunned to discover that it'…

Hi! I have an information collection system made with Filemaker 6, and I - today - export and import this information to a remote MS Access database, from which I deliver search functions, etc. in an ASP environment. I'm a newbie and would like to know if there is any way of updating the MS Access file directly from FM using ODBC? How should I go about making the connection? I have checked the ODBC configuration for MS Access, but they only let me select a local file. I want to use Filemaker as the frontend, and I only need updating functions (INSERT INTO) for MS Access. As soon as a record has been "transferred" from FM to Access, I delete it in FM. Anyone…

Post deleted by Jeff Albion

Buenos Diaz... Trying to troubleshoot a problem with ODBC, primarily for Dev 5.5/6. Having been around FM for a few years, I know I have seen the FM Driver set up within the ODBC Control Panel in the past, but for some reason it wasn't there. I then went into the registry to see if I can hack the settings, and it seemed to show the driver finally, but it said there was something wrong with "set-up" routines for the FM driver. Then I proceeded to do a clean reinstall, and the f-ing thing still won't work. I've looked throughout the fm forums for an answer, but found nothing remotely related to exactly how to manually install the driver. Even forced mys…

Buenos Diaz... Trying to troubleshoot a problem with ODBC, primarily for Dev 5.5/6. Having been around FM for a few years, I know I have seen the FM Driver set up within the ODBC Control Panel in the past, but for some reason it wasn't there. I then went into the registry to see if I can hack the settings, and it seemed to show the driver finally, but it said there was something wrong with "set-up" routines for the FM driver. Then I proceeded to do a clean reinstall, and the f-ing thing still won't work. I've looked throughout the fm forums for an answer, but found nothing remotely related to exactly how to manually install the driver. Even forced mys…

I'm trying to set up an ODBC data import from a MySQL datasource using Filemaker 6v4 on Mac OSX Jag. The biggest problem that I'm noticing right now is that the Network Protocol option list is empty. I can't choose TCP/IP, AppleTalk, etc. It's just empty. Any ideas why this might be happening? I'm logged in with an administrator level account. Second problem - i'm not sure if this has anything to do with the missing network protocols, but my plug-ins are missing too. The plug-ins box on the plug-ins tab in application preferences is just empty. I can't enable ODBC connections, so i can't do the ODBC import (tells me that "the translator for this file could not be fou…

I'm trying to add a System DNS on MacOS X for Filemaker (6 or 7). (Having installed the Filemaker ODBC drivers using the install utility (where does the driver ends up?) I tried the ODBC Administrator in Utilities, no Filemaker between available drivers. I installed the Openlink iODBC administrator. But no result either... Anybody experience with configuring this or another way to share Filemaker database to other applications? Help very much appreciated.

Hello all, I have an application that runs on FileMaker Server 7 and clients with FM Pro 7. I am trying to make available through the WEB some data hosted on Server 7. As FM Server 7 doesn

FM db is currently importing data from SQL on web server via ODBC scripting. The SQL is fed from a web-based form. On the SQL database I updated a field to accept 8000 characters, so that it can be fed by a text area on the web page. However, when the script imports it into a filemaker record, the FM database only captures the first 1500 or so characters. I checked the target field in Filemaker and confirmed that there is no character limit in the validation. Any clues I'm missing? Is this a SQL issue or a Filemaker issue?

OK I have made the bridge from FM7 table to a Database in VFoxpro. I have no problem importing from the VFP dbase through ODBC. OK So now what I want to do is access a new record that was created in Vfoxpro base after the initial import. How do I achieve this? Does that make any sense? Thank you Brian

Hello everyone, I'm working with a 3rd party software that is sending query over ODBC in what I think is some sort of ANSI mode example: SELECT "Age","Last Name","First Name","DOB","Sex","MI","Height","Weight","ID1","ID2" FROM Demographics I was wondering if there is anyway for FMP to accept this type of query? I know in MySQL you can run in a ansi mode which will treat the "" as idenitfiers not as a string. Right now the result of that statment looks like this: "Age" "Last name" "First name" Could someone please point me at the right direction. Thank you

Hey all i have a problem with connecting to the JDBC driver i think it may be where i have installed the driver or if infact i have installed it properly at all in my java file the line Driver d = (Driver)Class.forName("com.ddtek.jdbc.sequelink.SequeLinkDriver").newInstance(); is throwing the exception of noclassDefFound so i was just wondering if there was anyway i should set up my drivers sorry its so vauge

Hi, is there some one having this problem whit Filemaker 7 ODBC abd Visual CE 8.1 "Parse error in sql" ??

Hi, Hope someone can help! I want to use FileMaker as a front end to SQL Server and want to be able to insert to the table in SQL Server using FileMaker layout. I can select the fields by ODBC but don't know how to insert. If anyone knows where I can find the step by step info to do this would be great. I am going crazy with this. Please help, thanks.

Ok I hope I make sense... Have successfuly imported records from our FoxPro database via ODBC into my FM7 solution... now How can I keep the FM7 table updated with said FoxPro table. We need the info current in the FM7 table from the FoxPro. IS this possible? Brian

I am wondering if anyone has seen an ODBC driver for Mac that would work for Informix 7.X SE? I am about to start on a project involving FMP 7 and the previously mentioned product among others and I am looking for the easy ways before I try the hard ways. I work on a Win XP machine, so I am used to seeing Informix listed in the ODBC setup dialog, but I am not sure of my options on Mac.

I've managed to install the DataDirect SequeLink 5.4 driver on 2 systems (one XP the other Windows 2000). And following the FileMaker 7 ODBC and JDBC Developer

Hi I am new to using Filemaker, and I am having problems getting the DataDirect Sequelink for ODBC 5.4 to install correctly. The driver does not appear in the list when adding a datasource. I have read that there is a bug where I need to install....remove...and then re-install, but this had no effect. I even tried installing it on a different PC in my office (also WinXP) but still no luck. I have the MDAC 2.8 installed. Any ideas?

Where can i download an filemaker ODBC driver ? thanks for your help

New to SQL I am doing something wrong in my SQL query to pull the data from last week. I have used the form WHERE dbo.UserEvent.DateModified > (now()-7) changing the date indicator "now" to date, today, currdate and playing with the brackets in different forms makes no difference. Mostly I get [Microsoft] [ODBC SQL Server Driver] [sql Server] 'now' is not a recognised function name.(-1) changing the bracket type can change the message. This request is an exact copy of one suggested earlier on this list, where have I gone wrong?

Hello! I would like to write my own ODBC driver to access an unstandard database based on binary files with specific structure. I would like to ask: Does it already exist an ODBC driver for specified case? .. I found out som drivers for text files .. user has to specify the structure of the files and that it .. my problem is, that the database files are binary .. is it a problem? Thanks a lot, Majo

I would like to know if there is an example or description how to use JDBC to connect to FM-database with WebObjects EOModeler? FileMakerDeveloper 7 | MacOSX 10.3.3 |

I have had a link with an old oracle database v7.3.3.0.0 in OS 9 and windows though FM 6 for a few years now and it looks extremely well, but I am now looking to update to FM 7, but I don't think I can link to this oracle db from OS X. Can anyone help with this query? Also what oracle client software is available for OS X, I have the ODBC driver for oracle, but am having a huge problem finding any client software like SQL*net for OS X? Thanks, Kieron

How can I connect to ODBC using MAC? I used the Execute SQL script step and when I specify the ODBC data source, it will display this error "The translator for this file format could not be found or could not be initialized.

I am trying to set up the DataDirect ODBC file on my XP Pro box with Developer 7. I would like to link the FMP file within an MS access data base. Both files are resident on the same PC. The data direct set up keeps asking for host names, port addresses, and file names. I could understand this if the data was on a separate server, but I can not figure out how to set up the driver within a PC. Any one solve this issue yet? Thanks Ron Filipek

A few weeks ago I created an ODBC connection to see how easy it was to pull data from FileMaker into Crystal Reports. The good news is it was pretty easy. The bad news is it is really slow. No surprise here for most of you folks I imagine. Long story made short; it was so slow that I gave up the idea of connecting the two and deleted my System DSN. I should probably mention that I'm running on Windows XP. With that background now to my real problem; every time I create a new non-FileMaker (Oracle) based report in Crystal it now takes a long time to to get to the table linking screen after the tables have been added. Before I installed the FileMaker driver i…

I am having serious trouble trying to connect to an FM7 database through ODBC from either VB6 or VB.NET. Although the SequeLink driver appears to work OK from Access or Excel, when I try even a simple connection programmatically, I get a variety of errors or FM simply crashes. Is anybody else having similar issues? Or conversly, is anyone able to connect to FM7 via ODBC with either VB or C++ in a stable and reliable way?

Okay, seemingly simple problem, yet no aparent solution to me after hours of searching on the topic, so any help is greatly appreciated I have a FileMaker 6 database that consists of all computers in the school district I work for, done by one of our assistant principals, along with fields for problems and tickets. Working in the Technology department, I wrote a PHP application to be used for web problem ticketing... teachers and faculty can report problems, it creates a ticket, and then allows for administrators and IT personnel to update the status of that ticket, and even view history per computer by their unique town asset tag. I can import these tickets in…

I've been trying, and get the same indexing error.

Hello. I am trying to connect to a FMP 5.5 database from Access 2000. The database is exposed through the DSN (I can see it), but when I select the FM database, I get error: "the operation failed. There are to many indexes on table [tablename]. Delete some indexes and try the operation again." I deleted all the indexes and I still get this error message. Any ideas? Thanks. Walt

Environment : windows 2000 , VC 6.0 Dear all, I have installed evaluation version of Filemaker Pro 7.0 I am trying to fetch data in filemaker database from my VC application using ADO. I am using the DataDirect 32 bit SequeLink 5.4 odbc driver to make a DSN based connection. I am successfully able to make a connectin and write into it. But when im trying to read data from it , it gives problems. Its observed that if it has a multiple of fields with same datatype ( e.g. numeric) and the fields have data present in them in the table , there is a problem in retrieving data. ADO reports "Numeric Value out of bounds" for numeric fields an…

This may be a stupid question but i can't seem to find the answer. I have a Microsoft Access db that my FileMaker db reads from and writes to. I want to count the number of records in the Access db before i write to it. The only way i can think of doing this using the Execute SQL statement with the following query: SELECT COUNT ("GUN_ID") FROM "PLAYERS_1" Gun_Id is the first field in the Access table and Players_1 is the table name. It executes without errors but i don't know where the returned value goes. Is it held in memory? How do i get the record count into a field in my FileMaker db? The Access db is on a remote server and i access it from FileMak…

I am having difficult time trying to figure out how to use Crystal Reports 8.0 to remotely retrieve the data from FileMaker Pro 6 database. I have both Crystal Reports and FileMaker Pro 6.0 installed on my machine. Our FileMaker Pro databases are stored on Mac server with FileMaker Server 5.0. I have checked all the databases had

Hey all, I

Hi All, I am using the following code in my ASP page to read a image and display it. In my code first i am reading the binary content of the image that is saved in the database and then converting it to a string using "RSBinaryToString" function, finally appending the string content to that blank image. Then i am planning to display in my ASP page. This works perfectly when i do in Windows 98(PWS), but when i try the same in Windows 2000(IIS) the image is not created properly. What is the problem, what code change should i do to make it work in Windows 2000 system also, or is there is any alternative for this?. Plz treat this as urgent. For u'r information i am using f…

I need to have an Internet catalog, made in FMP-U piped through Access facade. Where can I find a ODBC driver to make this work.

When doing an import using an ODBC data source one must specify the "Data Source Name" and of course a logon and password if required. I would like to be able to pass the data source name to a scripted import records function so that I could easily redirect the query between a production and test database. I know this is possible with the PDM SQL plug-in but can it be done using the import records function in FM7.

I'm trying to access to a database FM with JDBC,but I can not access to the fields(it says ) if I don't open FM application and the FM database first How could I open it without open first and what FM program do i have to use? Thanks

I'm starting to work with JBDC and I can not use the instructions statement.execute/executeQuery with Resultset and see the information that it suppose to be inside the DB. ResultSet rs = fmpStatement.executeQuery("select * from "PERSONAS_Old.fp5""); and after how can see the informatoin inside rs?

Is it possible to retrieve container data (images) from a SQL statement via ODBC?

Hi, when I want to connect to my FM 5 database with MS Access using ODBC I get the error message "to many indizes". So what's going on and what can I do? Thanks Volker

Is there any guides for the complete novice on connecting a FM table to an MS Access table. I have a projects database that I want Filemaker to populate a MS Access database. I looked at the OpenLink driver but it started to make my head spin. Basically, I want FileMaker to update the Access database whenever there are any changes to the projects database. Even better would be that the user of the Access database could make changes in Access and have those changes appear in the FileMaker database. Please help point me in the right direction. Either Mac or PC direction would be great. We're also hosting our DB on FM Server on a W2K box. Cheers. Mich…

my filemaker pro 7 is running on windows server 2003. MDAC 2.8 and DataDirect SequeLink for ODBC 5.4 installed and running. I am linking Enterprise Campaign of http://www.arialsoftware.com/ to a simple filemaker pro emaillist.fp7 to keep track of E-mailings. The enterprise campaign links properly to workgroupshare via odbc, but not to filemaker pro. i must be doing something wrong. when i configure the oracle8 driver for filemaker. i get as far as the point where i have to tell the odbc for which database to look. any tips. my database is residing in c:dataemaillist FileMaker Version: 7 Platform: Windows 2000

Have FileMaker Pro 6.0 open on a Win2K Server box. I setup a System DSN using the FileMaker Pro driver in ODBC. I get this error in IE when my ASP file tries to connect: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed /FMTest.asp, line 11 What's going on? FileMaker is open, and the Web Publishing Tool is on and configured. So much for ODBC working with FileMaker... Version: v6.x Platform: Windows 2000

Does someone know if I can create a Webapplication and get data from FileMaker pro 7 with the JDBC connection if I run a Webserver and FM pro7 on the same machine? regards: dalahasten FileMaker Version: 7 Platform: Windows 2000

We are experiencing 2 different problems when pushing data into FileMaker from our WebObjects/Open Base world. 1) We are receiving many "Host Not Found" error messages when trying to dump records into FileMaker. Many records come through okay, but some look like partially downloaded records and then need to be removed before the next download. 2) Some records are tagged as having made it into FileMaker, but they don't appear in FileMaker. It's as if FileMaker is giving incorrect confirmation. Any thoughts on how to troubleshoot these problems. The FileMaker machine is running WindowsXP, FileMaker. FileMaker Version: 6 Platform: Windows XP

I'm trying to access FP7 from Visual Basic using ODBC. Unlike the FP6 trial, it appears to be rather unstable. I'm getting GPF's from FileMaker for trivial queries. Any suggestions? Version: v7.x Platform: Windows 2000

I can import and export a filemaker/access database but I would like to do it through a script or any other easier way so my users just click a bottom and we can have the information exchange. Version: v6.x Platform: Windows XP

Hi all, i'm using the JDBC driver from FileMaker together with Apache's Cocoon to build a web application. On updating my data i create a SQL statement containing a single quote in the new value, like the following: update "Produkt.fp5" set name='Thank's' It don't work, i receive a error message from FilemMaker. I tried to escape the single quote with '', ', %27, and some other, but i don't get it to work. I've found a similar thread in this forum, but without solution. Is there really no solution to this problem ? Many thanks in advance Kai

I used FMP utlizing FM server, but that is no longer an option as we are hosting remotely with MySQL. Can I create FMP front end to manage the MySQL data? Version: v6.x Platform: Mac OS X Panther

Just now I am using CDML to web publish while I am using FM 6.0 and server 5.5. The problem is that if I want to upgrade the solution to FM 7.0, I have to change the way to publish the data on the web site. Is there any good advice to upgrade the existed solution? I have noticed that the FM 7 is so different with the old version. [color:"pink"] Version: v6.x Platform: Mac OS X Panther

I'm working with an inherited config and have very raw SQL skills. I'm trying to update a script in my FM 5.5 db that imports from an external SQL table. The main issue is adding new fields to the SQL table, and then updating the FM script to import matching values. Details: The present config imports known matching fields from SQL to FM using a Filemaker script which operates through an ODBC plug-in. The plug-in and drivers reside on a client PC running FM 5.5. I created new text fields in the SQL table and then created identical text fields in FM. In the current ImportSQL script I'm looking to modify, it presently imports data from a set number of fi…

Is there a way to install the ODBC drivers on a separate PC without having to install the full Filemaker application? Or, is that against Filemaker licensing?