External Data Sources

I tried to access data from our company's FM database using a java program (using odbc-jdbc bridge).Before that, I had already set up the FM Data Source in Control Panel. The java program has a sql statement 'SELECT ....' written inside it.When I ran the program,this statement is sent to the FM database to retrieve the data.My problem is, sometimes it works and sometimes it doesn't. When it doesn't, the FM ODBC driver returns error statement 'error unknown' and then my FM database crashed.Anybody know what's going on here? For your info, I'm doing this on NT platform.Thanks for any help.

HI where I can find some good documentation regarding FileMaker and ODBC? Thanx

When I try to create a DSN for FMPro 5 under ODBC for Windows 2000 Pro, I get an error 126 message. Any ideas why?

I tested the java api of FMP5 but the jdbc driver doesn't work. Even if I use an exemple taken in the documentation, or if I try to use the driver in one of my web application, I always get this error: [973] Invalid Database Someone have some hint on this?

Hello, What are the steps that i have to do to connect Microsoft Excel to FileMaker??? I want to insert a simple query into Excel and it brings to me the data from my FileMaker database. Thanks.

I am trying to get the ODBC driver for filemaker working, so that i can use php to write the web part of the databases. the first think i would like to know is if anyone has setup a php page that uses filemaker. and if you have please email me .. [email protected] and second where can i get this remote data access companion? i dont have it in my plugins menu. please help me.

My MySQL and FM tactics still have to be a bit refined and so does my understanding of FMs ODBC support, but is it possible to have the "Customer" or end-user submit an order via PHP, which then stored the order in a MySQL database? Then, could the "sales department" use a FM Dev program to connect to the MySQL database to read the order? [ June 23, 2001: Message edited by: n3063n ]

Are there someone who know how to work with Forte ( Sun ) with Filemaker (jdbc) ?

I'm not sure if i'm doing something wrong, but it appears that when i do SQL-exportRows, "myExp.tab" the file myExp.tab gets put into the wrong folder seemingly at random. The plugin documentation says that the file should be placed in the filemaker folder. i assume this is the folder that holds the table that executes the SQL query. This works most of the time, but sometimes myExp.tab gets put in the folder of another table running at the same time. The only way i have around this is to close the table and open it again. I was wondering if anyone else had the same problem, and if there was an easy way to overcome it. thanks, Ati, Jedi Master

Hi, I want to install the FileMaker ODBC Driver on one machine so that it can point to another machine on the network which runs the FileMaker database. I cannot find where to download these drivers at all. I want to export the data from the fileMaker database so that I can import it into SQL Server. I seem to think that you have to install FileMaker to get the drivers? Is this right!?

Has anyone out there had any experience using a filemaker client accessing a Lotus domino server using OBDC?

I'm new to FM, and i would like to export some FP5 files to another database. I correctly connect to the FM ODBC driver. THE PROBLEM IS : BECAUSE I do not know the table name generated by FM (i only know the fp5 file name where i save the table), i cannot call "SELECT, INSERT, ..." SQL statements through ODBC. How can i know the table name in FM 5 ? Thank you

I am currently investigating whther to purchase FM Developer or to go some other route. I am mainly interested in its ODBC, JDBC, and possibly XML capabilities to access the database from the web, minimizing direct interface with FM itself and using the self-created interface. I currently own FM Pro 5.0 and in its documentation it only supports the following SQL commands: SELECT, FROM, WHERE, GROUP BY, HAVING, UNION, ORDER BY, and FOR UPDATE OF. Namely, it does not support JOIN. Is FM Developer any different? I know Developer comes with Pro 5.0, but has FM extended its functionality through ODBC in the Developer package? Also, the online documentation of JDBC for De…

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed /login/logon.asp, line 23 An Access database connects no problems (the scripting works i know under FMprv5...but i cant get the product to see the DB as you can see above). I've installed the product (on Win2000 Server), chosen TCP/IP. What else do I need to do? A tutorial or workthrough or any help really would be apreciated. Rob

I'm having trouble showing XML-data in Internet Explorer 5.0 on my Mac. Any suggestions or do I have to use another browser. Thanks.

So how di we do It? We use IIS5 and 2-filemaker Unlimited raic machines sharing same database to ODBC-connections.

