External Data Sources

I have the following in my WHERE clause: (release_date > date() - 3) and it results in the following error: Error: Incompatible datatypes in expression : > (State:37000, Native Code: F54) Is there any way to do Date Math in an ODBC query of FM data?

I run my VB program in single user (locally) and all goes very well... When I want to access to the server, I type the server adress in the ODBC and It doesn't work... runtime error of communication... does anybody can help me?

I'm trying to do a simple inner join via JDBC, but all I get is an "invalid argument" error. I've even tried creating a very simple pair of files to test with (in case my real data was causing the problem): Table 1: name.fp5 Name_ID Name 1 Fred 2 Joe 3 Sam Table 2: phone.fp5 Name_ID Phone 1 555-1234 2 555-4321 1 555-1111 3 555-1357 I've tried 3 SELECTs - the first two work just fine, but not the third: SELECT * FROM "name.fp5" WHERE "name.fp5".Name='Fred' (WORKS) SELECT * FROM "phone.fp5" WHERE "phone.fp5".Name_ID=1 (WORKS) SELECT * FROM "name.fp5", "phone.…

HELP, I need to connect to an oracle db and use some sql statements that would bring data based on the unique id entered. I need help on accomplishing this. Do I use ODBC and how to setup. Or is there a better solution out there. Thank you.

Is there any way I can connect to a AS/400 V3R2 from filemaker Running on a windows system?

Hello, We are trying to import data from a MySQL server into a Filemaker database in a Macintosh environment (Mac O X 10.2.8). Is it possible? We have the MySQL database and MyODBC configured correctly (the odbctest application runs without problems). We have configured it using the Mac's default ODBC Administrator. The problem is that we can't access the MyODBC driver from the DataDirect's ODBC Configure tool developed with the FileMaker. FileMaker gives only the possibility to choose the DSNs configured with this last tool. Is there any solution? TIA, Jon

Hello, Crystal to FileMaker newbie here. I'm trying to build a report using Crystal from data in FileMaker. Crystal wants me to enter a sql statement but I don't know the syntax and can't find it anywhere. My FileMaker file is called InstBase.FP5 and in that file is a field called Model. I would guess that the sql would be like: SELECT Model FROM InstBase.FP5 but that doesn't work. I've tried dropping the file extension, surrounding the file and field names with quotes, adding a semicolon to end the statement etc. Can somebody help a dope like me write this statement. Just pulling one field from one file? Thanks, -Ted

Hello all, i am very new to the FM and i have v.4.1. - To be very straight, i want to import data from SQL server to FM pro using ODBC which i was able to do but i am unable to pass dynamic sql i mean dynamic parameters while using ODBC dialog which has the title "specify ODBC sql query for <odbcname>", for intance i want to get records from a table having serial_no > x and i am not able to pass the parameter here. - I have tried it using sql plugin where i am able to contruct the sql query dynamically, got connection to sql Db and executed the query using SQL Plugin commands like Execute("SQL-Open","odbc|uname|pass") -to establish connection…

OK i just posted a message below this and started reading a bunch of other posts. I thought i knew what i was doing.... Can SOMEONE please confirm, what the most practiced way of importing from MySQL to FM is. It is my understanding that a bridge app must be made that will grab from MySQL either with JDBC or ODBC and import into FM using JDBC or ODBC. Is there some way through the FM Pro scripting interface that one can import directly from MySQL into fm itself? And specifically from FM server served files? Thanks.

I have a FileMaker Pro db used for student registrations. My org is purchasing a remote-training software based on Access (front-end) and SQL Database (backend), using ASP pages to generate API calls. We need to determine ASAP whether I can begin registrations in FileMaker, and then automatically send the correct API call to the Access database. User interfaces are web-based - I use CDML, and the Access database uses ASP. I know nothing about API or ASP, but I have the coding for both sitting here in front of me. Would it be possible to have FMPRO automatically create an ASP page or perform an API call to another database?? Any help is greatly greatly appreciated!!!!

Searching fmforums for this yielded hundreds of potential posts but after the first hundred my eyes started to glaze over faster than a Krispy Kreme doughnut and I wasn't getting anywhere, so... I have a MySQL db (that I did not setup) which contains multiple records for a single customer, with the customer's email address as the primary field. I am using ODBC to import the records from the MySQL db into FM Pro Unlimited under Win2K. In the MySQL db, the data looks like this: MEMBER_ID FUNCTION ACTIVE [email protected] upload Y [email protected] download Y [email protected] delete N I would like my FM db to con…

Hi: I'm Working with ORACLE and FILEMAKER, I want to execute stored procedure of ORACLE in FILEMAKE with Filemaker ODBC 4.0 Oracle Wire Protocol Driver. Can someone help me?

