FileMaker Server v7 - v11

Server: FileMaker Server 9 on Windows XP Client: FileMaker 9 on Windows XP I set up the Server as a single-machine deployment. I added my shiny new database, opened the database and status is listed as normal (Pro checked, everything else unchecked and clients 0). I disabled the firewall i n Windows XP as well (for testing). I open up FileMaker Pro 9 on the client. I go to File > Open Remote... I add a Favorite Host (Internal IP Address of my server running FileMaker Server). I also selected "Show all available files for this host" - Nothing shows up in the available files section. This is my first FM Server setup and I must be missing something.…

Hi all Filemaker Server Advanced 8 used to be so simple. Install the server, install the web companion and start serving. FMSA 9 is proving to be a nightmare, at least for me. I am trying to install it in a two machine config on Mac OS X. I originally wanted to set it up on two Mac OS X 10.4.10 Servers, but have had so many dramas with that. When I have finally got the configuration "working", I got an error along the lines of "WPE has too many active sessions. (error 956)." After some reading, people were saying it was a Firewall issue. I wasn't running firewall software nor was I going through our firm firewall. So I put the machines onto there own …

I've finally installed my first server version (9). The console opens fine on the server machine. However, not so on my workstation. When first going to the address through my browser it asked me to install Java. I did. Then I again went to the address of the server as instructed and the start page came up. I clicked on strarting the console, a Java starting splash screen came on, stayed on a minute then stopped and I'm back to my start page, not into the console. HELP!!! Mike

I recently updated 2 clients to FMS 9 and have now invested more time trying to get the things to work that I'm ready to convert them back to FMS8. 1. The first conversion (Winblows 2003) seemed to go well, everything go up and running all by itself and then I went to set up the schedules and I got one done and the rest would not run. and now it won't even start up the stupid admin console so I cant do anything at all. 2.. The second client (Mac X serve), I got expert help uninstalling FMS8 including all the stuff we are not told about, Installed 9 and it seems ok. Problem is FMS9 is not responding when I want to disconnect clients of close databases.. I got them clos…

Hello, I have a database on Filemaker Server Advanced and am opening it with Filemaker 8.5 Advanced- but can't open it on more than 1 client. Any advice? Thanks

During the installation of Server 9 Adv, I do not find a way to choose where I want to install the server files. It seems to go to C:/Program Files... and no choice along the way. Can someone help me find a way to install to a different location?

Yes, They allow me on the server! I tried to launch the Server Admin Console for the first time. It came up then locked up, I closed and tried again. Now I am getting an down load error, details: unable to load resource: http://localhost:16000/admin_console_webstart.jnlp. I tried to go to http://localhost:16000 by way of web browser and can't find page. How do I solve this one? The Tramp

Hi, I want to allow my users the ability to upload and activate their own databases (also to close and remove), but without giving them the full admin console. Is there a way to do this? I can share out a folder for them to upload the DB's to, but i then need to open the DB's myself. Only via the admin console do they seem to auto Open. Thanks.

When useing Filemaker pro Advanced Server 8 web publishing I want to control the location when a person hits the logout or homepage button when logged in while on the web. Does anyone know how I can change the hyperlink that seems to be set into the web publisher of Filemaker? I want to make these 2 button return to my homepage not the default that seems to be embedded. thanks

Hi, I worked on my User Interface file offline, compressed and then uploaded. The new version now has no check mark under Pro. The other file (data) I edited does still show the check (and is set not be vis. remote). But the Database UI file is accessible as a user from a preset link as well as via Remote, and behaves normally. In this file, I had cleared an excess file reference, but I did as well to the other. The file is viewed by 8.5 users, and I edited in 8.5a. Server is still 9.02. I reviewed sharing, looks normal. What do you think - leave it be or ? (I tried uncompressed version, no dif) OK, after a while, a refresh made it appear. Hmmph.

Hi: First let me say that I have no access or input to the setup of Filemaker Server in our organistation. I just create the databases and our network person puts them on Filemaker Server. Recently we have moved to a new server. Our network person has Filemaker Server setup as a volume on one of those servers. So when a user logs on to the server ip address to mount a volume for another business purpose, they see and can mount the Filemaker Server as a volume on their desktop. Just as they can see any other volume. Note: They cannot open the databases this way. The network person sees no problem with this situation. Can someone let me know …

I am trying to determine whether I need to use FMP9 or FM Server 9. I have an FMP9 db file that is shared on a local fileserver amongst 4 or 5 people using OSX Leopard and Windows XP. The file is not shared thru FMP or FM Server--its just a straight file sitting on the fileserver. We're not using Open Remote. Just open. We do not have FMP on the fileserver. When we open the file simultaneously and edit the file, person A's changes don't immediately show up on Person B's side, or vice versa. we can both edit records, but only one of our sets of updates ultimately shows up later. Can this work with this setup or do we need to install FMP or FM Server on ou…