Hi all, I hope somebody can help me and can end my suffering for days. I have Mac and PC, and FileMaker 4.1 and 5. The task is to connect an Access database in a *remote computer* and import records to Filemaker file . I have DNS address like (something.qqq.edu) and IP address of the computer with username and password. I have tried Mac with Filemaker 5 and no success. My File DSN configuration always crash ODBC control panel. With PC Filemaker 5, I cannot connect the Access database and import . However, if I did ftp xxx.mdb file to my computer I can (seems to be) import. But I did it with Access driver in PC ODBC control panel Although 148kb Access file came up em…

Our company is pretty expert in the deployment of databases integrated with Flash. Our architecture of choice is to use ASP as middleware, connected by ODBC to the database. To keep server side processing to a minimum we use the ASP/SQL simply to interrogate/update the database - scripting is kept client side (using Flash Action Script). Our client has a content managment system and website developed by us, and now wishes to incorporate elements from their in house database, developed using FM. We would ideally like to retain the above architecture, but the good people at filemaker seem uncertain as to how well their ODBC driver would perform with ASP, and we can't fi…

Hi, can FileMaker Pro 5 Unlimited 1. GENERATE XML 2. support HTTPS thanks

I've made the download of the FileMaker 5.5 Trial, and I have same doubts about the ODBC connectivity. I have a FikeMaker database that its data have to be inserted in realtime on a Oracle database. I created the DNS and it connects very well, but how can i update my Oracle database at the same time that i'm updating records on Filemaker???....I used the Execute SQL script step but how can associate in my SQL text the FileMaker fields values with the Oracle fields. Thanks

Hello, Alright, I am scripting with perl and using filemakers ODBC driver which I am disappointed that it only supports 4 ODBC statements. Anyway, with Access I specify a location of the database and connect well with FM it isn't like that at all. I have sharing enabled, the database is open. Yet, the perl DBI can connect to it but cannot prepare the sql statement. Please help if you can. Thank You, -Brett

I'm looking for an ODBC driver for FileMaker 5 (Macintosh) to connect to an ORACLE RdB database server on an Alpha station. Note that it's Oracle "RdB" which is another RDBMS bought by ORACLE and not the "normal" Oracle database system. Couldn't find any information on the web. Does anyone know about such a driver?

i want to publish my fmp database in the internet, i would like to use ASP (server side) to access the databse which use to ODBC driver to accompish thet task. I have installed succesfuly the ODBC driver on the server, and i have declared the source name, everything is Ok. I open my fmp database, and enable sharing via LDAC, but when i try to access the database from a remote computer, it's fail. Have i to install the RDAC, if yes where can i find it ? Have anyone tried to connect FMP database trough ASP ? Thanks for your help ?

I am trying to print information from a FMP 5.0 database using Crystal Reports. I have a couple of fields that have more than 255 characters in them and they are being truncated. Crystal Reports should interpret fields of this size as a memo datatype and not truncate them, which would be fine. I talked to Crystal and they said that it is most likely the driver not doing its job properly. Does anyone have a workaround or a fix for this other than chopping the contents of my fields into little pieces?

In other products [Access, Paradox, InterBase etc.] all tables are grouped together in 'one' database. When you access these through ODBC you basically have access to all tables. How is this done in FM to have the same effect. Regards. Hans

Hi, I'm trying to connect 2 filemaker Pro files within Crystal Reports. The wizard in Crystal works fine with ODBC, but when the program must refresh the data it give a fault. Printing one table in Crystal works fine. Is there someone who has the same problem and maybe has a solution. Thanks , Diederd Loysch

Hi , Is there anyone working on filemaker with JDBC.I mean accessing a filemaker database from java.I have Filemaker Unlimited.I want to access unlimited database from java.What soud i do, i know i have to use Filemaker JDBC Driver.But where to get that, I checked for all drivers in the control pannel but JDBC driver was not there. Is it possible to use UNlimited and JDBC.If so can anybody help me by giving some information on where to find JDBC driver and A snippet of coding. Thanx in advance sree

Has anyone been able to use the FileMaker JDBC driver with any available JDK 1.3? I've tried those from Sun, IBM, and the Blackdown group without success.

Hi ! I would like to know wich command i have to type in MySql to acces via odbc a Fm Database who share with LDAC ? Thanks