got a database on winxp clients FM 6 & FM server 5.5 -set up odbc on the clients and do a mail merge in Word -after connecting to the data source, I have the following issues: 1) its very slow - it takes about 10mins (I see FM doing Sum fields etc.) 2) word sometimes freezes 3) FM seems to find all records rather then keep the found records for the mail merge. any tips on this please?

How do one trigger an application in Window within FM? I wanted to find out is it possible to use the function of MYOB (autoimport through ODBC) within FM to automatically import into MYOB? Any help would be appreciated. Regards bblaw

Hi All, I am in the process of writing a simple app that will import data from a mysql Db and dump them into a couple of FileMaker Server 5.5 served files. Is this possible? I can successfully connect to the fm files with ODBC when i am serving them from the FM 5.5 client but can't seem to do so when i am serving them from FileMaker Server. Obviously there is no data access companion plug-in to the Fm Server?? Or am i missing something here? If i am forced to serve these from the FileMaker Client is it possible to run the client on the same machine as the Server? Obviously with the import files in a different location as the FM Server served files. …

I have a database called: "test.fm" I have two text fields: "name1" and "city" I made one record: name1 = rich city = winnipeg The following queries give me the following results (just prints the data): select * from "test.fm" where name1 = 'rich' select * from "test.fm" where name1 = 'rich' or name1 = 'blank' select * from "test.fm" where name1 = 'rich' and city = 'winnipeg' RESULTS: name1: rich city: winnipeg Here are the queries that don't work. They return no results at all. select * from "test.fm" where name1 = 'rich' or name1 = 'blank' and city = 'winnipeg' select * from "test.fm" where (name1 = 'rich'…

I'm a database developer/DBA (Oracle and some SQL server) and, being the new guy at our company, last week I was given the task of figuring out how to write to the FileMaker Pro database for the web guys here. They're using ASP, and so I figured out how to write to FileMaker Pro with FileMaker's ODBC driver, and can insert records successfully through VB Script, but determined that you can't connect to the database (with ADO) unless the FileMaker Pro client is up and running as an application!! Sounds awful already. The web guys understandably do not want an open application on their web server. So, I decided to make the FileMaker Pro run as a service (using S…

This may be in the wrong forum but I am trying to insert a MS Word doc into a FMP6.04 db container field. I get "FileMaker Pro cannot complete the operation because of an OLE (0x80004002) error." message. Any advice? I am running Windows 2000 with Office XP. Thanks DG

Im doing a simple update on 1 field on a number of records, and it takes a minimum of 15 seconds per record to do the update. Multiply this by a few records and it takes minutes, sometimes half an hour or more to update 100 records or so. The database has 12,000 records in it. I'm using standard PreparedStatement and the executeUpdate() method. Why is it so slow? Is there any way to speed it up? Or is this just normal JDBC performance? If so, JDBC is a terrible solution. Anyone have any ideas?

I've heard that you can link MYOB with FMP through ODBC. Would like to hear opinions from anyone who has tried this. Will FMP 6 on OS X connect through ODBC through Classic with MYOB 11? Thanks in advance!

I'm trying to link/import FMP 5.5 data into Access via FMP ODBC (FileMaker Pro FMFMP50.DLL). It fails with "Invalid Field Definition '<field_name>' in definition of index or relationship". I delete the index in FMP but I continue to get the error. I deleted the field in FMP, and now I get the error on the next indexed field. But I'm not even sure if the problem really has to do with indexed fields, when I deleted this field and tryed it again, I got the error on a non-indexed field. Is it actually possible to link via ODBC to a FMP dataset?

I have a client that is using FileMaker Pro in-house on all of their macs including a dedicated G4 server running FM server and they want a front-end to their SQL db (Windows NT) that sits under their web site at their remote hosting facility. I have only worked in MS Access where you can create a front end onto SQL and view real time dynamic data. Is this possible with FM Pro and is it dynamic or does it require importing or triggering updates based on certain criteria? Any info? Suggestions for third party software? I have already set up the ODBC connection.

Hi, I need a bit of advice on what to do. What I need: I have a CRM software with all my customers. ( And I can't swap this with FMPro ). This is SQL based. I have an order DB and a customer DB in FMPro which I need to link to my CRM system. The Customer DB has to be up to date against the SQL DB. Then I would like to perform a search in FMPro to look up a customer. If the customer doesn't exist I have to use Visual Basic code to add a customer to my CRM system. The reason why I have to use Visual Basic is that my CRM uses the COM/DCOM technology from MS and I have to program against this. ( Because of rules and default values that is defined in the comp…

ODBC Users? Is it possible to import checkbox data (where value fields are used) and repeating field data? I am using the native ODBC driver in FMP to import records into a FMP file. 1) How can I get multiple checkboxes in a value field list to be checked based on the import data? 2) How can I fill repeating fields? I am trying to use the ASCII character number 29 (which according to FM is what separates repeating field data in the output), but all that does is: 1) cause no check boxes to be checked (since none of my value fields has the special ASCII character in them) 2) includes a nonprintable character (ASCII 29) in the first field of a repeating set Please le…

