JHaughey

Already got it figured out. Apparently the DNS server on the new virtual server grabbed 5003. We disabled the DNS, and successfully reinstalled the software, the turned DNS services back on. I'm glad I don't have to leave the country. As an American right now, not sure where I could legally go.

We are moving our FM 16 Server to a new virtual machine for the eventual purpose of upgrading the OS and getting to the most recent FM version. After the virtualization yesterday, FM Services would not start. I am attempting to uninstall and reinstall the software, but I am running into a roadblock. "Ports 50003 and 50004 are not available. Make them available and try again." Not sure how this is possible, since the firewall on this machine is entirely off. Would appreciate any help so I don't have to leave the country.

Our company sends emails to client reps with FMP URLs that take them to the relevant database record. We have been using the tinyurl webservice to shorten the FMP URL with success for some time. Since the most recent Windows update, however, we are getting no result from the insert from URL request. I'm sure it is related to the update, because the when the insert from URL is requested from a client machine that has not run the update, the tinyURL result comes back with with no problem. Does anyone have a similar experience or can anyone suggest a fix or workaround? Thanks, John

We found a workaround, which is to select "print as image" in the advanced tab of the print dialog. Still would love to know what this is about if anyone has any ideas.

We have recently upgraded to FM15 Server, and most client machines to FM15 Pro. Since then, we are having strange problems printing PDFs created in FM. The PDFs will not print to desktop printers connected to individual machines by USB. They will however print to our larger network printers. We've updated all printer drivers with no change. Any idea on what might be causing this issue? We've also been having another pdf issue since the upgrade which I will save for another thread. Many thanks.

Oh! I will look into that. Thanks, Wim!

Hello Wim, Thanks for your reply. The ODBC driver is installed with the software package, and it is read only. If it's not a driver specifically supported by FM, and apparently it's not, I guess that means I'm just out of luck trying to do this.

Hello, I've created a DSN from the server hosting FileMaker Server 12, and using the 64 bit ODBC driver that comes with our accounting package, MAS 90. The connection tests successfully and all seems well with the DSN. It is seen by the solution and added successfully as an external data source. But when I attempt to actually add a table from that data source to the table occurrence graph, I get an error that states "The ODBC Data Source you have selected is not supported." Is this just a case of FileMaker and MAS 90 being incompatible, or is there something else I'm missing? Any suggestions? Thanks

Yes! Thank you! The other users have a different menu set, so not privilege set related at all.

Hello all, I'm having a problem with users being unable to copy/paste text into or out of my FileMaker solution that has me puzzled. The solution is built in FMP12 / FMS 12, and the machines are Win7. When I am logged in with full access privileges, I can copy and paste anywhere with no trouble. When logged in as a different user, with a different privilege set, I can not. Instead of pasting the copied text into the field, it pastes what appears to be some kind of control character. Both privilege sets have "Available Menu Commands" set to ALL. What am I missing? Any help is appreciated. Thanks, John Apologies if this in the wrong section. Posted here because it appears to be related to privilege set. Please move if inappropriate.

Hello Wim! Thanks for your response! That's a great checklist which I will take up with the network admin and her backup.

Hello all. Obviously, it would be ideal to host FMS on a dedicated server as recommended. What if this is not possible for budgetary reasons? What are the dangers? What sort of issues can I expect to run into? Thanks for your advice. John

Matthew - Thank you! I was getting an ODBC error that referenced the old database name, and had a sleep deprived 1:00 AM panic attack about it, I figured out what the error was when I woke up, Sometimes you're just better off going to sleep!

I am moving a FileMaker solution which been in development for some time from a development database to a production database. (The solution uses an external SQL database.) After building the solution on the development SQL db, I just got my first look at the production db, and discovered something I did not anticpate. Although structurally the same, and with identical table names, the SQL database itself has a different name. Is this going to be a problem? How big? Thanks for any advice.

Thanks, Wim. We do have the encryption logic, and I have a feeling that he will insist on using it. However, I will certainly take your advice and push for a user group.