I need to build a royalty free cross-platform runtime CD-ROM. I want to use Flash5 for the front-end design and hook this up to a FM database using XML to exchange data and queries. Firstly, is this possible? and if it is which version of Filemaker do I need to develop with? Note the CD will be distributed to many users and needs to be a runtime stand-alone solution with no licensing costs for end users, i.e. I want to pay for 2 FM Developer licences for Mac and Windows. The plan is to migrate the CD product to the web hence the use of XML and Flash.

Am trying to setup access to a filemaker database via ODBC. Found some notes on the Filemaker website about configuring it. So, the LDAC plugin is enabled, the Database is shared Multi-User via LDAC. The notes sat to create a UserDSN using the Filemaker Driver. The Filemaker ODBC Driver I have is 3.11. It prompts me for the DSN Name (should this be the same as the Filemaker database?), a Description (anything I want, right?) and a Server (I've set it to localhost). If I run a MS-Query against it, it fails saying it cannot retreive a list of Tables. Bloody thing! Any help appreciated.

Does anybody know where I can get instructions for setting up Ultradev to work with filemaker. Can I use the ODBC driver or do I need to have JDBC driver and if so, where can I get it from? Cheers

Hallo everyone. Did anybody has deeper experience with the XML-interface of FM5? We have the impression that the implementation of Filemaker XML is not pure XML... when requesting data that have ..."links"... to media like jpeg-images the xml-output isn't "well formed" (in XML meaning) any more because of the use of the "&" which doesn't have any adequate dtd description. so our industry standard xml parser (apache-xerces (a former ibm alphaworks product)) refuse to accept this xml. we did hell of a job to "pre-parse" the FM-xml to make it well-formed. so my question: did we this ugly preparsing because we didn't recognize a special FM feature or is FM realy n…

I am looking at switching over to FM5 and am taking a look at all of the information regarding XML. Along with that comes questions. Does someone make a tips and tricks database on how to build database driven web pages similar to the web tools.FP3 database that comes with FM4.x? Thanks.

Has anyone got any inform on how FMPro can be used to Import XML data?

FMP Import Experts, I am using ODBC and SQL to UPDATE a FMP file and I can't seem to find out how to format a time field type to make FMP's ODBC driver happy. I tried single quotes '12:00:00' and it didn't like that. I then tried the curly brackets (where did that little beauty come from? I have never heard of that in SQL before!) that made the time look like {12:00:00}, but this just caused an error that the data didn't appear to be a date (duh, that's because it is a time). The errors I get are below. Is it possible to update a time value using SQL and ODBC? If so, how to I let the ODBC engine know that I am sending a time value? Am I supposed to convert it to a…

Hello? Am I all alone here? Maybe if I post enough questions and answer some (most?) of them myself maybe I can be the moderator of this forum (probably not). If I export (a subset of) records from an existing fp5 file, for some reason ODBC doesn't recognize the new fp5 file as a table. Why is that? If I create a copy of the fp5 file, ODBC recognizes it (the copy) fine. What's the difference between exporting to a fp5 file and creating a copy? Doesn't exporting create a table if it is exported to a fp5 file? It sure looks like a table... Is anyone out there using ODBC? Michael [This message has been edited by mikihasa (edited March 12, 2001).]

Has anyone had any success getting text out of a Quark 4 document into FMP 5 ?? I found a program called Xcatalog from EM software that's supposed to add ODBC support to Quark so that it can interact with FMP, but I haven't ahd any success in getting it to work.

Our Dedicated Web server being hosted uses FM unlimited. In house we use FM Server. Is there a way to have the data entered into Fm unlimited auto updated into our in house FM server? ODBC or how? The database we use for the web is a datafiled only and all interface screens with exact field names are used in house. So its a matter of the 2 updating each other with new data.

Hi, I'm working on a project where the aim is to access a FM Unlimited 5 database from a java application. From what i understand, i'd need the jdbc drivers for that. DOes anyone know where I can get it? I read that it can also be found in the FM Developper 5. Does it mean i'd have to purchase it just to get the drivers (java classes)? Thanks for any help or advice, Damien

We have a department on campus that has determined to stay with FM on their Macs, even though the campus is moving to SQLServer. I'm currently evaluating FM 5 Pro for ODBC connectivity. On the PC, I have no problem connecting to a SQLServer DB, but the FileMaker website says that there is no ODBC driver for the Mac for SQLServer. Is there a way to get a Mac running FM 5 Pro to connect to a SQLServer DB? Do any other flavors of FM 5 do this? Thanks in advance. Tony Dunn ------------------ Technology and Learning Program CSU, Chico, CA

We are making a user interface in Macromedia's Director and we want to exchance data from a FM database. This has to be able to work as a multimedia CD-ROM. Is this possible with XML or ODBC or is this just for webpublishing?

I just signed up for a web dedicated FM server for our web site. We have FM server in house and I have another machine for ODBC. I am using FM 5 for all. Here is my question: Can I mirror the 2 databases? I would like to use the web databse for just data and use our in house database for all interface and in house data. I am trying to achieve having all online information entered query into our in house database. Can this be done and how hard is it to set up?

We are considering using FileMaker to build a database which needs to import data from an Oracle database. My impression is that JDBC might be the best way to do this. It seems that all the XML support is geared at displaying data already in FM. Is JDBC a good route or are there better ways in FM to import data from other dbs?

I have both 4.1v3 and 5.0v3 and have been working to import data from and Oracle DM. With FMp5 I have no problem, however when I attempt the import with 4.1 I get duplicate fields showing on the right (columns) when I select the table. Each field is listed twice for some reason that I can't determine. Any one have any ideas? also: I am having a problem with ODBC imports from Oracle using FMP4.v3. On 2 different files one field defined as text in the oracle table and as text in FM. Will give be the following errors on each record. [Microsoft][ODBC driver for Oracle]error in row 1 (1) then on OK [ Microsoft][ODBC driver f…

I need to import binary rich text data from a SQL7 DB. FM, on a straight SQL inquiry, displays what's there in hex. Are there commands or plug-ins that will get me past this?

I've been working with a FMPro 5ul, ColdFusion 4.5.1 and Apache Server set-up for a couple months now and I constantly run into FMPro ODBC driver problems. I have found that putting FMPro on a seperate machine from CF and Apache has increased the reliability of the set-up, but the speed is ridiculously slow. I'm working on a LAN behined a firewall so it's not the network connection. Besides anytime I query my Access Datasources the speed is more than pleasing. I'm running on WinNT SPk5. Couple Questions to every/anyone: - Has anyone found a ODBC Driver that works well for FMPro databases besides the one that is packaged with the application? An Update Perhaps? - Does a…

I am trying to make a ODBC connection in the control panel using Filemaker 5.0. Four drivers are mentioned in the ODBC control panel. When I choose one of them, like FMFMP50.DLL Windows produces an error 1157. When doing a search on my whole HDD it turns out that none of the four drivers mentioned in the ODBC control panel: - FDOR814.DLL - FMFMP50.DLL - FDMSSS14.DLL - FDTXT14.DLL cab be found on my whole HDD. Can anybody please help me out on this or just mail me the files? Thanks, Ilham.

I am new to FileMaker and ODBC. I think I should have a FileMaker ODBC driver listed in the Administrative Tools/Data Sources (ODBC)/User DSN tab/control panel, but there is none. I reinstalled, and no luck. I am running WIndows 2000. Am I missing something or just to stupid to figure this out.

Does FM 5 provide for live viewing/editing of an external db? I have a solution that I currently have it performing an import everytime I need to add the new record from the external db source. I would like to be able for FM to be working with the external data at all times.

we have filemaker pro 5, do we need filemaker developer 5 to publish in XML? does filemaker pro 5 have sufficient documentation about XML implementation? thanks.

I have a FM DB with over 6,900 records. The size of the file is over 9MB. I am accessing the DB through an ASP page using the FileMaker ODBC Driver. It is working; however, very slowly. My Server: 2- Pentium III 500MHz 768 MB of Memory SCSI Hard Drive Windows NT 4.x IIS FileMaker Pro 5.0 Unlimited Web Server Connector If I do a simple search, returning only two small text fields with about 63 records it was taking 12 seconds to execute. I found the way to Optimize the DB using the Save As command. However, now the same exact SQL statement (returning two small text fields for about 63 records) is taking about 35 seconds to execute. I thought that opti…

Hello, I've got a database with, among other thing, about 1300 address labels. Now I'd like to export them to MS Word because of a mail merge once a month. The only problem is, that I wonder how to copy nothing but a selection of addresses to Word. I don't need to send all 1300 contact a letter every month. I don't want to do it the other way around because I don't know how to keep the Word layout intact when I export it to Filemaker. thanks in advance, Martijn.

hi! currently i

I want to make a connection from Dreamweaver UltraDev to FM5. Macromedia says that there is no mac only solution. There must be a way. Any ideas?

I'm trying to migrate PHP + FMP5 because I had problems to acess FMP5 using CDML tags and FM support don't support me... Well, to access FileMaker 5.0 using PHP I've to install the ODBC drive, correct? The Data Access Companion is a plugin that share FMP data to ODBC... To browse FMP records I've to connect to ODBC, that will connect to FMP5 via Data Access that will return to browser... Exist a limit of users? I've to do anything after change records in my database?

I am using FM PRO 5.0. I have tried accessing a FM5.0 file using ODBC and EXCEL, ACCESS and another ODBC compliant application. All attempts have failed. I have set up the ODBC data source and am able to select it. I have enabled LDAP in the FM file and opened and minized the file. In all cases I see the field names in the FM file but I cannot retrieve any data! ACCESS seems to start importing the data then throws off an error message saying that one particular field is an invalid format. This field is the same number format as dozens of other fields that come before it! Excel will just chug away for a couple of minutes and never return any data. A third ap…

I'm trying out ODBC for the first time? When I read the Help about "Enabling the Data Access Companions" it tells me this: "1 Choose Edit menu > Preferences > Application. 2 Select the Plug-Ins tab. 3 Enable the Data Access Companion options and click Done." But when I try to do this, the only option available is "Web Companion". I've tried re-installing, but this is still the only option I get. Help.

Does anyone know of a way to import or data into FileMaker Pro 5 from an XML source? When I asked Technical Support, they said there wasn't an option to do this, but I find it hard to believe that there isn't some way to make it a two-way exchange of data. Thanks in advance. Paul

I can connect to Oracle8 and retrieve records into FM5. But I would like to be able to retrieve only one row from the Oracle database based on the current field in the current record in FileMaker. How do I specify the current FM-field in the Oracle-Select Where-clause? I have tried the usuall "... where name = :FM_NAME" but no luck. THANKS

I am trying to request an XML data set with an XSL stylesheet tag using the web companion. If I leave off the -stylehref=stylesheet.xsl tag I get the XML data returned fine... if I include the tag FMP locks up. If I manually insert the stylesheet reference into the returned XML, I get my properly formatted output, so I know that the stylesheet is well-formed and works. Has anyone gotten a stylesheet to automatically load with their XML call? Any things to suggest I try? [This message has been edited by tpoint (edited November 13, 2000).]

First post to this Forum. Does anyone know if I can query and ORACLE 7 table using FM5 on WindowsNT? The FM5 product description says it can query ORACLE 8 tables.

I have a client that has a FM 3.0 database and I want to access some of this data via ODBC, is there anyway to do this besides upgrading to 5.0?

I'm hitting a Mac running FMPro5. I'm hitting the data from Crystal Reports and MSSQL without a hitch. The problem is the ODBC connection kicks off the summary fields in the FMPro. The dialog box comes up and it recalculates all the summary fields for every record! One database, with 9000+ records and 10 summary fields, will spend hours downloading data and winds up crashing FM before the data can be transfered. Has anyone else experienced this?? Another database with no summary fields and 43,000 records download in minutes!! I'm going to create a script that will create a new database and just copy the NON-summary fields into it.... That's a pretty clucky solut…

Bonjour, j'ai une base file maker on-line avec XML. Je fait une recherche et le r

Has anybody been able to use the FileMaker JDBC driver with JDK 1.3? I've tried it with IBM's and Sun's JDK 1.3 on two different platforms without success.

I have access to a SQL 7 server, that hosts a database on our network. I have a database setup in FileMaker Pro to import the data into, but when I select 'Import Records...' from the File Menu, ODBC is not listed. I have the ODBC SQL data source configured and can access the SQL database with no problems via ODBC via MS Access 2000. I am running Windows 2000 Pro on this workstation. FileMaker Pro 5.0v3 is running on my local workstation.

Any experience with setting up FM to Universe Database running on an Unix box (AIX) using ODBC

Does anyone have a working solution for extracting info from SQL 7 to FM 5. I have found a driver for FM but I need a driver that can handle SQL 7 for the system. Anyone? ------------------ Jumbo

I just called the pre-sales tech support at Filemaker Inc and the rep I talked to told me that the ODBC in FMP 5 is "level 1" only, which disallow live connection and only allows import/export operations. I have a lot of ASP applications and a lot of SQl Server 7 databases. We have some Filemaker databases and tools and I would like to avoid re-inventing the wheel by redeveloping those databases and interfaces. Is there any way I can just get record sets from Filemaker via ODBC at all? Thanks a lot!

Hello, I'm brazilian and sorry if may English is bad... Does it possible import pictures to FMP using XML or other language? If Yes, how can do it? Thanks

I ran through the ODBC example from the "Users Guide". No problem. I wish to import data from Oracle 7. I get "Data source name not found and no default driver specified". Is there an example or tutorial that will step me through configuring the Oracle driver? jf

1. I defined an ODBC data source 2. I imported data base on a status field meeting certain criteria. What I would like to do now is update the data source and change the status field to show that the records have been imported into FMP. I don't see what use ODBC connectivity for FMP is with out this function. Could someone help? Thanks G

When I install FMP5 I get nothing but the stupid "ODBC Example" folder. Where do I get the drivers and control-panel etc. I am stumped. G

We are building a web based application using ASP that uses a Com component developed in VB to access data from Filemaker pro5.0 database. We are getting an error message 'Request properties are not supported by this ODBC driver. This is happening when you try to query the same record (or same database table) more than once in a session (in different pages). What we feel is the record being accessed is being locked by the driver for sometime and hence this conflict is occuring. We need a solution for this. Requirements is Multiple users should be able to access the same record at a time from filemaker using a vb com component in ASP pages. Thanks in advance madhavi…

I'm trying to get FileMaker pro 5 on mac os 9 and OpenBase on mac os x working together. Both companies documentation is very poor on this subject. Is there anyone who has either tried or gotten this setup working? Or could point me to better resources and information concerning this. Thanks -Lee Sr. DBA/Developer

I'm not sure where this question will fit, so I'm posting in more than one forum... My office is attempting to view records live through an application called CONNX created in Visual Basic. It's information is pulled through an MS Access database. My question: Is there any way using the new ODBC drivers (or any third party drivers) to view the records live and refresh them in FileMaker without having to do an import? Any and all help or suggestions would be greatly appreciated. Thanks in advance. Lora Ramsey [email protected]

Is there any ODBC driver for Filemaker Pro 4? Thanks a lot!

I want to take information from estimates generated by our sales staff in microsoft work and use it to compile forecasting information. First problem is I can't seem to install "remote data access companion". I write this at the risk of seeming stupid - which I probably am. Looking forward to someone proving me right !

I am trying OBDC imports. I have created a small Excel 97 workbbook with 3 fields and 3 records(rows). I have configured OBDC Excel driver with pointer to this file on my Deskto. My plug-in for local (same computer access) is checked on. When I try to import into a FMP5 database I cannot see the "table" (my Excel file) in the query screen. I access the screen thru File pen and select OBDC files. Without seeing a table I cannot create a query. Any idea where I could be going wrong. Thank you.

is it possible to edit a record in FMP using ODBC? i have a db on a mac. i can connect to it from VB5 on a pc. i can read the data. i can create a new record. i can do this by using db.execute "insert into...." or by using a recordset.addnew command. i opened the db for read/write and the recordset as a dynaset which should allow read/write. when i try to edit a record either through db.execute "update...." or by recordset.edit i get a message that "query is not updatable". i have been to xsf site and downloaded their white paper on FMP, ODBC and MS Office. they only read from FMP. they don't attempt to write to the db at all. so, can this be done? does the FMP ODB…

i'll try asking this again in a different way. is it possible to edit a record in FMP using ODBC? i have a db on a mac. i can connect to it from VB5 on a pc. i can read the data. i can create a new record. i can do this by using db.execute "insert into...." or by using a recordset.addnew command. i opened the db for read/write and the recordset as a dynaset which should allow read/write. when i try to edit a record either through db.execute "update...." or by recordset.edit i get a message that "query is not updatable". i have been to xsf site and downloaded their white paper on FMP, ODBC and MS Office. they only read from FMP. they don't attempt to write to the db at…

I am importing data via OBDC from an SQL server. I am getting errors in interpetation of numeric values when importing exponential numbers. It is interpeting as example 7.10000000000000E-15 as 7.1. It is essentailly ignoring the exponential notation. Any ideas how I can correct this problem??

I have a FMP db on a mac volume on an NT 4.0 server. Am trying to connect to it from VB 5.0. (yeah, I know 6.0 is better, tell my boss). This is the code I'm using ConnectMast= "ODBC;DSN=SemDB;database=S:MacSpaceSem Central DBStudent_Info" Set MyWs1 = Workspaces(0) Set StdntDB = MyWs1.OpenDatabase("", dbDriverNoPrompt, False, ConnectMast) selstmt = "select * from Student_Info" Set StdntRS = StdntDB.OpenRecordset(selstmt) StdntRS.MoveLast StdntRS.MoveFirst The errors come on the 'Set StdntRS=...' line. I get three errors. a -151 'connect failed' then a 0 'error has occurred while trying to gather a list of available tables' and finally the basic 3146 'odbc f…

Whenever I try to create a ODBC datasource (System DSN or User DSN) with the FMPro 5.0 ODBC driver as it is installed I always get an ODBC error 126, the error translates to english as "The subroutines to configure a datasource could not be loaded due to a system error 126". Any ideas?

I am just starting a project for a local private school. They currently have 5 different departments using 5 different dbs. Keeping all the different dbs up to date is driving them crazy. Most are on pc but 1 is a mac app, not in FM. They want a new db for the teachers to use to enter comments etc. Teachers use macs. My plan is to create a 'central' db to accomodate the teachers needs and also act as a clearing house for data. This would be in FM. The idea being that someone enters data in their db. The changed record gets picked up and changes made to the central db and then from there to the others. I know I should be able to read the data in the FM db through odbc usin…

Hi, I need to get my client appln in JAVA to interact with my database in FileMaker.Going through the documentation I realise I would need the Local data Access Companion plugin?? Could someone please help me with this.I am not sure whether I am correct in using this plugin and also I cannot find a downloadablr verison of this plugin anywhere. Can someone please tell me how to make my database interact with my client appln.

Hi, I need to get my client appln in JAVA to interact with my database in FileMaker.Going through the documentation I realise I would need the Local data Access Companion plugin?? Could someone please help me with this.I am not sure whether I am correct in using this plugin and also I cannot find a downloadablr verison of this plugin anywhere. Can someone please tell me how to make my database interact with my client appln.

HI, Does anybody know where I can find more information about JDBC in FIleMaker Pro, like a tutorial or something? Because I want to import data from Oracle and it seem that I can't do what I want with ODBC, but maybe I can do it with JDBC, but I don't know how java work. I know C++, applescript and some other, I've dowloaded the "Java 2 SDK, Enterprise Edition" and the "Java Development Kit, JDK 1.1.8 Software" without good result. I've read "Using ODBC with FileMaker Pro" in the User's Guide of FileMaker Pro 5 and "Using Java and JDBC to deliver your data" in the Developer's Guide of FileMaker Pro 5. Thanks. Maxime Paquette Scripto Centris Inc.

Hi, I'm trying to import data from an ODBC data source (Oracle8) to my FileMaker Pro database. The problem, is that my query in the query builder need to be based on a field in my FMP db and I want to do a script with all that so that I can do it automaticaly. It seem that I can't make a reference to the field in the query builder of FMP so I have to always change the value of the WHERE statement manualy. Here's an example of want I do: SELECT fisrt_name, last_name FROM my_table WHERE id = 12345; but what I want is: SELECT fisrt_name, last_name FROM my_table WHERE id = my_filemaker_bd.id; where "my_filemaker_bd.id" is a field in FileMaker that always change and …

Hello, I have a problem with my development : I develop a intern WEB Site in ASP for a company that use a FileMaker Database. I have setting up a System DSN on the server, the database is open on my computer. I have no problem when I use a SQL query like SELECT * FROM DB WHERE Fieldx = 'toto' The problem is when i do the following query : SELECT * FROM DB WHERE Fieldx LIKE '%toto%' I receveid a timeout and my computer is 100% occuped by the Filemaker Pro 5 process for 1 or 2 minutes. Can someone help me ?

We have been designing parsers for the XML that shoots out of FMPro. Any interest, reply.