I am using the local data access companion with ODBC to insert and select records in a filemaker database with a Visual Basic front end. (Windows 2000, fileMaker 5.5, VB 6.0) Everything works fine except that after a week or so (and it's amazingly consistent) filemaker stops taking all ODBC requests and it has to be restarted to continue working again. Is this a know issue with FileMaker ODBC? Do other people have this problem, or am I just lucky? Is there any work aroud (besides restarting FileMaker)? Thanks, Ryan

I have a Windows network that has a Filemaker 5 database running on Filemaker Server. I need to be able to query and select data from the filemaker database and then pass the results to a Microsoft SQL 2000 database. This process needs to be automated and runs as a background job. I had envisioned a scheduled VB/Perl script to do this data transformation from filemaker throught to SQL 2000. The script would query filemaker through an ODBC data source and update SQL 2000 through a different ODBC data source. It all seemed reasonably straightforward until I started looking at the requirements to setup an ODBC connection to the required data sources. SQL wasn't a problem how…

Hello - I'm an old hack with FileMaker Pro but brand new to the SQL world and I'm learning hands on here... I need to move some data from my FMP database to my "MySQL" branded database at my web server. How do I do this? Currently I have the MySQL ODBC Driver installed on my PC and it does connect to the database successfully (when using the "test connection" button in the driver setup app). I also have MySQL Control Center as my query application which I've used to connect to and set up tables in my remote database. Now, all I need to know is how to actually move the data from the FMP 6 database to the remote MySQL database. Do I use MySQL Control…

Hi I am using php, ODBC and Filemaker Pro 5.5 Everything works fine except this query, which is making my filemaker db hang. Any idea what's wrong with it? SELECT id, username, password, accesslevel FROM pw WHERE company='minster' AND (accesslevel=0 OR accesslevel=1 OR accesslevel=2) ORDER BY UPPER(username) ASC Its something to do with the (accesslevel=0 OR accesslevel=1 OR accesslevel=2) bit but according to what I know of SQL I'm sure that's the right syntax for an SQL query. Or is it... Is there some limitations with Filemaker's implementation of SQL perhaps? The field accesslevel is a number field so that's not the trouble. Cheers …

Hi I am having problems using Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); with the FileMakerPro JDBC driver on a Mac (OS X). I don't know if the FileMaker driver(fmpjdbc12.jar) supports these fields?? If not, does anyone know of any third party jdbc drivers for FileMaker Pro and Mac (OS X). Thanks so much!

I'm currently tring to find a away to import records from a postgreSQL database into a FileMaker 5.5 system. Support and documentation for ODBC/JDBC on MacOS 9/X seem to be lacking. Is there any support for any Mac OS and ODBC? Is this is at all possible? If needed we could use a Windows box to do the importing but would prefer to use our Macs. What are my options?

Hello How would it be easiest to draw charts in Excel using records in FMP ? Ok, I could every time export all records needed to merge-file etc. but to teach this to end users would be too complicated. Could someone please show a simple example how to perform this easier. Arttu

Does anyone have a clue how to prevent scandianavian letters turning into mumbojumbo when connecting filemaker via jdbc to mysql database and retreaving data? The MySQL is running on Mac X Server 10.2.4 and the filemaker is running on X 10.2.6.

As it stands right now, I'm able to synchronize both the creation of new records and the modification of existing records within FM to the MySQL databases on our web server. Thus, when customers come to our website they will be able to view their account information. Where I'm hung up is when records are deleted from FM. I cannot come up with a method to delete the correlating record from MySQL. I'm using PDM's SQL plugin, if that helps. One thought I had was to create a table in MySQL that would hold only the p-keys for the FM customer records. I would empty that table nightly, and then re-populate with the existing p-keys. I could then compare the existing cus…

I am receiving the error message "S1000: [FileMaker][ODBC FileMaker Pro driver]An attempt to fetch forward has failed for table: PRODUCTS" when executing a SQL Query on my VB application (I am using the ODBC Driver packaged with FMPro 6) strSQL = "SELECT DISTINCT * FROM Products WHERE ProductType <> 'Mati

Hi I am investigating adapting an existing tool that extracts input data from various systems to then put into a legacy system. Currently that data can come from a variety of sources, either via XML/SOAP or from a db via ODBC. To do this for filemaker, the XML option has been ruled out by the client due to security considerations so we are following the ODBC route. This all worked fine in a test environment when the machine had our interface table (myfile.fp5) open BUT if filemaker is not currently running using the connection object to open a recordset (we are in VB here) returns: [filemaker][ODBC filemaker driver][filemaker pro]connect failed i…

