External Data Sources

I have a FM 5.5 db that has a script that queries an ODBC datasource via a SQL statement that imports data. Works great - and everyone is very happy. However, when I save the db with Developer 5 everything works except the import script. I get the following error when I run the script: "The translator for this file format could not be found". Are the rules for SQL statements interpreted differently in Developer than in regular FM? Also, note that the script in quesiton runs sub-scripts. Is this not allowed in a Developer db? Any and all help massively appreciated!! Thanks in advance, Modemmute

An application in php is executing a SELECT query over ODBC on my Filemaker DB. This happens from a separate machine on my LAN. When the query is actually executed, my filemaker screen on my host machine jumps to another record, being the (first) one in the result requested by ODBC. However the external application doesn't perform any updates or writes to the file, it just reads information. I've searched the ODBC forum but did not find anything alike. Any suggestions?

The Carriage Return/Line Feed character that may be embedded in a field by the user, or as a FM text calculation are not represented "as intended" when FM data is "pushed" to a SQL server. In examining the "pushed" data using Ms Access, all the original CR/LFs are represented by "boxes", and no CR/LF actually occurs, so the text is a continuous string. This occurs whether developed on Macs or Windows and whether the client is on a Mac or Windows box. Does the solution to this problem lie entirely on the SQL side? In other words, does the IT guy the runs the SQL server have to invent his own parser/translater in order to represent the data correctly to their users? …

I have been trying in vain for days, to find an explanation for the following, can aynone help please!!!! I go to the ODBC Data Sources (either WindowsXP or WindowsME), add the Filemaker Oracle8 Driver and under the general tab add the Datasource name etc. When I click 'Test Connection', or go into Filemaker and Import using ODBC, I get the message 'specified driver could not be loaded due to system error (126 on XP, 1157 on ME). I have contacted FM, but they don't have a clue. I thought that easy access to other data sources using FM was supposed to be a breaze! I am using FMv6, I have also tried it using FMv5.5, but with same results. Any help would…

i am trying to move some information from a filemaker database to an SQL database. i am trying to accomplish this by using the ExecuteSQL script. It works fine for fields that are text or numbers, but i am having trouble making the move for container fields. specifically, i am trying to move an image from a field named "thumbnail" any suggestions? anybody done this?

I have a solution that requires 6 queries to get all the information I need from an ODBC server. I am using a prefs file to store the queries and a set field script step to add a global in the middle as a variable. If I run them 1 at a time (1 query per script) they work fine. If I use 1 main script and call them as subscripts 1 after another they skip the import step. Any ideas?

hello all. a while back i looked into using a scripting language such as PHP or ASP to connect to a filemaker database. however, at the time i was told by many people that filemaker wasn't "trully ODBC compliant" and that going ODBC was a mistake or a "waste of time." i am wondering if this has changed with Filemaker 6.0. also, with the new SQL features, is it possible to execute SQL statements on a filemaker database, or only the other way around? thanks for your help, tim.

I need to use filemaker as the database and another application as frontend and I would like to use ODBC to connect this frontend application to filemaker. Is it possible ? Where can I get FileMaker ODBC Driver ? Luiza

Can anyone tell me how the XML output is beefed up in v6? I specifically want to know if output from a portal can be formatted differently or if xslt transformations can be applied in FM. (Currently I can't get our XML output from several FM portals to work in our Mac environment because I cannot transform the column-like xml portal output back into a row-like format that the portal should be viewed as .) So can FM do xslt transforms, or has any good new xslt parsers for InternetExplorer for Mac popped up? Does the new ie5.21 parse xml/xslt better? Thanks Chris

I can get Access to link to some FM databases, however, with one of the connection attempts I get the following message: The owner "filename" was larger than SQL_MAX_OWNER_NAME_LEN from SQLGetInfo(0).(#0) Has anyone seen this message before and has a solution? Any help would be appreciated. Thanks.

Hi, I don't know much about XML, just trying to figure out whether or not I should be learning it. My question is basically this: In order to serve FMP data as XML to allow client side sorting, searching, etc... Do I have to use XSL Transformations server side to output HTML files for compatibility purposes? I'm serving general data to the web ... retail application so compatibility is of paramount importance. I'd like to be at least V.4 browser compatible and up. Also, If I do have to do it that way, why not just serve using Lasso, the load on the server isn't really reduced if I have to parse XML using XSLT on the s…

All I want to do is to get an Excel spreadsheet to update from a FM 5.5 file via ODBC. I have found a few places on the web describing the process in Mac Classic, but nothing about OS X. For example, is there an equivalent of the ODBC control panel in OS X, or is ODBC hosting one of the features currently crippled in OS X? Any help greatly appreciated.

hi! i am a newbie and as a newbie i need help:-) i am trying to developing an application under mac osx to handle a database of images. iam working with project builder and interface builder for the part about the graphic user interface...but... i have a big trouble to link my java code to access the database(the code is SQL embedded in java) because filemaker 5.5 has no support for ODBC and JDBC using mac os X. I think Mac OS x has got no support at the moment for ODBC and JDBC so it seems to be a black box for SQL commands.. Sorry if i have said nonsense but iam not so expert;-)) thank u very much Fede