Hello community, I have a question that I hope you can help me with. I currently have filemaker server advanced on a Mac Xserve 10.4.11 and filemaker server advanced being 9.0v3. my clients are also 9.0v3. I have this file that has pictures embedded in it, it is composed of 7 layouts (3 layouts which use the same container field to store a 40 kb picture, and 4 other layouts that have 16 text fields in each of them) The pictures are embedded within the file, to make it a final size of 329.2 mb My question is, when I try to remotely open this file, it takes about 1 minute before it can actually show the first layout. What is worse is that after it loads for every other…

Hi all, I am using FileMaker 6 and I have a question for all the experts here. I have a file working great standalone. Once I hosted this file on the server, it shuts down the filemaker program everytime I open it. Can anyone please help me with this? Thank you so much

Hi guys, does anyone know if there exists something like Filemaker Server Benchmark? I want to have something which will be testing fm server and telling me something like no of operations/second, RAM using and these things. Did anyone heard about somthing like that? Thanks a lot for every response.. Matěj

There has been a considerable amount of confusion in a number of quarters regarding the just released v3 updaters for FileMaker Server 9 and FileMaker Server 9 Advanced. [color:red]These udaters are not just for Leopard OS X. They are also for Windows and for OS X Tiger. You can go to this page on the FMI website for more information. Steven

I have an xServe running Leopard. I installed the new Leopard-compatible v3 release of FileMaker Server and got up to the point where it tries to launch the admin console. Shortly after I hit "trust" to the security warning, a message pops up indicating: "The Database Server is not available. To edit server deployment, please start the Database Server first." First, I tried hitting the "restart" button, but that just brought more trouble: "Unable to start the database server..." Some back story to this. We bought fmsa 9 back in December, and I proceeded to install it on the xServe. Only after I had trouble launching it did I do a search and find …

I have 4 old G5s (dual core, 2Gz) that I am using as servers. I would like to replace them with intel Mac Mini C2D 2Gz, for size and expense. Will the Intel Mac Mini perform as well or better than the G5s? Anyone have any experience? Opinions?

when I view client connections in FM Server Admin I have a whole bunch of xdbc connections that never drop out. I've attached a screenshot for you to take a look at. We have about 20 employees here. All the rest of those 1000+ connections are from non-dropping xdbc connections that my web applications are connecting with. I've double checked all my scripts to ensure that I am closing the connection after opening it up. I even created a new WebApp user in FileMaker and I'm using that in 1 place only, ensuring to close it after done using it in the script, and it is also being left in there a bunch of times. I even noticed when creating the WebApp user that I …

Hello all. I am running FMS 9 for Leopard (just updated from version 2). I want to install a trial version of server *advance* so I go to filemaker.com, fill out the info and here are the problems I'm encountering. 1. Takes days before I got an answer (tried multiple times, see below). 2. When I finally get an email to direct me to the download page, it's not for server advance, but for server. 3. I've written multiple emails to filemaker support and I still haven't gotten an answer (yes, I did check my junk folder, just in case). This is a major PITA, not because it's a biggy in terms of time waisted. I'm on a high speed satelite connection and I get…

Dear people, Yes, I am a newbie and got a bit confused about the different versions of FM. Let me explain: We are running a charity. We have a database that we need to access at two places: an office in the Philippines and an office here in Holland. From both places we need to be able to access the database but also perform mutations. Making lay-outs and changing fields etc. we only do from one place (Holland), but accessing the data and changing the content from two places... and... fast connection. We have access to a seperate server if needed, but noe we run FM on a stand alone computer. What is the best solution for this? Yes, we are a charity with limited financia…

Have down searching, no luck. Anyone know the concurrent user limits for FMP, FMS, FMS+ and webclients for each version? (I still maintain ver4, ver5.5, and ver8 databases for clients...)

Some databases when uploaded won't open in the admin console (and not available to clients). Seems that account settings are correct. Any solutions?