I'm trying to write an SQL statement for the primary key, ContactID (a serial number). My SQL statement is "SELECT MAX(ContactID)+1 from CONTACTS" -- the statement works (as long as prevent user modification of ContactID is turned off), but it takes far too long to execute. Shouldn't adding a single record to filemaker with ODBC be fairly quick? I don't get it -- ContactID is indexed, so it should be a relatively simple procedure. Is there another SQL statement that I should be using for the primary key?

Hi I have been developing FM for quite some time but have never moved to ODBC. Our organisation uses an Oracle database system as its main database source for other organisational applicatisna and I now want to move in the direction of having a FileMaker GUI and an Oracle backend. I know I have a lot of research and learning to do as I know little about Oracle as well, but I was hoping someone out there has already integrated FileMaker and Oracle and can provide me informationon where to start and learn all this (ODBC and Oracle), and maybe even offer a few sample files for me to play with and see how it all works. Anyway any and all help appreciated. …

Hi, I've got a JDBC beginners question. Does JDBC 'talk' directly to FM-server of like with ODBC only through FM-client? Thanks in advance, Andries

Hello, I've been trying to develop a Java application that access a Filemaker 5.5 Developer DB using the supplied JDBC drivers. It has been a nightmare so far.... Many of some basic JDBC functions are not implemented in the drivers. Simple functions such as getFetchSize(), beforeFirst(), etc return me an error message at runtime. How can you guys work with these drivers? How have you developed your workarounds? Any words from FM as to when we should get decent drivers ? I am not developing a web application by the way. I have to do a program that will insert data coming from EDI flat files into the FM tables.

hi i try to do an insert or update in FMP database by JDBC with a text contains an apostrophe [color:"red"] INSERT INTO table ("fieldtext") VALUES ('d'abord') the insert failed How can i put my apostrophe in SQL i try URLEncode but in filemaker i don't see the caractere ' in my string somebody have a solution ?

I am having two problems with JDBC / FMPro implementation that i would appreciate assistance with. 1. Does the fetchsize option on the url actually work? when i try Class.forName(driver).newInstance(); Connection connection = DriverManager.getConnection ("jdbc:http://localhost:591/test.fp5&fetchsize=20") my connection has no qualms returning 1000's of records. is there any other way to limit the amount of records returned. The FMPJDBC 1.2.jar driver Does not support limit in the select procedure. Has anyone got any experience returning repeating Fields to JDBC. They are initially returned as an implem…

Has anyone connected to a AS/400 using ODBC on a MAC without going thru a Windows machine first? Thanks, Brian

I know somebody who uses FileMaker Pro 5.5 on a Mac (800 miles away) to store data about books and CDs. I'm just getting into Java and want to build a simple project using JDO (or just JDBC) to import this data and place it into Java string objects, muck about with it, then write it out to disk in HTML. (I have to do some pretty weird stuff with the data, so just exporting it to HTML won't work.) I've seen information here and there about a JDBC driver but it looks like you have to have FM 6, or some developer package, or something. I run Windows and Linux and do not actually own a copy of FileMaker--I just want them to be able to send me an .fm5 file and my Java …

Does Filemaker 5 not support ODBC importing from SQL Server 6. I can import on my windows machine using the ODBC driver. But I can't do the same thing on My Mac. Also I setup a Filemaker 5 database on a PC as a host and then try to use the ODBC connecting on the MAC as client. I got an error Importing Via the Filemaker ODBC driver is not supported. Help am I just missing something.

I have done extensive research and found very little info on using Crystal Reports /w Filemaker. I am able to connect to the Filemaker db via Crystal, but when I try and link Filemaker Files and display data I get a join error in Crystal. Has anyone out there solved this problem?

im having problems importing time and date fields into filemaker from access. they always come out corrupted. Any ideas

Does anybody have experience synchronizing address books between Outlook and Filemaker? I'm having trouble setting up OutlookConnect, so I'm wondering if A) it's in fact easier than I'm making it out to be or : there's a better solution out there.

I am trying to query my filemaker 5 database. The database is called testdb. The plug-ins for Local data access comp and remote data acces comp are checked. My fields in my database are as so ID_NUM NAME LAST COMPANY DATE MISC dim cursor as databasecursor cursor=testdb.sqlselect ("select * from tempdb where ID_NUM='"+editfield1+"'") If cursor <> nil then editfield2.text=cursor.field("NAME").getstring editfield3.text=cursor.field("LAST").getstring editfield4.text=cursor.field("COMPANY").getstring else msgbox "Record not found" end if What's wrong with the code It is written in Realbasi…