do to some of the limitations of CDML, i'm looking into using another scripting language to process a few of my pages. i've looked at that new Viking solution, trying to get it to work. anything anyone can tell me about ASP and Filemaker or PHP and Filemaker would be extremely helpful. any advice? tim.

Hi! I am developing a VB application that puts data into filemaker. I have encountered a problem that I believe is a FM ODBC driver bug. Hopefully someone else will know about this and be able to provide me with a solution. This is the problem: When I try to install a value into a FM text field, and the value is longer than 255 chars, the string gets chopped off, taking away everything after the first 255 chars. I run filemaker 5, but I have installed the 5.5 ODB drivers since the 5 one was so buggy. In great need of a solution for this! Thanks /Jonas

I have created an ODBC connection to a FM Pro 5.5 database file, but when I do this it is asking for a password every time I open the connection or try to run a query. This application needs to be automated so there will be not user sitting in front of the computer to interact with the application. Is there a way that I can pass this password to the database?

I need a way to read data from a SQL Server Database and then write/update a Filemaker Pro 5.5 database. I have been trying to get VB to work with the FM databases, but it is clear that it doesn't work. Is it possible to write FM scripts that will read an external data source (i.e. the SQL Server database) and perform the updates that way?

I am accessing a SQL server via ODBC and want to store my queries. They need to be text(query info) and a field value which is the search criteria for the sql. I am trying to use a calculation field with a text result but it errors telling me that there is more than 253 characters. This is a shared file running on a server so I cannot use a global field. Is there a limit to the length of text string that can be in a calculation field and if there is where do you store large queries? In a preference file?

Hello All I am looking for a sample (NOT REAL INFO) data file of names. address, phones, etc. To use for a project. If anyone has a file they are willing to send me I would greatly appreciate it. PLEASE SEND TO [email protected] Thank you!

Hello! We use this code on the browser type of page.. It uses browser vbscript. But we allso need server side option for those with older browsers... <HTML> <HEAD><TITLE>Books in Inventory</TITLE></HEAD> <BODY> <H1>Funny Novels Inventory</H1> <SCRIPT LANGUAGE="VBScript"> Dim rows, columns Dim xmldoc Set xmldoc = CreateObject("Microsoft.XMLDOM") REM wait for the document to finish loading before continuing xmldoc.async = false REM validation isn't required; well-formedness isenough xmldoc.validateOnParse = false REM Load the XMl…

I need to insert a large block of records into an ORACLE DB. (Using FM 5.5) Right now, I have a simple calculated field with SQL INSERT command. I loop through the records performing an export SQL command for each record. This works, but it is extremely slow and inelegent (especially when the importing from ORACLE goes so quickly) Is there a better way?

I am having trouble with the simplest beginning to read an xml file from my fmp db. In the head i have <% Dim objxml 'xml initialisation Set objxml = Server.CreateObject("Microsoft.XMLDOM") objxml.async = false objxml.validateOnParse = true objxml.load("http:.../FMPro?-db=dbname.fp5&-format=-dso_xml&-max=1&-findall") If objxml.readyState = 4 And objxml.parseError.errorCode = 0 Then Response.Write "Doc is good" Else .. code to desribe the error End If %> This fails with a message "load and parse failed because No data is available for the requested resource". However, the db is not empty. When I use the url "http:.../FMPro?-db=…

Sorry, I'm a FMP newbie, so this may be a stupid question: FMP ver 5.5. Server ver 5.5 We have a large FMP app that is hosted on FMP server. on a daily bases, I'm importing 200k+ records from my SQL database to 1 FMP file. Since the data in the SQL dbase is constantly updating, I would like to use ODBC to show a portal of that data. All the ODBC examples I've seen so far, only deal with what appears to be desktop files. Since the file is hosted, I can't delete the current data and refresh with the new queried data because another user would lose their information. Due to my newbieness, I'm not sure Globals will work because the data returned could be …