Hoping someone can help with this. I'm working with a company that has a website. They would like to at least partially replace the functionality of the site with a FM GO iPad interface accessing their SQL data. We would like to use the existing website logins which sit in a SQL table, including encrypted passwords. External authentication, at least as I understand it, isn't possible because they do not run Active Directory or the like on the server machine. The administrator has expressed extreme reluctance to create a directory on the server which would include non-employees. (The FM GO application is for both employees and clients) Is there any way to use those existing logins for authentication in FileMaker without creating a directory or a user group on the server?

Is there any way to send data to a SQL sproc from FM GO? Calling the sproc directly seems to be out since you can't use EXEC SQL from the mobile client. So, I thought we would insert data in to a sql table and feed it to the sproc with a trigger. Then we discovered this nasty problem: http://help.filemaker.com/app/answers/detail/a_id/7870/kw/ESS%20best So, I am out of ideas and turning to these esteemed forums. Any thoughts are appreciated. Thanks, John

Thanks, Trey. It's a number. (int) After boldly declaring that my key field was unique, of course it turned out not to be. Something about the way the joins were put together in the SQL query created a situation where in some odd cases duplicate values could be returned. I added a row_number to the view to guarantee a unique key. If nothing else, I sure learned some SQL this week!

This is freaking me out - a little. I have a SQL ESS View with 15 fields in it. When I do a find in that table, it produces bizarre, wrong results. For example if i do a CTRL + F find, and type "5" into a field, it produces multiple records where that value is something other than 5. Has anyone encountered this before? I thought it might be an indexing problem, but I confirmed that the field I am using as an index does contain only unique values. The index field is a row number that gets assigned in the SQL query that produces the view. Is that an issue? Any thoughts are appreciated.

I have a FM GO layout with a portal. The portal show records from a a SQL ESS table (actually a SQL view) The relationship is built something like this: uiProject = sqlProject uiClass = sqlclass uiType = sqltype The UI fields on the parent side are all global fields set by the users choices. All of this is fine. The trouble comes when I want to add an additional relationship to serve as a filter. uiLine = sqlLine The reason this is a problem, is that sometimes sqlLine is empty or null. So, while I can create the relationship and get the filter to work properly, I can never show all records. The usual way to do this in FileMaker would be to create a calculation field on the child side, something like calcSqlType = sqlType & (return) & "ALL," then set uiLine to "ALL" in the appropriate circumstance. That won't work with ESS table because while you can create the calc field, it will always be unstored, and so not useful for a relationship. The other filters (uiClass and uiType) work because the child side fields they are related to are always populated and within a finite range. So, if the filter is clear and I want to show all records, I can set the parent side global to ""1" & (return) & "2" &" etc. That feels clunky, but it works. I hope my pre-coffee brain has explained this clearly. Any suggestions on how to do this are welcome and appreciated.

I am taking .csv variable data files created by data processors, determining which fields are populated and which are not. Then sending the first 10 records of just the populated fields in a readable fieldname:value format to a printer. Secondly, the same data is written to a Word file as a backup in case there is a printer issue, or the hard copy is lost/damaged, etc.

Hello Bruce, You're correct. This is a separate and discrete process from our FileMaker solution. So, yes, it might have been better done with some kind of .Net filestream programming. My C-sharp is rusty and choppy enough that I thought it would be quicker and easier to just whip something up in FileMaker. In fairness, the Filemaker process was pretty easy to put together, and it works well enough, it's just that I'm left with some debris when it's done.

Thanks, Barbara. The reason I'm creating new tables is that I don't know ahead of time how many fields each .csv file will have. They could have anywhere from just a few up to a few hundred. If I create a new table for each, then the number of fields is tailored to the number of fields in the file. I guess that's not actually all that important, though. What would you suggest? Creating one temp table with enough fields to accommodate the files with the largest possible number of fields?

Thanks, Lee. Not sure if that's exactly the question, though. I'll explain. I have a timed script that looks at folder on the network every 10 minutes. When it finds that there are files there, it imports each file into a new table, does some processing, and spits out another file in another place. So, as the last stage of this process, I can obviously go through with a "cleanup" script that deletes all the no longer needed records, but I will still have all the new tables, TOs, and layouts accumulating. Is there anyway to dispose of them by script? Maybe it doesn't matter much since there aren't any actual records? Thanks,

Is there any way to script the deleting of layouts and tables, or must it be done manually?