Hello! I'm trying to open an SQL database with Filemaker Pro 5.0V1. The SQL statement says: SELECT Customer.CustomerNo, Customer.Name FROM Customer I get an error saying Object name Customer is invalid. To correct this I must add the table owner as shown below. SELECT MDBS.Customer.CustomerNo, MDBS.Customer.Name FROM MDBS.Customer MDBS beeing the user / owner of the SQL table. Is there any way to omit this editing in every query? Either in the DSN or in the SQL database.

Hi I am trying to establish a connection to a FileMaker database using JDBC with Mac OSX but keep getting an "803 Host cannot be found" Error. My code (which I am very sure follows the documentation in the JDBC driver fmpjdbc12.jar recommends is Class.forName("com.fmi.jdbc.JdbcDriver"); String url = "jdbc:fmpro:http://##.##.##.##:80/"; String username=""; String password=""; Connection con = DriverManager.getConnection(url, username, password); Any help would be GREATLY appreciated!!!

I am working on a project for a client that uses FM Pro. I have downloaded the FM 5.5 30 day trial version. I created a new table and called it LocationCodes with not extension. I opened the file in FM then selected View -> Preferences -> Plug-ins and selected Local Data Access Companions. Then selected File -> Sharing and made sure Multi-user was checked. I created a System/ODBC called WorldHotel using the FileMaker Pro driver. Below is my asp code: set conn = server.CreateObject("ADODB.Connection") set rs = server.CreateObject("ADODB.RecordSet") conn.Open "WorldHotel" sql = "SELECT CityCode from LocationCodes" set rs = conn.Execu…

Disappointed in the fact that FM5.5 server does not support ODBC, I'm now creating a client-app to insert FM-data into a M$ Access database. It's easy to create a ODBC for a plain FMP 6 data file (often referred to as a database, but it's just one simple table really). But now this data file has a password on it. So when i choose the ODBC to use for M$ Access it does show the tablename, but gives an error on using it. This does not apply if there is no password on the data file. Can anyone tell me how and where to specify the password in using the ODBC?

Hi there ! I found something very disturbing while trying to access my data through an SQL request. The request was built the following ways : Select * FROM Formation WHERE (status = 'student' and university = 'Oxford' and grade = 'first') or Select * FROM Formation WHERE ((status = 'student') and (university = 'Oxford') and (grade = 'first')) even Select * FROM Formation WHERE (status = 'student') and (university = 'Oxford') and grade = ('first') Everytime, FileMaker just did a search based on the last part of the where request (for instance here : grade = 'first'), the results did come right, based on the status and university f…

Hi there, I don't quite know where to write this post, so I hope here will be ok I was wondering if it was possible to have the equivalent of [FMP-CurrentRecID] using odbc. I'll explain myself : using [FMP-CurrentRecID], I'm able to easily edit, delete or display details of a particular record. The problem is, I also want to retrieve all data from my FMP, using odbc, and still access the data throught the file ID. Is that possible ? Is there a way to ask for the record ID using odbc ? Thx for your answers, Jerry

Hello everyone! I am currently running a database (well, several databases) on FM Server and are using FM Pro on client machines to use them. But I am now in the progress of redeveloping our website that is using some information from the databases, and I find it a pain in the a*se to incorporate FM with the website. So, my question is: Is it possible to use FM Pro as a front-end to a MS SQL Server DB? This would make it so much easier to do what I want to do, as I already have all the SQL Server knowledge. Thanks, Martin.

Hi!! I am a newbie. i'm trying to build an SQL sentence that create a table with a unique id field wich auto increments when i insert a new row to the table. I've worked a bit with MySql previously than with ODBC and there i used AUTO_INCREMENT to point the columns of this kind, but with ODBC i've tried to use it and it always returns en error message. I would like to know if this can be done without the usage of any function or if i have to use them, how. Thanks

hi, i am looking for a odbc or jdbc driver for filemaker, does anyone know where to download one for free, thanks for your help

Does anyone have a good tutorial on setting up ODBC between FM and SQL7. Running FM on osX and we need to pull from sql7, Just need to get started. thanks

I've had my databases up and running from a filemaker Pro 5.5 client. I decided it was time to go 'professional' and install Fm Pro Server 5.5 on a powerfull machine (WinXP Pro). My databases are up and running again for my FM Pro 5.5 clients. However, the server version does not make them available through ODBC. When I try to connect, let's say from Access, i get the message "connect failed..." When I look in c:program filescommonodbc... there isn't even a Filemaker folder installed (as is with the client version). Don't say that FM Server does not support ODBC while the cheaper client version does :

Hi all, I have browsed the entire FAQ list, but I have not found a response to my problem. I must access FM from a java application that execute inserts and deletes. All is working perfectly but sometimes the java application hangs with the error "Invalid cursor state" and cannot reconnect to the FM unless it is restarted. Other times the java application breaks indefinitely when committing a transaction. May be it's due to the concurrent access to the FM files from java and FM scripts ?? For information I'm using German version of FM and FMServer. Anyone has never found a similar problem ??

I am trying to get Excel to access data in an FM database via ODBC. Both the applications are on the same machine, no network, no server. In OS9 this was possible & easy using Intersolve ODBC drivers supplied by FM. In OSX it seems less straightforward. The DataDirect text driver supplied in the FM6 installation has no info as to how it should be configured,and using this alone (with its corresponding configuration app) Excel does not recognise that ODBC is even installed..... Howerer, using Openlink's dirvers (and configuration app) I can get Excel to recognise ODBC, open Query and request a DSN. Problem is how to configure the driver, be it either a gene…

I currently have web forms which feed data to a SQL database, then I have several tasks which must synch between SQL and my Filemaker front-end. What I'm wondering is if I can cut out the SQL middleman altogether for some or all of these forms. Is there a way that filemaker can receive data direct from an HTML-based form on our site? Would the database need to be running in Pro or Server mode?

I have a text field, and I want to use whatever text may be in that field to run an SQL query script in Filemaker. Could anyone give me an example of this, if it is indeed possible?

I am curious about using SQL as a back end. My problem is the only reason that I am asking is because so many people have said that it is super fast when doing searches and when summarising many thousands of records. The biggest problem of all is that I have not got a clue as to how to work in SQL, and I don't want to start learning it either! What are the options here? Mark

Dear All Appologies if I have posted this in the wrong place but I am not sure where to start. I need to setup MS Word to link to Filemkaer Pro so that it can acces data stored in a filemaker for a mail merge. We are currently using FM 5 and FM Server 5 with windows 2000 and office 2000. All help appreciated

I have a remote MS-SQL DB I am trying to "hook up to". I have an SQL person helping me as I am clueless here. We got a DSN assigned and I have scripted a series of imports from ODBC data source to bring data down from the web server via TCP-IP (I'm still having some trouble bringing in data from his stored procedures and/or join fields however). Apparently in Access, it is also easy to have the local DB act as an interface for the remote data source, even allowing UPDATING of data on the remote server. For example...I change a field value locally and it automatically changes on the server to match. 1. Is this possible in FileMaker? 2. Is it rocket scienc…

Someone asked me on Private about ODBC. I apologize I deleted this post....but I know peanuts about ODBC. Cannot remeber who asked.

Well, now I know what to do with my classpath, but what do i put in the brackets with class.forName to connect to FM

I would like to request help with Filemaker's JDBC, Tomcat and the J2EE server. I have figured out how to connect a servlet running in Tomcat 4.0 to a Filemaker database using Filemaker's JDBC drivers: // Class.forName("com.fmi.jdbc.JdbcDriver"); fmpConnection = DriverManager.getConnection("jdbc:fmpro:http://127.0.0.1:80"); // Now I'm trying to use the drivers in a web application (CMP, session facade - much along the lines of Sun's Duke's Bank app) in the free J2EE server downloadable from Sun. When I try to 'Generate Default SQL' in the 'deployment settings' for the CMP that uses the driver (via JNDI), an error dialogue box displays "java.sql.SQL.Ex…

Hi all, I was checking out the ODBC drivers available for FileMaker in ODBC Administrator, and don't see what FileMaker Text Driver is used for. The others seem to be selfr explanatory: Oracle 8 driver is to connect to Oracle, althgough I don't know if it works with Oracle 9. SQL Server is also understandable. FileMaker Pro is probably a default for another app to connect to FileMaker Pro. But the text driver? Usually if an app won't work with FileMaker you'd export the data to a text file, and use Microsoft Text driver to connect to that text file. Is FileMaker Text Driver better for this purpose, or just another way to do the same thing? Yo…

I have a FM database with around 200 entries. I have set up a letter in Office XP and connected to the FM files using ODBC. The problem is that I only want to generate letters on about 50 of the entries (based upon the entry of one particular field). For some reason, Office will generate letters from 200. How can I set this up so I can filter out the other files? Thanks. Cameron...

How do I access a Filemaker Pro (5.0) database through a Java Servlet? What would I use here: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("", "", ""); Does anyone know the information needed to use the getConnection(...) function to connect to the database? I've checked my manual and searched around the net, but I can't find this information anywhere. Thanks, B.P.

Hi there! I'm trying to connect to our filemaker database using jdbc. i've written a small piece of java code to connect, however i can't get the class.forName to work. i have the file fmpjdbc.jar . where do i put this and how do i use it?

Hi! I have an application using ODBC. I buy the developper tool to create a stand-Alone use of this application, BUT the ODBC link seems to not working when I use the developper tool. Can someone tell me if it's working with ODBC link and a stand alone use. Thank you! Jean-Guy Fontaine Montreal, Qc, Canada

I am working on a solution to pull data out of SQL Server database into FM v6. I would like to make a script that will be activated automaticaly everyday using a plugin. The problem is that as it's going to be automatic I have to keep in a global field the last importing date so that when the script is activated again it doesn't import the same records. I know that programing in other languages it is possible to keep the last importing date in a variable and the query would be something like this : SELECT * from customers where date > '"lastimport"' lastimport would be the variable. I can't find a way using FM to make an importing ODBC script use a variable. …

Hi! I have Oracle 8 and FM 5.5 Pro. Is it possible to query FM and insert records into it using ODBC? If yes then how? I've spent couple of days already dealing with it, but I can't still get anything from it. Thanks Tom

In Win2k what ODBC driver do I use to connect to FM 3.0 files?

Can someone post a short quick example of how to do a simple insert into FM Pro 6? Every time I try to do a simple insert (1 column) it says "Database closed" however as soon as I replace the SQL with an update, it works fine. Why does it say the databse is closed when I try to do an insert but works OK with an update?!? I tried: <standard conection stuff> Connection conn=DriverManager.getConnection(...) PreparedStatement ps=conn.prepareStatement("INSERT INTO "DATABASE.FP5" ("CUSTOMER") VALUES ('JOHN')"); ps.executeUpdate(); Is this correct to use a prepared statement with an executeUpdate? Or should I use a regular statement and do …

Hi all, We've recently upgraded to FM6 and I'm now experimenting to see how to make use fo the ODBC options....which I'm afraid seem to limited. However does anyone know if/how I could connect directly to databases/tables hosted by FMServer instead of opening them in the FM client first? If yes could I connect to multi-user hidden files? Before everyone asks, I'm running Windows. I know I can tick 'use remote connection' in the ODBC driver setup, but I can't get it to work; I'm sure I missed something. Thanks for all information.

Hi All, I try to connect from Filemaker to SQL using ODBC . But I got this message error when clicking "Test Data Source" ... The error message is : "ODBC SQL server Driver ... TCP/IP socket..Specified SQL server not found ... I use local server ....mean it is only in my computer hard drive. Any one know the problems?? Thanks

Hi I have been wrestling with this problem for days. I have written a php page which adds data from an html form to filemaker pro 5.5 There are 5 fields in the db. Four text fields, 1 number field. It works ok provided none of the text fields contain more than 34 characters. However, if I change the number field to a text field, any number of characters can be entered into the text fields. I have searched everywhere I can think of: in forums like this, the filemaker site and elsewhere on the web for even a mention of why this might be. Can anyone help? I have successfully used php and odbc to connect to filemaker several times before without any pro…

I would like to know if there is an example how to use ODBC to connect to any kind of database? Thanks

Hi There, Does anyone know how do I get the recordID of the record that I just inserted using jdbc ? In CDML after doing "-new" it's available in the page. But the JDBC documentation does not tell me any such thing. Thanks.

Hi, I would like to start using OS X (Jaguar) to run some FM databases. The only thing is that I have noticed that FileMaker under OS X does not support ODBC, even though OS X does have ODBC capabilities. I'm running FM v5.5, but I'm pretty sure that v6 is the same. Does anyone know what FileMaker Inc's plans are with OS X and ODBC? Thanks, Peter.

I am using Excel to generate charts of data extracted from FM6 with ODBC. It takes 12 minutes to extract 16 fields across 350 records. This seems unusable. I can export this data from FM to a wk1 file in a few seconds. Is this a typical export time with ODBC normal or is something wrong in my configuration or setup. Thanks

I'm trying to use a Visual Basic program to send data to FileMaker using ODBC , but the drive doesn't show on Visual Basic. I have other databases on this computer and all the ODBC for these other database show on Visual Basic to be chosen. Does someone know why FileMaker ODBC doesn't show ?

Hi all, I have been using a .csv-file import for a long time, and it has been working ok. It has been populating the auto-numbered fields like creation date and a unique ID. But when I started using ODBC-import for the same information, it stopped doing the auto-numbering. Is it a known issue, or have I just forgot to tick a box somewhere? Thanks, Martin

I have been experimenting with ODBC in FM5.5 and it is very clunky. Having checked out some of the posts from the last year in this forum, a number of people expressed the hope that the ODBC driver would be better in FM6 and I was wondering (hoping really) that someone would have looked into it and found it to be improved. I'd appreciate any info on it you've found... Thanks in advance Fergus

I've created a new FM database and imported data via ODBC from a MySQL database, which worked great. Then I used ScriptMaker to Execute SQL and pasted the same query from the import into the script. Here's the problem: the SQL query seems to execute, but no new records are created in FM even though I know there are new records in the MySQL database. How do I go about actually importing the data that the SQL query retrieves? And how do I ensure that I don't get duplicate records? Thanks in advance, Robert Jones

Hello Im currently trying to set up a mail merge to microsoft word from a filemaker database. The problem Im having is that I need to specify specific data like all the jobs done by the sales rep Adrian. I have tried to run the query so that it will merge all the jobs done by adrian and merge all the fields into the word doc. But when I change the query and click on return data it wont let me merge. Any advice is appriciated Thanks Chris

Hi guys, Help me out please - this might be simple, might not! Here it is... 1. I don't want to publish my database on the web 2. I do want to add records over the web so can I create a page on my website which has 10 basic fields with a SUBMIT button (much like booking an airline ticket) which will be saved in my personal web space. Then, write a script in Filemaker (when opened) to check my webspace for new records and import them? I don't need it to check availability or anything, it's just blind data entry into a new record! It's for an on-site engineer who will write up a report which then eventually goes into the 'On-site Login' d…

We have a Java based front end application (written in weblogic) accessing several FP5 files of a large 26 file Filemaker solution. We are experiencing three problems. 1) Get many Error code [3] Unavailable Command 2) Get many Error code [803] Host cannot be found 3) Corruption of the JDBC accessed FP5 file and closing all the FP5 files but NOT Filemaker The Filemaker solution continues to work flawlessly using the local Filemaker client interface. The customer is who accesses the data via the web application. (mentioned above) According to Filemaker Inc. we have the latest JDBC driver We are using: Filemaker Server 5.5 Filemaker Unlim…