Hi, I could successfully imported data from FM to SQL Server. But I am facing a problem. In my FileMaker Pro Database, I have one field which is a container field & I have inserted object from word Pad in which I have typed Chinese Charater. But while importing with the same structure I have in my FileMaker Pro Database, The field is showing <Binary> instead of any real data. I checked the data type of that particular field in SQL Server, it is Image with length 16. I will be highly obliged if you can tell me how can I import the container field data from FileMaker to MS SQL Server.

Hi, Has anyone tried to access filemaker database through another client application using OBDC connection? If yes, what did you discover? Did you have to set up filemaker database in any special way? Regards, Frank Gonzalez _________________________________ R e @ c t D i g i t a l A r t s _________________________________ 230 Browns Line, Toronto, On, M8W 3T4 t: 416-535-5575 f: 416-535-8093 ________________________________ http://www.reactdigital.com [email protected]

When I am getting XML out of my database layout, the data that comes from a portal is not formatted very usefully. That is, I can get the regular file data just fine, but portal info comes out as each column data, not as 1 row in a record, with each part of data with a label. I get something like this: <myrelationship.column1> <data>10 </data> <data>11 </data> <data>12 </data> </myrelationship.column1> <myrelationship.column2> <data>a </data> <data>b </data> <data>c </data> </myrelationship.column2> How do…

I am writing a Java program that interacts with FMP 5.5 databases and am currently using the jdbc-odbc bridge to connect to the databases. I need more information about the FMP JDBC driver before I purchase FMP Developer, but was told when I called the company that I would have to call the technical service people (on the pay line!) to get the information I was asking for. I

Hey... does anyone out there have suggestions on a product that will quickly transfer data between two similiar FMP databases? The situation we're in is our client would send us a copy of their database to fix/addto/etc, but expect to keep working on their existing copy. When we're finished, they'll send us what their current copy again.. we transfer the data, and send it back. Data Junction probably does something like this efficiently--anyone have experience with this or other suggestions? Thanks, Dane