I've followed all the admin guide steps, and plugged in the information about our Mac OD server appropriately/as close to matching the config on our working Server 7 on Mac install... But I can't get Mac FMP7 or FMP9 clients to authenticate against the windows-hosted version of our FMP server to save my life. Is it possible to use Mac/OD as the auth source for external accounts when using a Windows Filemaker Server 9 install? Or do I have to dig into the depths of AD (which we don't use at all)/some other Windows-ism to get things working? We're just trying to "simplify" our backend by moving all compatible apps into a VMware environment (which of course is no…

I am a beginner in FM9, and encounter a difficulty when saving the Host's timestamp into the record being updated. The problem is the Timezone for server hosted in US, while I am running the program remotely in Hong Kong. i.e. time-diff is 16-hours. Therefore, the default database - "Auto-Enter" does not work, because it keeps saving client's timestamp instead of the host's timestamp. Thanks a lot for your help. )

Greetings, I am brand new at File Maker and at Mac Servers. Usually I work in the Windows server environment with Access or SQL, and even then, I am no DBA by any means. I have a project to get a website up that is running from Filemaker Advanced Server 8.0v4 on OSX Tiger. The goal is to make various Filemaker databases available over the web. We have a URL and an IP address, and a G5 running the 2 above mentioned programs. I am wondering if anyone can point me in the direction of how to get this set up, with the result being a site with links to the data in these databases, delivered over the web. As I understand it, Filemaker can host web sites and make databases avai…

Hi All, We have FMSA7 running on a mac and this server hosts many databases. Suddenly, when we tried to login into the FileMaker Server Admin and when we were prompted to enter the password, the application was not accepting the password. But we feel that the password is correct. All the databases are still being served but we are unable to launch the FileMaker Server Admin application. We went to the unix shell and tried to execute the fmsadmin -v command and we were asked to enter the password. At the command level, the password was accepted and all the server info was displayed. Has anyone encountered a similar problem and how did you resolve this situation. …

I just installed FMP Server 9 for the first time. It attempts to bring up the admin console screen in my browser and goes thru a few operations and eventually says it can't start the db server, so I never actually get to an admin screen. I've never had a fmp server program before, though I do run lasso 8.5.5. I'm running the latest Leopard. Installation of fmp server has also made lasso no longer function with my older fmp solutions. The userguide gives me no help in troubleshooting. Any suggestions?

[color:red]Error message: There is not enough room on the disk to complete this operation. Make more room on the disk. then try again. Filemaker Server Advanced is running on a Mac and PCs connect to it using a PC Windows Server 2003 where everyone has dumb terminals and login using passwords to gain access, then launch the application from the Windows Server. The Macs connecting to Filemaker Server have no problems whatsoever. But periodically someone on the PC side gets the above error message. There is 200GB of space on the Filemaker Server so I don't think it's that. Anyone have any ideas Thanks Peter

Our company is finally going to upgrade the server and our development software from v5.5 to v9.0. One option we are looking at is utilizing IWP rather than using the client FM pro for the users. We currently have about 100 5.5 licenses and are looking to minimize cost while maintaining current user functionality. We are excited to use IWP but we are concerned about speed, performance, and security issues going this route. We have approximately 70 databases hosted on the v5.5 Server. The network is planned to be on a closed intranet system to minimize security issues. The platform is windows 2003. Most of the workstations have windows 2000 but there are some with wi…

I've put together a FM9 DB for a client, but have encountered some problems now that it's been launched on the server at the client site. A "Work in Progress" layout includes a portal which displays work-in-progress for the currently-logged-in customer service rep. The layout is based on a "Users" table, and the portal is filtered to show only those jobs which are not marked as "invoiced" but that do list the user as the CSR for the job. This works perfectly on my development machines, on the client's desktop, and also when uploaded to a FM hosting service. However, when the DB is launched on my client's FM server, nothing appears in the portal. The appro…

Hi, I've benn pulling my hairs with a particular client of mine. I've developed a solution for them, simple stuff, 5 tables. It's hosted on their network, but I don't have access to the server. I know the server is version 8 or better. Now here's the problem: from time to time huge blocks of records are disappearing, consistently and in record ID order. So every record from rec ID 0000 and 3000 are now gone.Anything after 3000 is there etc...Then a couple of months later everything from 3000 to 5000 goes! Now I have to exclude employees deleting records, I've created a tracking system that tells me who deletes what, I've trained them over and over. I checked e…

I have a newly installed instance of FMS9a on a Windows Server 2003 platform. The FMS Admin Console reports all systems are normal, and databases are accessible via remote FMP connections. The Admin Console Start Page appears to be working fine as well. However, I can't seem to get to the IWP page. Entering the server's DNS in a browser loads what appears to be an IIS "under construction" web page. I'm sure I'm missing something simple, but I can't seem to figure it out. Any suggestions?

Hello I am new to web publishing. I see that you can have up to 100 simultaneous users/viewers of your database at once. What do you do if you have more than that many viewers. Say 1000 or more. ? I just wondered if there is any solution to this? Thanks

Over the weekend my server was rebooted due to a Microsoft windows update. Upon restart I notice (1) hoested database out of 15 was closed and did not start automatically within FM Server 9.0. I gues thee database was corrupted with the shut down so I performed a recover on the databaseusing 9.0. BTW the origional file was created and hosted with FMP 7.0 before I upgraded to 9.0. After the recover the database works good. There is a check mark missing in the "pro column" on the server main screen. I am not sure why this happened and even if it is relevent. All of my other files have a check mark. Can anyone give me any insight to the "pro column" and why a recover would h…

I am running FM server 8 and connecting to it with FM 8.5 with a volume license. The problem began when I reloaded a machine with FM 8.5 but used a single user license. If this machine attached to the server first without any other machines having FM open all was fine. If, however, one of the computers with the volume license was open the single user license got a license conflict warning and would not open. This was easily solved by reloading with the volume license. But now I have someone who wants to access remotely from home and they have their own copy of FM 9 and we are getting the same problem. If there is not a volumed licensed machine on they can connect no…

Hi, I am running FM Server Advanced 9 on a Windows 2003 platform. I have enabled IWP in the Server Admin Console and set the session timeout value to 60 minutes, but I still get kicked out after being idle for 15 minutes. Where do I change the session idle timeout value in FMSA 9? Thanks in advance, Peter Schwarz

I have installed FMS9A (Windows OS) using a two machine deployment. After a successful install (green lights on), the php test fails with the message "WPE has too many active sessions. (error 956). I am running Windows Server 2003. The databases are accessible, but accessing the sample database with PHP does not work. phpinfo() also displays the current php environment indicating php is running on the second machine.

I have a database that I use to help manage documents at my cabinetshop. This database is hosted on a web based dedicated server. As I understand it, this is being run with Filemaker Server Advanced. I can host up to 50 databases with up to 5 simultaneous users at a time. I am having problems sharing data via container fields. If I insert a PICTURE into the container field the data is visible from all client stations. If I insert a FILE or a QUICKTIME the data is visible from the client station that uploaded the data but it is not visible from any other client stations. When this information is addressed from other client stations there is an error m…

Well, it seems they tried a bit to make it more friendly. But little things can be quite irritating, such as: I just selected action 'Close All' and all the files dutifully closed. But it bothers me a lot that the icon still shows that the databases are open. What in heavens is wrong with words as well? It's not like they are short on space! And why can't there be a simple button which, when clicked, can back up the files right then? If there's a way, I haven't found it yet. Currently I have to set a schedule (manual) and change the date time to future. It is so unfriendly. And why, when you close the databases, does it produce a message (which looks li…

I have been running a backup schedule on Server 8 for over a year with no problems until now. All of a sudden it will not run any schedules old or new. I have even tried running manually, and the area under last run flashes "running" so quick you can hardly read it but never actually completes the schedule. I have tried restarting the system, and stopping and restarting Filemaker Server. Neither worked. Any Idea's. This handles my daily backup. Thanks, suzie_q_11

Hi Guys, I have a script which basically sends an email using the 'Send Mail' script step. I would like to schedule this script to run server side every night. But i keep getting errors when i run the script server side stating unsupported script step...is send mail not supported server side? Im running FM Server 9 adv 9.0.2.151. OS is Windows Sever 2000. Thanks.

I want the backups to be done every hour whenever the machine is up. I cannot get it to work that way. Currently, I have the backup scheduled to "Every 1 hour from 8 PM every 1 day starting at 1/15/2008". It made backups at 8pm, 9pm, 10pm and 11pm only. Then it stopped. It says the next run time is at 8pm on 1/16/2008. Help!

A client can't remember his password for the Server Admin, but wants to upgrade to Leopard. Is there a way to get the Server password? Or do we have to totally reinstall Server? If we have to reinstall Server, how do we stop it first so that the hosted files aren't damaged? Thanks, Steverino

Hello. I am new to modern FM. I used FM years ago, but that was limited at best. I have working knowledge of the basics, but not FM's advanced features. I have a OS X 10.5 server running some web apps currently and want to integrate FM into this server. Which version of FM would work for me? I have about 12 users who would be creating, editing and searching entries in multiple databases. Not all users would be using the databases all of the time. The databases would be mostly starting and ending points for tasks and as references for other information. I like the ease of the web interface and not needing to install FM on client Macs. Down the road, the system may …

We have been trying to install FMS 9 since mid-July. After repeated attempts and endless hours of troubleshooting, we still have not been able to successfully deploy FMS 9. We have had to re-install FMS 8v4 after every failed attempt. I can get everything working as advertised except for the web publishing component. Any attempt to utilize web publishing using PHP or XSLT is met with an error: 956- "Maximum number of database sessions exceeded". Configuration Two Win 2003 machines (FMS on master. Web publishing modules on web server.) Preexisting: FMS 8v4 and PHP 5.2.3 deployed via the 'Zend Core for Windows' package FMS 9 install: We are trying…

I just installed Filemaker Server 9.0v2 and need some advice how to setup server side scripts. I would like to run a script on a hosted database but I believe there may be an issue that will prevent me from doing this. The script basically deletes all records and then imports records from a .csv file. This is a download from another system and I cannot access it. It is my understanding that Filemaker Server can only run Web compatible scripts (Delete and import are not web compatible). Any suggestions as to how I can accomplish this? What I want to do is keep my Filemaker database in sync with an AS400 database. Thanks for listening

Does anyone know of any issues with using Server 8 to server some users of Filemaker 9? I cannot upgrade to server 9 since we are using a dual g4 as our server. I just updated a few of our users to 9 and now a file takes forever to load. Thoughts?

I have server 8 on a mac platform and have no problem hosting to mac OS X and windows XP clients. I personally connect to my server via my Intel Mac running Mac OS 10.4.8 using FM 8.5, but I also want to connect via XP running on my mac via Parallels (so that I can view layouts in Windows). FP 8.5 runs fine on Parallels/XP (I can create a database), but when I open remote to connect to my server, there is no host listed (unlike when I connect from Mac OS X). Any suggestions? Thanks

Is it possible to upgrade FM Server 8 to 9 and leave Web Publishing component on version 8? I do have them installed on 2 separate machines and the web machine is OS 10.3 so it would not let me install the Web PUblishing 9. The actual server master machine is OS 10.4. Thank you very much!

I am trying to run a script that is in one of the databases hosted by FilMaker Server 8. I used to do it via cron job that would run apple script that would open that db in FM Pro. I am trying to eliminate FM Pro and just run the script on the FM SErver machine. Is it possible? Thank you!!!!

Good Afternoon All, I have a weird situation where I have two client machines at one remote location running the same files hosted from our filemaker 8 server. (at the home office) When running complex scripts from these client machines, the wireless laptop (macbook) plugs through just fine and finishes the entire batch of scripts. If you try to run the same script on the wired desktop system (intel iMac) it hangs and messes up all the remaining processes it should have performed. Other than checking the energy save, does anyone have any insight on this. Thanks! Marc

Hi, I am having a serious issue activating the web publishing on FMSA 9: The admin console is working fine, until I get to step 5 where you have to choose a web server: A pop up appears that says "Impossible to get web servers list from specified computer" This prevents any web publishing features to work (XML, XSL, PHP, or IWP) The computer is a Windows 2003 SP2, with IIS 6.0 (not 5.0) installed and working. It is a brand new machine, nothing else is installed. So far I have tried: - Installing a working apache, with and without the connector - Reinstalling everything (IIS, FMSA) - Reinstalling Java only - Opening ports 16004, 16006, 16008, …

We're still in the testing phases for our upgrade from 4.1 to 9, but when users try to access a particular file, I get the email server warning that authentication failed. So we wouldn't have to deal with authentication issues during the upgrade, I removed all passwords. That worked fine until about a month ago when these errors started coming in. Also--I am unable to mount any of the FM 9 updates (separate issue)--could that be causing the errors??

I'm using pfp FX class with a filemaker database. my question is how many people can simultaneously access the database via php and what happens once the maximum number of connections is reached? What happens when the maximum of 250 user connections is reached via the client? What are the workarounds, if any, to accomodate more users per application?

I am trying to set up a FM Server Advanced V8 to serve up some IWP DBs as web pages. I have everything in place (that I can tell!). I can load up the IWP Homepage which correctly lists all the DBs on the server - BUT when I click on any individual database to open it I get an error message "Database not available" The DBs works fine if I serve them up using a copy of FM (ie: IWP with the client software). I have opened the DBs directly with FM while in position on the server and checked all the accounts and privileges are fine. Any ideas?

I have run into an issue that I can not figure out how to resolve. I am running FileMaker Server Advanced 7.0v4 on Mac OS 10.4. Custom Publishing with php. I have changed my dsl service and my static IP address has changed, so i figured all I would have to do is get the ip address to change in the Web Admin Console under Clients in the FileMaker Server Admin, which I did. I am able to connect to the FileMaker Server Advanced Web Administration Console with the new ip address. The new static ip address is showing in the Overview page. I restarted the Web Publishing Engine and logged out. The html login page displays when I enter the new static ip address. …

Hello all, i am running two filemaker Servers in our Company, one is Filemaker Server 8 and the other one is Filemaker Server 5.5. Is it possible to run these two Servers on the same Machine? I already saw that they are using the same Ports, and did not see an option where i could configure port numbers used, but i still like to be sure. Thanks and best regards

hi, This is sathish new to forum..i hope that u people will help me in issues- i have installed Filemaker Server 9 in my system and tried to open PHP site assistant while i am creating new site alert window appears saying [color:red]";" expected JScript error if i continue with selecting ok button ,after that it asks me to connect while i am clicking connect button says check server but it is correct.. can u help me please

I have a columnar list type database that establishes priorities for tasks and monitors status of these tasks. This database lives on a web-based dedicated server. I have been very careful to keep all the handshakes simple. The database only has two tables. The majority of formulas etc reside on just one table. The second table consists of a match field and worker names that I use to populate task assignments. I make extensive use of conditional formatting. The default fill pattern for all tasks is white. If the task priority = "NEXT", the fill pattern turns yellow. If the task priority = "HOT", the fill pattern turns red. If the task status is …

I recently developed some software for a company in USA, and now they have asked me to make something bigger for them. The new system will be for tracking inquiries, quotations, placing and monitoring purchase orders with suppliers, inventory management, invoicing and interfacing with an accounting system. Between 5 – 10 people using the system in any one location, and similar systems to be installed in 6 locations around Asia, with an “overall” view of things back in USA (not sure how to do that yet...). Not more than 3,000 transactions with a total of up to 30,000 line items per month, per location. My question is whether or not FM & FM Server is the…

Hi guys, I am looking to set up a Quad 2.5 G5 Tower as a server for about 35 clients. I am trying to find out what is the best way to squeeze out as much performance as possible. 1) I heard that fast drives (10,000 or 15,000 RPM) make tremendous difference. I can't find any external FW800 or SCSI RAID with these kind of hard drives. At least ones that are not server racks. 2) Does it seem like a good idea to get two 15,000 RPM drives and use OS X mirror option and run the operating software and the files off those drives, or should I really look for some kind of an external solution? 3) If I go external am I better off using latest SCSI format or FW800…

Scenario: Problem: I've got a database (Job Diaries)that is used to record progress on our projects. It has about 8 fields that must be filled in (date, author, who there, body...)There is a script that sends an email to people chosen from check boxes using SMTPit. Has worked great for years. Just noticed that a record can be created, the email script can be run and then the record vanishes from the database. THis doesn't happen all the time. Theory: It never gets committed from the client to the server. Conundrum: I thought that upon exiting a field the data is committed. However, the new "commit record" step in scripting implies a need to force that to ha…

FMS 9 on winXP, local FM9v3, adv on Mac OS X.4.11 In the process of investigating some performance issues, I have a simple test file, one table with two fields, 40000 records, with a script to do a simple replace (number field, replace with value 1). When logged in from my Mac, via ssh/open remote/ fmnet, the replace takes 4:30 minutes to process 1000 records. Similar performance is had from a RDC/terminal services client. The same script when run from a FMSRV schedule; does 40,000 records in 10 seconds Any ideas on what may be causing this? Any ideas on what may be causing this substantial difference?

: I have just set up Filemaker Pro Server 8 Advanced on an Intel Mac and successfully configured it. However, when I transferred the files from another non-Intel Mac to the Intel-Mac, I got an 802 error on all of the files (there was no problem on the non-Intel machine). I checked the permissions and they all seem to be fine. This is a machine that has several different logons, but all have read and write permissions. Any suggestions as to what could be wrong?

This is a problem specific to when a database is hosted on our FM 8.5 server. It's tough to describe but we have some value lists that are populated using relationships to external FM databases also hosted on the server. If I open just the database with the lists they say . However, if I open the child database first, and then the main database, the value lists are populated correctly. I've included an example of what I am seeing. If you just run these on your local machine they work fine. If you host them on a server, things get funky. The attachment contains two files Test - only one ID field to related to other table Test_Authors - has author det…

I've got FM Server on a dedicated machine but anytime I ever have to open a file locally in FMP I have to transfer over the network and back. It's kind of a pain with large files. Would it cause any problems if I were to install FMP on the server along with FMS? Any information would be great. thanks!

Hi there! I run FM Server 8 off of a server with Windows Server 2003 as the OS. All the client computers are running FM 8 off of WinXP. I recently had some issues with our Linksys router (basically it destroyed itself during an attempted firmware upgrade) and after I got through with their tech support, we had to force the router to change its IP. I used to log into the FM Server Admin tool in order to tweak/close our database whenever I needed to back it up. Now, even though I have changed the IP on the login screen to the server's new, current IP, the login tool repeatedly tells me "Login Failed". I have confirmed via my network connection that th…

I'm trying to set up FileMaker Server 9 Advanced on a brand new Mac Mini (still Tiger) and I'm unable to specify a FireWire-connected external drive as the backup destination. Is this not possible? When I specify the path it comes up as "Not a valid path". I've played extensively with naming and permissions to no avail, but obviously I'm doing something wrong.

I have a variety of databases that are hosted on a web based-dedicated server. These databases are accessed via button driven scripts. The buttons all live on a database called Bulletin Board. The BulletinBoard database has no fields. It only consists of a layout with the script buttons. So far, everything is working fairly well except for one aspect. Intermittently the server closes down and I get an error message that says: "Communication with the host was interrupted and cannot be re-established. All affected windows will be closed." I have a couple of questions about this: [color:red]What causes this interruption to happen? The second par…

I'm new to FM Server and relatively new to Windows Server. Is there a way to setup the firewall on the server that automatically opens the ports needed for FM Server? In the Security Configuration Wizard, it sees the FM Server and supposedly lets it do what it wants, yet I have to manually open port 5003. I'd prefer to tell the firewall to allow the FM processes to open whatever ports they need. What processes would I choose? Otherwise, how else would I setup the firewall? Manually open a list of ports? Thanks, John

Hi Folks, I am evaluating Filemaker for a large email database. The problem is: on importing large amounts of emails (thousands) the client crashes. I can prevent that by doing a sort on the database after every email. But a sort takes minutes. Filemaker does the sorts on disk, although the Mac Pro has 32 GB of RAM (I can see that by the way disk activity happens). Is it possible to pin a database in RAM like I can do it with tables in Oracle? Is it possible to force FMS9 to make sorts in RAM? Our project clearly would fail with Filemaker being unable to use RAM efficiently. Any help or hint would be appreciated. Thanks in advance, Dirk

Is there anyway to prevent a username from being logged in more than once? In our company I noticed the same user was logged in from more than one machine. A couple users are obviously sharing username/passwords. Is there a way to disallow this either by scripting, a server configuration, or a server plug-in? Thanks

Hi everyone, I am running server8 on a machine in windows. It was working fine and now I can't see the files. If I use open remote on the server computer (I have filemaker8.5A on it as well), it finds the host, lists the files and opens it up fine, but on any other computer on the network, I go to open remote, and local hosts, it finds the host but does not list the files. I tried manually typing in the file but it says it can't find it. Any ideas

I've got a situation at a client's location where certain data is going missing. The environment is a FM Server 8 hosting at one physical location and FM 8.5 clients in the same building and other FM 8.5 clients coming in remotely. Most are on a dedicated remote line. What we've seen is data has gone missing from certain fields of certain records. The database is a few thousand records, we've seen data missing from one field (always the same field) for maybe 10-12 records. We're wondering if because there seems to be slight delay for the remote users, whether it is possible that two users could be modifying the same field of the same record at the same time and…

Updated to FileMaker Pro Server Advanced 9. Everything is working fine. All my previous XLST databases are still working, but I now want to try PHP. Launch FileMaker Pro Advanced on my iMac, and selected Tools > Launch PHP Assistant. The web page comes up to select PHP or XLST. When I select either, I get the same error. "Unable to Launch FileMaker PHP Site Assistant". If I click Details, I get "Unsupported JNLP version in launch file: 1.5. Only version 1.0 is supported…" What is a JNLP and how do I get the older version? G5 XServe OS X 10.4.11 Server FileMaker Pro Advanced Server 9.0v2

I am trying to install FileMaker 9 Adv on our new Leopard server but when I manually launch the fmserver_helperd service (because it gives me a database server error if I go about it normally) I get the following error: THE_PROCESS_HAS_FORKED_AND_YOU_CANNOT_USE_THIS_COREFOUNDATION_FUNCTIONALITY_YOU_MUST_EXEC_() I know that FM9 is not supported fully in Leopard but I can't even get it work so I can run the new update which fixes WPE part of the filemaker issue in Leopard. When I run this update it does not find any valid filemaker versions. Any ideas where I should start? Thanks, Kerri

I am setting up a virtual server for FMSA. I plan to be running and handful of relatively small databases serving to about 10 users. I am wondering how much HDD space I will need. The sys reqs for FMSA say 80Gb. Is this not too much? Can I get away with less? Thanks!

I am running v9 adv server on win 2003 std sp2 and i am having some recent (today) problems. Sorry for length... I was doing some data entry in a database hosted on my server. I got caught in a field level validation that would not let me gracefully exit so i terminate the FileMaker Pro.exe file on the client side via task manager. I started to receive automatic emails that server authentication was failing yet the databases were all still completely available from clients. I thought that closing close all the database files on the server and reopening them to force the consistency check would reveal any file problems. I remote desktop into server and I could not acce…

I'm hoping that I'm missing something, but it appears that it is no longer possible since 9 to have a configuration where the Web Publishing Engine can communicate with 2 FileMaker Servers so long as both database servers had the same WPE password. (I realize version 9 no longer uses WPE passwords, but pointing out how is was possible in version 8) I have a database on 1 FileMaker Server that has related data on different FileMaker Server. I used to be able to use IWP to publish the database on Server #1, and even though some of the data was on a different server, it would still work properly. I cannot get version 9 to function this way. Is this true or am …

Hi everyone. I have limited experience with FM7 and am looking for a solution for the printing company I have just joined as general manager. I have built a very basic system in the past but am looking for a bit more. I would need it to provide quotes, convert them to jobs, track it through several stages of production, produce delivery notes and other supporting documentation and finally provide invoice data to send to the parent company in some shape or form. I require approximately 6 users and can hold it on a server. Some of the Filemaker own solutions seem a little over complicated for my purposes. Can anyone suggest an 'off the shelf' solution that may be…

Finally I have found an "incompatibility?" between admin console (java application) and XP sp2 when you use Spanish Language. So, in order to start the admin console I have followed those steps: 1 - I made an uninstallation of Java enviroment (all versions that we found on server machines that had the same problem with admin console - may be this steep it´s not absolutely necessary) 2 - Then I changed the XP language to English (united states). However IT´S NOT NECESSARY to change the keyboard language which is an important key for users who has a password which uses typical spanish characters. 3 - I made a clear java installation downloading installer…

I know the server will make an automated backup of the db...and that goes to the same folder each time (or have I missed something about making daily backups). So, if you have a bad db then you are backing up the bad db. I have wondered if there was a way to make a "Daily" backup to different folders. [color:green]I was searchin the Internet and found this: I am trying to script a backup for a file. If(Day of Week = 2, backup to folder Monday, If(Day of Week = 4, backup to folder Wednesday, After writing these steps, when I look at the Monday step, it is set to save to Wednesday; it apparently doesn't save the folder name to save to. I something…

We have a workgroup with FMP9 installed, all with unique license keys, on a mix of boxes running Mac OS X Tiger. All of them (bar one which would require a separate post) run FMP9 with no problem - for local (on same HD) databases. However, when attempting to connect to files hosted on FMSA8.0.4 over the LAN, several of them report a "License key conflict with user FMServer". It does not appear to be a problem with the databases as this occurs even with an unaltered version of one of the FMP9 sample files. The main thing these problem machines have in common is that FMP9 was installed under a different OS X user account than the one which is attempting to use it…

Hi, I have a file called RZSetup that comes from a conversion from FM6 to FM8. Opening it with FM Pro Advanced or FM Pro works fine but if, in FM Server 8.5, I tell it to open the database, it stays closed and it doesn't do anything. Is there a way I can check why this happens? Robin

I am wondering if anyone else has come across this problem. I've installed FMSA 9 having already had PHP 5.2.2 installed so set the installation to use the existing PHP installation. The PHP test.php page works fine when I open a web browser and type in: http://localhost/test.php However when I try to run the Test PHP Custom Web Publishing page all I get is a blank page. The path to the phptest.php appears to be correct otherwise I would get a 404 error: page not found. I have since updated to FMSA 9.0v2 which hasn't resolved the issue. Also I tried the Edit Server Deployment link which effectively reinstalls the web publishing engine which didn't work…

Was thinking about purchasing a volume 10-pack of FMP 9s upgrade to standardize our network. We have only 7 clients active, and could go to 8. In researching I realized that FMP 9 will host 9 clients rather than the 5 clients last time I looked. I currently use Server 8 to host these 7. Are there any disadvantages to using a dedicated machine to run FMP 9 and host the 7 others as compared to Server 8. Is there something not obvious to me? Also, I cannot find any "rules" on using the 10-pack volume license for one user with both a desktop and portable - does this count as one or two? Specifics: 1. 5 clients on Win XP and 2 on Vista. Host would be on …

Hi, FMS 9 on win XP, serves 2 databases currently these are accessed via a windows terminal server running FMP9. Still in test phase, so no clients logged in. Performance seems ok generally, but in layout mode, some things slow to a crawl. click select a field then click delselect that field (i.e. click on layout background), takes 25 seconds to refresh/deselect. Dragging a field 2 cms takes in excess of 2 mins. Working in the Relationship graph, is similarly impossible. Have upped the FMS RAM allocation to 2GB, and additioanly reset the cache to 256MB, with largely imperceptible change. The TS has 1.17 GB RAM Any thoughts on this?

Hello This may sound like a silly question, but does anyone know if I can run an FM server off a dot mac account? Has anyone tried?

I am fairly new to FMS 9 and I have a problem directly after installing the server. The installation launches the pre-launch web page, but I never get past that page on one of my customers. They have MS 2003 server and firefox 2.x installed, Java version is 6.X. Am I missing something? I have never installed with firefox as default browser and it usually works fine with IE7 (wich the customer wont install "to much crap in c:" - he's prob right...) At first Firefox was not installed so the system tried with IE6 - not working of course - he then installed firefox 2. Anyone familiar with this problem? Thanks! /Tomas

Hi, Is it somehow possible to have FMSA 9 to close/open all databases according to a schedule? (for example, close all at 5:30 and open at 5:45 on a given day) I was looking in the FM Server Admin program scheduling functions and the documentation, but could not find anything there. Jari V

Howdy ppls, Im a newbie at filemaker and i got a question for you. We backup our entire server using Symantec Veritas. will that safely backup the file maker database? or will it come up as corrupt if we reload our image? Im slightly confused because to my knowledge the filemaker database is a fully live database and backups of these type of databases are volatile when it comes to copying or backing up without proper proceedure. can anyone give me guidance on what i should do? Many thanks. Huy.

Hi, I tried a quick search and to be honest I dont even know how to phrase this for a search so I hope someone can answer. I was thinking about purchasing s9A for work and was wondering if I could still host my older 8.5 db's on it and access them with my old 8.5 clients. I got this off the FM site: Supports sharing amongst FileMaker Pro 7, 8, 8.5 and 9 clients I assume it will host the 8.5 db's ok but Im not 100% sure. Thanks, James

I am using FS9A on Windows 2003 server in a two machine deployment. We need to change the internal IP address of the worker station. Both machines are behind the firewall since the system is only for internal testing. After changing the address, when we load the php page it only loads the html and then hangs. We changed the ip address in the following places: 1) On the worker machine (TCP/IP) 2) In the php connection file 3) Under IIS manager the properties for Default web site 4) On the Master machine, admin console, editied deployment and assigned it to new worker IP address. (Green lights on for PHP with new address.) Is there any pl…

Now that FMServer 9 can run scripts, has anyone had any success sending email from server. Are the SMPTit or MailIt plugins capable of sending email from a server script?

Running 8.0v4 Advanced. Daily backups are working fine. Hourly have never worked. Both are set up with the default settings. When I log into the admin console it tells me when the next hourly backup is going to run, but the hourly folder is always empty. Is there somewhere that would give me a clue as to what's happening or not happening?

I have a script in a hosted database which imports records via a SQL server call. I'd like to schedule this to run in the evenings from the server, but the script fails with an error 643 "unsupported script step". Can anyone help me in how to schedule this type of a script on the server?

I have a database that is installed on web based server in California. (My cabinetshop is in Washington State) I make extensive use of columnar type list layouts. I use these to post and monitor status of work orders. This database is accessible from several locations. The work orders are posted then accessed via scripted start & stop buttons. The scripts all terminate with a Commit Records/Requests statement. I do this to make sure nobody can inadvertantly leave a record open & preclude others from acting on that record. I am having a problem sometimes getting the screens to refresh on all of the client stations. I can, for example, delete …

I have a problem that has popped up recently. We had to reinstall a server. Everything works fine with all the files with client on the local network, but some files, when accessed remotely, open OK but then crash when scripts are executed. I get the message "Communication with host was interrupted and could not be reestablished (-3259) What do I have to do with the crashing files to solve the problem? Lester

I cannot find the maximum databases hosted by FM9 server. On 8.5 it was 125. We're planning an upgrade & would like to consolidate servers. Anyone know if 9 can host more than 125? Thanks