Any body knows ihe posibility of inserting a picture (small jpeg) from the FM database (5.5 for PC) into a SQL v7.0 table ? Is there a way or simply impossible? Thanks Ernest

Anybody knows about an ODBC driver for MAS 200 that works with Filemaker? Please let me know i have not been able to find one. Thank you, David

Hi there. Some time ago I set up a one-way sync process for a client using Filemaker 5 and myODBC 2.5 to query and import data from a mySQL database. That works fine. Now the client would like to have Filemaker insert/update the mySQL database. I wanted to pick this forum's brains and see if anyone else has had to set up this particular configuration, and what your requirements were. FM6? upgraded myODBC? I guess I'm interested in answers to the following questions: 1. is modifying a mySQL db from FM feasible? 2. if so, what's the best configuration in terms of ODBC drivers, etc if not what I currently have? Colin

Hi, I am working on a solution to pull data out of our oracle database into FM v5.5. Pulling the data out of oracle isn't a problem, but I am not sure how to make the query I want dynamic. Here is a cut down version of the query: SELECT "ORDERS"."TRAN_ID" FROM "ORDERS" WHERE "ORDERS"."TRAN_ID" = '2118570' ORDER BY "ORDERS"."TRAN_ID" Instead of hardcoding '2118570' I would like to use a global FM field. It is possible to write something like "WHERE "ORDERS"."TRAN_ID" = "('FileMake file':'FileMaker field')? In summary, I want to query an oracle database from FM using a FM field as the variable. Is this possible? Thanks.