I purchased FileMaker 5.5 Developer and the CD comes with an XML API and an example implementation called inventory. I loaded it up and got it to work. I can request data and submit it back into the database successfully. However, when you type in more than 400 characters it refuses to submit the data. I also noticed many problems submitting fields using the API when special characters are used (sometimes simple carriage returns don

I have what's probably a simple XML question. When parsed, the following code: <p><u><b><font size="4">Status Verification Form</font></b></u></p> <form method="POST" action="FMPro"> <p>Enter SSN:<br> <input type="text" name="ssn" size="20"></p> <input type="hidden" value="omega.fp5" name="-db"> <input type="hidden" value="WebMain" name="-lay"> <input type="hidden" value="-dso_xml" name="-format"> <input type="hidden" value="text/css" name="-styletype"> <input type="hidden" value="../batc/omega.css" name="-stylehref"> <inpu…

Has anyone here had any experience in connecting FileMaker to MS Project through ODBC? Did it require the use of a plug-in or was FMPs ODBC driver able to handle it?

We use an email program called Gammadyne which reads our FM database. One thing we can't figure out... why do we need to have FM and the database file open before Gammadyne will read from the file? We are thinking it has something to do with the ODBC and its driver? I am a rookie at ODBC and how it works, so here is a little info on how I currently have things setup. - We are using FM 5.5 - FM is listed under the "User DSN" tab in the ODBC Admin (it is NOT listed under the "System DNS" tab) - Listed under the "Drivers" tab we have FM Oracle8Driver, FM Pro, FM SQL Server Driver, and FM Text Driver. Not sure what all the above mean, just hoping someone …

Hi Folks, I'm trying to connect to a Filemeker DB running on a Windoze box using WinRunner via ODBC on another Windoze box. Doing this with Oracle is extremely simple but I have yet to find an example of how to simply connect to a FMP DB via ODBC. The code in WR looks like this: DSN = "casap10"; # my defined FMP DSN UID= "USER"; PWD = "PWD"; query = ("SELECT * FROM TABLE"); rc = db_connect ( "mySession" , "DSN="& DSN &";UID="& UID &";PWD="&PWD ); db_execute_query ( "mySession", query , record_count ); Questions: What should TABLE look like in my query? ("xyz.fmp"?) OR Where is the DB name defined? I have several runni…

Hi all We're developing a java application which is a sort of multimedia database front end. On the Windows side it uses Microsoft Access as the data source, and works fine. On the Mac side, I had hoped to use FMP as the data source, but can't get it to work. I've gone through all the info I could find on it, have the data access stuff on, ODBC control panel, etc, but the thing just won't go. Does anybody know enough about this to fill me in on what I may be missing? I realize this isn't really the right place to ask this question, but I can't think of where else to go. Thanks Stanley

Hi all, What exactly does loop back address 127.0.0.1 mean? Is this a local connection masquarading as remote connection? What is it good for? Thanks

is this possible?? I know that filemaker is odbc compatible, but Im not sure how to do relational database exports and things like that with odbc and vb using filemaker files. My main database is on a one to many relationship with 6 other files, which all in turn have expansion tables. If anyone can help me or point me to some examples of using relational dbases from filemaker in vb, thanks in advance.

I am going round in circles trying to sort out a link between filemaker 5.5 and oracle. The limiting factor is that I have no knowledge of oracle systems . I work in a large institution where a large about of information is kept on an oracle 7.3.3 RDBMS database. I am trying to link either from a mac and PC and the message I receive when trying to import into the data is '[MERANT]{MACINTOSH ODBC Driver manager] Data source name not found and no default driver specified (-1). I am assuming the link to the data source is incorrect in the ODBC control panel. The department who have set this up have given me the I.P. address of the server, the database name and a s…

I am having trouble connecting the ODBC control panel on my mac to a remote nt server hosting ms7 SQL. Currently I have downloaded the Merant ODBC plugin for ms7 SQL ("MERANT SQL Server Driver 3.51") but I am unable to make a successful connection. Help Please

Has anyone ever successfully queried a SQL 7 db using FMP on a mac via ODBC. If so could you please respond with a brief description of the required software, extensions drivers, plugins etc. Thanks, G [ February 27, 2002, 12:29 PM: Message edited by: spragueg ]

Has anyone ever successfully queried a SQL 7 db using FMP on a mac via ODBC. If so could you please respond with a brief description of the required software, extensions drivers, plugins etc. Thanks, G [ February 27, 2002, 11:27 AM: Message edited by: spragueg ]

I've got a VB program that currently opens an ODBC connection to FileMaker and finds a particular record. The program then pulls the feild data out of the database and performs particular functions. I'd like to start using the same program to create new records and change field values. However, the feild values aren't changing when the program runs, even though I can see that the feilds are being accessed line by line. Has anyone else run across a similar issue. Here is the code I'm using to access FM: Set cn = New ADODB.Connection Set rs = New ADODB.Recordset Set cm = New ADODB.Command cn.Open "Provider=MSDASQL.1;Data Source=FMTest;database=myDatabase.fp5 cn…

Hi, I am working on a solution to pull data out of our IMAGE database into FM v5.5. Pulling the data out of IMAGE 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 WOSHT.SHTWO, WOSHT.SHTPN, IM.DESC, WOSHT.SHTQTY, IM.SCODE FROM MANDB.IM IM, MANDB.WOSHT WOSHT WHERE WOSHT.SHTPN = IM.ITNO AND ((WOSHT.SHTWO='123456')) Instead of hardcoding '123456' I would like to use a global FM field. In summary, I want to query an IMAGE database from FM using a FM field as the variable. Is this possible?

How come Filemaker Pro 5.5 Developer doesn't remember if the Remote Data Access Plug in was activated for a database? Each time I reopen the database I manually have to enable the RDAC for each database I open (about 20 databases)..

Is it possible to use an external schema when exporting data from filemaker in xml type. At the moment I use this command 'fmpro?-db=dbase.fp5&-format=-dso_xml_dtd&-find' The data needs to be exported using a certain schema - is this possible? TIA

Hey kids. Do you know of any good books on FileMaker ODBC; I'm an ODBC virgin, so I need the basics. Thanks. Paul

PROBLEM: SQL query using ODBC and ASP We are connecting through ASP to an FM DB over ODBC, no problem: var oRS=Server.CreateObject(“ADODB.Recordset” ; oRS.Open(“myFMDB.fp5, “DSN=myDSNname” ; However, how can you do an SQL Query? This wont work: oRS.Open(“SELECT * FROM myFMDB.fp5”, “DSN=myDSNname” ; Thanks in advance.

I developed a db for a cliet that was using MS Works. They wanted a Filemaker or Access database because they needed it to be multi user, and Works can not be used on a network with more than one person at a time. With Works the database fields can be easily inserted right inside the Works wordprocessor, and they would type numerous letters and do mail merges, and put fields into the text. The word processor had word wrap and was a decent word processor (much better than the Filemaker word processing within the layouts). I put together a database that is far superior as far as database capabilities, but does not make it as easy to do word processing and insert field. Th…

We have about 4000 ms word documents and we want to publish them in a database over an intranet. We've made it as far as we can see a list of the documents but we cannot acces them thrue a webbrowser(explorer5.5) How can we acces these files true a webbrowser? In the end we want a list of files that you can acces. (links) Is this possible? and how?

I'm trying to place various forms from a filemaker database online. We have Filemaker Server 5, Filemaker Pro Unlimited 5.5, and Filemaker developer 5. We want users to be able to login using a separate authentication system, and only get access their their own record in the database. We hoped to accomplish this using Filemaker Pro Unlimited, however after I eveluated the instant web publishing I found the generated html was not suitable. (Did not look good in netscape 4.75, and when accessed with netscape 6.2 it crashed fm pro unlimited) Instead we are going to use script a web application in coldfusion 5. I set up the filemaker ODBC driver as a datasource in coldf…

Does the Use Remote Connection for the ODBC FileMakerPro Driver Setup work thru a firewall?

Hi, I

SDK : FM 5.5 - Windows with 512 MB RAM I have a big fp5 file (10000 kb) and when i use an ODBC program to retrieve the data from FM, FM crashes few minutes later. Is it normal ?

Are there any plans for a ODBC oder JDBC driver for Filemaker Server? You can connect via ODBC to a Filemaker Client, but is there any reason not to support such a driver for the server. This could help a lot to integrate Filemaker databases with other databeses in a company. I am very surprised that FM supports such the client and not ther server.

Is there a mySQL driver for a Mac Client? I have got it for a Windows client (myODBC) and I am looking for a similar ODBC driver for Macintosh. Thanks in advance

Hi there, I must admit I'm new to this ODBC driver in File Maker, and I turn to for help on thisa issue. I would like to be able to move data in and out of File Maker with a client app called "Progeny". That's a program that itseld in turn uses Sybase to draw pedigrees. 1.Since we have FM Server 5.0, I understand I should create DSN on the machine that has Progeny, enable Remote Data Access and point it to the FM Server. That will allow me to get data FROM FM Server into Progeny. Can I also import data from Progeny INTO FM SErver in this fasion? 2. I'm reading that FM Pro is Level 1 complient, but not Level 2. What does this mean in English? Thanks for your hel…

I was wondering if anyone out there has experience connecting to FMP Databases using PHP.

posted November 27, 2001 07:32 AM -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- Hi On W98/PWS this code works fine. On W2k/IIS5 we get the message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed This is the code: var rs=Server.CreateObject('ADODB.recordset'); var cn='DSN=FMDSN'; rs.Open ("Select * from properties.fp5", cn); This is a simple conneciton string. It works on W98/PWS why not on W2K/IIS5? Urgent Solution Required…

Hi, I am interested in using XML with FileMaker, Although I know a little XML I just don't know where to start. Do I need any extra software or hardware etc. If someone could give me some info that they found useful when first using XMl would be great?

I'm using a tool to export from FM to SQL Server. It's work well when the FM's files are on the local network but when i'm using Internet, i'm got problems: I'm opening files in FM like usual via 'host' option (all companions are checked). Then, I'm connection using ODBC and it's still work at this point. It's when I'm opening the recordset object that thinks are not like they should to be. The recordset is always empty (EOF = true)! In fact, I got datas in FM files. And I can see that FM'process still working hard but it's to late, recorset is empty. Someone can help me please, Thank you, Nick

Ok this is what I have to do,I have some tables in MS Access and I want to import them at a particulair time to a File Maker File.Now I have created the ODBC DSN for the MS Access file.When I go to File->Import in FileMaker I don't have a drop down option for ODBC data types in the drop down. How do I go about doing this.I have installed typical during installation.I am using FIle Maker 5 on Win 2000 Platform,the ODBC driver is 3.11,the access driver is 4.0 version Please help. Thank You

I have written a Java program that uses JDBC and in turn ODBC to connect to a Filemaker Pro database. The program works fine with Mac OS 9.0 but it fails with 9.2. When I run a trace I find that the failure is in the ODBC call "SELECT * FROM Contact". There are about 5 pages of ODBC calls before this that work. The other calls get a list of database table fields and their types. We have downloaded the latest patch for our Filemaker Pro which is 5.03. We have tested on multiple Mac OS 9.0 machines and it works on all of them. Are there any known problems with the ODBC driver that comes with the 5.03 update? Is there a later driver? Any help will …

I'm trying to establish an ODBC Data Source in Windows 98 and have been unsuccessful. I can add a FileMaker Pro driver to the ODBC Data Source list, but I don't get an option to select the database that will utilize the source when I add the Data Source. When I add an Access driver to the ODBC Data Source list, I get an option to select a database. I am using the FileMaker Pro 5.5 demo. I'm trying FileMaker before deciding whether or not it will work with what I'm doing. I am using FileMaker in a way that's probably unusual to most FileMaker developers. I'm using a FileMaker database as a content holder for a multimedia project that I'm creating with Macromedia Author…

Where are you looking for it? It is in preferences application. I think it will support runtime.

Hi, 1. I had a problem using SQL Query to FM DB in an ASP Page. I renamed all copies of the DB so that there was only one copy of the DB on the Web server. This seemed to solve the problem. (Because there is no Path to a DB specified in the ODBC setup, it might caused problems if there was multiple copies of the DB on the webserver, albiet if they were in different folders.) Could anyone confirm if this is the case. ie Must there only be one copy of the DB on the Web server and or network? 2.Secondly, are there any issues associated with connecting Multiple Users to an FM DB on an IIS web server. ie I am told the FM ODBC Driver is single threaded, and ASP app…

I have a FileMaker 5.0 application in use by a group. I want to connect to one of the files using ODBC from another server using ColdFusion. However, all attempts to do this give me the error: ODBC Error Code = S1000 (General error) [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed My query looks like so: <CFQUERY DATASOURCE="FileMakerApp" NAME="qResults"> select * from filemakerfile </CFQUERY> Can anyone shed some light on this?

Something isn't quite right. This error generally comes up if the ODBC source is not available, either because the file is not there, or the odbc server is turned off. Like when you try to use FMP files as sources and FMp isn't running. Have you set up the Excel file as an ODBC source? Have you set up the appropriate worksheet? In ny case, you don't need ODBC to import files from excel (unless you want to filter the records) Is this of any help ? -)

Hello, what i have to do to connect my FM database with an Oracle database, which driver i have to use and what i have to configure to it works. Thanks

All I'm looking for is a way to use FileMaker on Macs to enable kids in a Primary School to add their content easily to an intranet site, via a browser, so that what they add becomes available immediately for others browsing or searching the site. I gather there are various ways to do it: Custom Web Publishing with CDML and HTML Web Companion TCP remote access plugin (?) XML - hand coding DreamWeaver Ultradev 4-ODBC connection (am I right in thinking this way won't work?). Is there a method that strikes a compromise between learning curve, time to develop and efficiency? Thanks, John Nichol.

I try to do an import into FM 5.0v1 with ODBC driver from SQL 7.0. When i come to the SQL Query dialog I have a little problem. In the selected database there are several tables with the same name but with different database owner. In FM's Query dialog I get all the tables with the same name but I can't see the owner. An example: Database= Sales Tables: Customer with owner Adm and Customer with owner User This shows in the Query as: Customer Customer To get the Query to function I have to manually edit like this: From: Select Customer.CustomerName To: Select User.Customer.CstomerName or else I get an error. In MS Access the tables show as…

Hi, Is there a way get data from AS/400 into FM without having to export to Excel? Thanks in advance

Hi, I am going to build web pages (using php probably) that will refer to data that is now in a FM db. However, my hosting company serves databases via MySQL. So, I have to export the db but I don't know what format would work. Should I export the db as "text separated by commas"? There is no SQL option. Then, I'll get my hosting company to upload whatever output I create. They don't support FM dbases. Thanks.

I was able to connect and display Filemaker data in VB. Also, I was able to add and delete records. But there is a major problem I'm running into ( of course, I'm sure I'll run into many more as I'm doing something really simple now to see if it can be done before I proceed ).... anyways I'm not able to add/update any text fields all the number fields work fine. Do you know of anything that might help.

Hi! I have a problem with the new jdbc and Java 2, i have an error when i compile, but when i go the my jsp page i have an error, "Exception in thread "main" java.lang.AbstractMethodError". In my jsp page i use a function who called myResultSet.getRow(), i have try my .jsp with jdbc of MySql and all is working good, are there someone who can help me ? Thanks Michael

I am looking for a Web Server software to host my FM database over the net along with my web pages. The requirement is the page the user log on require a login and password. I want to know advantages and fails in using DreamweaverUltradev with FileMaker Pro. Also I need any suggestions about using Lasso Vs. Ultradev. Thank You in advance

I need some help with a sticky and expensive situation. I am trying to ODBC-link some FM 4.0 databases through a remote host connection (TCP/IP) into MS Access 97. This is in order to produce automated Access reports and Excel charts. I have purchased (full price) two versions of FM Pro, 4.1 and 5.5, and $280 later am no closer to the goal. 5.5 won't remote-connect to the databases and the ODBC drivers with 4.1 are import-only and 30-day evaluation at that! The FM Pro 4.0 software used to produce the databases is a volume license covering 20 users over 3 company sites, and they are totally unwilling to: 1) upgrade to FM Pro 5.5, about $2000 and 2) convert the FM Pro datab…

I am reposting this here, as I got no response so far on the security forum. I am working with an organization that is going to put one FM client outside the firewall to talk to their ISPs database. The ISPs database will periodically query the FM client for new records to upload. I have given them a password with browse and export privileges. The problem I see is that in general, the organization has been very lax about passwords. I am thinking it could be possible for someone sniffing around to find the IP address and that there is an ODBC database there. By trying common passwords, they might take over the database. Is this a realistic possiblity? Should we I get …

hi, I've downloaded the JDBC driver for FileMaker. I can't find any documentaiton on the format of the URL. 1) Do you need FileMaker Unlimited to use this driver? the only docs I've found indicate that the JDBC driver makes an HTTP connection to FileMaker Unlimited. I'd like to use the driver to directly open a .fp5 file. Is this possible? 2) What's the format of the URL assuming you can open a .fp5 file directly, what's the format for the URL? thanks, -- James

I have a database that has sensitive information in it and I want to make it password protected. Instead of using the filemaker pro access privledges I would like to tap into our corporate LDAP authentication server for access provledges. I must admit my ignorance here. I'm not sure if LDAP authentication works only from a browser or if it can work with other applications such as Filemaker Pro. I have all of the info for our server but it doesn't look much like ODBC connection info. Anyone got a clue?

When connecting to Filemaker pro 5.0 using ODBC/ADO in visual basic to retrieve data from a field(of type string) in a table, the information that is returned is being truncated to length 255. Is this a bug, if not how can this be prevented?

Hey -- just a short note to alert FM Forums users that ClickWare offers classes on this topic. Thanks! www.clickware.com

Help, I have been trying for weeks to find the magic combinations of field and indexes that will allow me to connect to my filemaker 5 db from Access using odbc. Does anyone have any ideas. I have turned all indexing off (reduced my db size in half btw) but still cannot get it to work. Smaller (in terms of number of fields) databases work fine (albeit a little slow) Any help is appreciated. The odbc support in filemaker is mediocre at best. Thanks.

I am using an iMac as s web server running OS 9.1, Fliemaker Pro 5 and Adobe Golive. I have created a registration form in GoLive which is identical to the form in Filemaker. I have set the ODBC control panel as recommended, set all of the file sharing folders, but I cannot find how to connect the two. Neither manual is helpful and I have been unable to find any help in the user forums for either product. I am looking for suggeations.

I have successfully imported data into filemaker from our sql database on the PC...Now I know there is a way to do this on a mac, but need info on how. I want to be able to do UPDATE statements as well on the mac side.

I'm trying to connect to a mySQL table running on RedHat 7.0 from FMPro 5.5(mac) using the SQL-plugin. Has anyone done this? I'm getting this error. "Error in connectstring :java.lang.IllegalArgumentException: mm.mysql-2.0.4-bin.jar" Which JDBC driver are people using for mySQL? Has anyone been successful??

I'm currently designing a web site for a local company that uses FileMaker Pro 5. I'd really like to use ASP to connect to the database since it's the language I'm most familiar with. However, I'm running into several problems and have come up with many questions. I keep on getting an "Connect failed" error and an "Open failed" error. I have absolutely no clue why the connection doesn't work. I've tried several different things, and it just won't budge. I found some information today that I'm going to try but I'm pretty sure I still need help. Below are two different copies of code that I've tried. At the moment for development/testing purposes, I'm using Microsof…

Hi all,. I am using FMP 5.0 Windows version, and multi user environment. I am able to connect the Oracle from outside of FMP (from control panel). But I could not connect from within FMP from MY PC, one of my co-work who is able to connect to it from his PC. We both use the same file and same script (to connect). I always get the message "Exception": that's mean connection is fail, I wish I know where is the error file (if there is any) that explain why it failed to connect. You have any idea? Thank you in advance HP

I'd like to preface this by saying that this problem is very Mac specific- everything works properly when the same thing is done on a PC. I am trying to make an ODBC connection between WebCatalog and Filemaker Pro 5.5 on a Macintosh. All machines involved are macs. WebCatalog has it's own built in functionality for connecting to a DSN, which I have used on other platforms with success; however, whenever I try on a Mac, I get this error message: [FileMaker][ODBC FileMaker Pro driver]In SQLExtendedFetch, only SQL_FETCH_NEXT is supported for SQL_SCROLL_FORWARD_ONLY cursors. I am using the ODBC 3.11 Filemaker PPC driver and control panel which ships on the Filemaker Deve…

Anybody got an info on how to import xml data into a filemaker database. thanks

Hi, can you please give me a comparative analysis between cdml and xml? Which one is easier to use in developing filemaker database through the web? thanks!

My setup: OS X with FM 5.5 running. Database opened and shared with RDAC and LDAC turned on. What I want to do is access my data using a SQL query tool (SQLGrinder in this case) as a prelimininary step to transfering data from FM into mySQL. I have the FM driver where SQLGrinder expects it (~/library/application support/SQLGrinder) and it can see the driver. But...nothing works. I have the preferences in SQLGrinder set up as: Name: fmpro Base Class:com.fmi.jdbc.JdbcDriver URL: jdbc:fmpro:http://192.168.1.10 The SQLGrinder connection dialog has the following options: User: Password: Driver: Host: Database: Port: I've tried…

Is there any way to speed up filemaker ODCB connections? Filemakers ODBC is very slow! About 10-40 times slower than acces.... Imagine doing GROUP BY with filemaker.... : Timo

i have already install filemaker pro 5.5 and i do connection to filemaker via ODBC . i use ASP. the problem is too slow when i want list data filemaker. the size's file is 11,317 KB and 11,264 Records. it's very slow over 25 minutes i do select like this : SELECT Allette1.name, Allette1.COMPANY FROM Allette1 where upper(left(allette1.company," & len_letter & ")) ='" & letter & "' order by company,name" what should i do to make fast ? thanks

The project I am working on requires taking records stored in tab-delimmited text files and inserting them into an existing FileMaker Database. To do this I currently am using FileMaker's ODBC driver with Sun's JDBC-ODBC bridge to write a Java program to insert the data. The data consist of 18 fields, all of which are standard text fields. Whenever the SQL insert statement exceeds 393 characters I get the following error: # An EXCEPTION_ACCESS_VIOLATION exception has been detected in native code outside the VM. # Program counter=0x77f64d48 This is NOT a thrown exception, and occurs while trying to close the connection with the database. The insert works fine, but …

I would like to know, if it

Hello, The FM 5 odbc drivers do not install on our workstations. We use WIN98 se. How can I get the odbc drivers to either install from the FM CD or is there a place where I can go to download and install them separately. Thanks.

Hi I am trying to make my fm database shared through ODBC into a coldfusion server. As per the instructions, I try to enable both the access companions in the preferences, but I don't see either: LDAC or RDAC, only web companion. I can't seem to see why they aren't there. I use filemaker 5.0v3 on an NT server and have done a complete install of it number of times, but still of no avail. Could anyone tell me what the problem could be ? Thanks

I need a real fine explanation on how ODBC and especially ODBC and filemaker work (preferably in a 'ODBC for Dummies' style). Is there any website that provides this kind of information? What I want to do is a mail merge with Microsoft Word. Thankyou for helping me to find a solution/explanation Because I can't make it work and I am getting desperate for a solution. Any other solution that might make me do a mail merge with Word is equally welcome.

beginner odbc. using fm5.5 odbc to connect to 'corporate' database. is there a 'refresh' equivalent command or script (or even plugin) in fm5.5 that is available so i can get the latest data from the server to the online fm5.5 file. right now the only way i can do this is (be doing this) to re-import the data everytime i need a fresh copy of latest data on the 'corporate' server. this method is very slow and annoying. thanks.

RE: So my first question is--when I create the Data Source, it doesn't ask me the location of the file to use. Do I put the file in a certain folder? How does it know what file to use? ----------- Do you have the file open in FileMaker?

It's possible to use JDBC Class (comme with developper) on Linux platform to acces a FM database ? Ex: My website ( html ) are on Redhat Server with apache My database (.fp5) aron on NT server with Unlimitted Because i have tried with MySql and it's working fine but with filemaker i have somme error Thanks