AndriesV

Thank you! For the quick reply:) Not for the bad news:(

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

Running FM6 on Windows against FMServer 5.5. Hope this is the correct forum to post this question. Even though at first glance this may appear to be an ODBC question, it's just mentioned to explain the setup. In attempt to reduce the ODBC reporting burden for the FMserver users we created a separate storage location where the last-night backup from our production files is being copied to. The problem is this: The few users who have access to the reporting backup files open this data-set every now and then to run some reports through ODBC connections, so far so good. After they close these files and connect to the FMServer production databases, the client opens relationships to some of the offline reporting files even though the normal production files are already opened from the server. Only renaming the backup set folder name or removing a drive-mapping to this location will avoid having open files from both the server and the offline set at the same time which of course is very undesirable. I have already made sure that no script is storing the full path to this location. Somehow the FM client remembers this recent file location. Does anyone have any suggestions? Is there some option or registry key to turn of this behavior? Thanks in advance, Andries

Recently we've upgrade our FMServer from 3 to 5.5. The system it's running on is a W2000 SP3, 500MHz, 320MB RAM, local RAID5 storage, dual LAN connection. Hosting 18 db files of together around 250MB for an average 20 users. Since the upgrade the overall system performance is really bad compared to the old FM3. Most insert and updates now take a couple of seconds where it used to be 'instant'. Sometimes FM even seems to hang for 10-20 seconds before an update is accepted. We've already played with various settings and monitoring numerous system counters we have notices that the server is 'eating' through it's system cache. FM is configured with a fixed 20MB cache which results in an avg 97% cache hits. In the taskmanager is shows this a steady 20MB as being used by the FM service. The system cache however is slowly increasing over the day and in a cycle of around 12-15 hours all available system memory is taken by the cache at which point it is suddenly all released, usually performance is bad around the time that the available memory goes to zero. Has anyone seen this before? Or does anyone have a suggestion on improving performance? Thanks in advance, Andries

Thank you

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

In the Log file create a calc.field "cWithinContractDateRange": If((log-date >= contract::date1) and (log-date < contract::date2), 1, 0) Now in the Contract file create a calc.field "cLogCount": sum(contract-log::cWithinContractDateRange)

Try http://www.ps2pdf.com/ On their website to they point to their freely available AFPL Ghostscript Software, it does the trick in our situation. It may not have all the features and options of the official Adobe solution like e.g. protected pdf files. Some fancy colored pictures don't always get converted nicely, but our (black) logo's and formatted texts end up perfectly in pdf. For us there is no vissible diffence between a direct Filemaker print to paper or the printed pdf file.

Thanks very much

Does anyone have experience with having a database system hosted on a server in say Europe and at the same having the set of files hosted in e.g. Asia. Global management of course would like to get global reports out of the combined data.... Is it possible to synchronize data between multiple servers? So all records are available and therefore reportable on both servers. Two other related questions are: 1st, how does FM treat web-users; if 75 users connect through the web does the server 'see' this as 1 (FM unlimited) user or are really 75 out of the max. possible 250 (Windows) user connections in use? The 2nd question: does FM have problems with Japanese or Chinese characters? If so we could be running into issues in Asia. Thank you for any feedback

Thanks a lot, just what I was looking for. Couldn't find it in the help files.

Is it possible to have mixed case text keys in FM? The reason for asking is that I have to import leads with unique identifiers like record1: 00Q00000001gBVC record2: 00Q00000001gBVc Sometimes it would be helpful to use this key to exclude duplicates on import etc. Is there a way to make this a unique key in FM or make a calculation on this field that will be unique?

Thanks, I'll try to lookup Droids post(s) With regard to the performance topic, would you know where to find some information on how FM e.g. handles searches in a client server setup. Does the server do most of the processing or does it only send all relevant fields, or indexes where available, to the client for processing or ... I've notices that when a client starts a time-consuming search the cpu usage on the server never goes over 25%, still all users suffer from the impact on overall performance. This can't be totally blamed on bandwidth as other network activity in the same segment doesn't seem to be affected. On the other hand if the network is busy, e.g. because too many laptops do a backup at the same time, this has an impact on FM even for simple data-lookup's... Are there some general explanations available somewhere?

Thank you for all the feedback. One question still, what is it that I look out for with regard to IF[] statements.

Thanks, with upgrade to fp5 I meant the file format, were indeed trying the trial versions of 5.5 at the moment. I actually tried the above mentioned URL link (fmp5://[password@]domain/filename) but couldn't get it to work. If anyone could offer a little help I'd appreciate. Thanks again, Andries