Hi guys, It is not really a Filemaker issue but I can't run applets in Netscape 4.7x of Mac OS 9.0 I have Internet Explorer 5.0 installed in the same machine and it runs all applets fine, but netscape do not seem to run it. I have installed MRJ but still no luck. Anyone know what to do? Many thanks in advance, simon

Hi, We want to develop a JAVA application that pulls some data from our Filemaker databases. We were under the impression that Filemaker 6 now allows direct access to the DB via ODBC and JDBC. However, a first try of the ODBC interface results in about 1 minute per record returned from a simple SELECT statement!!! We also cannot find any info about JDBC. The people at Filemaker themselves don't seem to know anything about this either, some saying it should be possible, others that it would not. However, the web site (http://www.filemaker.com/products/fmd_features5.html) clearly states: "Use the Filemaker JDBC driver to create Java applications and applets that are fro…

I'm using FMPro JDBC to communicate between my Filemaker databases and my Java program. I am trying to INSERT into the database, and some of my strings have single quotes in them. I wrote a method to change all single quotes in any string to two single quotes, which is suposed to be interpreted as an embedded single quote, rather than as the quote ending the string. This worked fine when I used the jdbc-odbc driver from Sun. However, now I can't get it to work. I get the following error message: java.sql.SQLException: [5] Invalid Command - INSERT INTO "ProblemLists1.fp5" ("UniqueID", "ListPosition", "Type", "Name", "CoreName", "LabTestName", "TestSetting", "N…

Hi All !! Need some help. We have a few databases published using Instant web publishing as well as a few using Custom web publishing. We are considering moving us to JSP (java server pages) There is an article published by Filemaker about creating java server pages with filemaker pro 5 unlimited and Macromedia dreamweaver ultradev 4 . Before we go out and spend $900 on the jrun from macromedia I was hoping to get some input as to wheather this is the way to go or not. We use dreamweaver for development of our website and are looking to intagrate the two. Any feedback would be great Thanks Stu