Jump to content

Data Separation Model - Updating Data Source

This topic is 2009 days old. Please don't post here. Open a new topic instead.

Recommended Posts

EDIT: Nevermind. Apparently it was a problem choosing the file from the server under favorites; when I went to local servers, selected the server, and then the file, everything worked fine. 




I've got a couple of solutions both using the data separation model. I was hosting all files on our server, but decided to deploy the interface files on users' local computers. For one, I downloaded the interface file, and edited the external data source from "file:databaseName" to "fmnet:/ourServer.local/databaseName". Once I did that, everything worked fine. 


I tried doing the same thing, but that didn't work. I've tried deleting the entry in external data sources and re-adding it, but even that is not working. I keep getting the error:


The file"clientMatters_data.fmp12" could not be opened. Either the host is not availabel, or the file is not available on that host."


But our server says the database is up and running. Any ideas about why I had no problem with one file and no luck at all on the second file?


Any advice is appeciated.








Link to post
Share on other sites

This topic is 2009 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By Mary Weldon
      Does anyone have experience using FM11 with SQL2012? I successfully established an ODBC connection between our FileMaker 11 Server database and a SQL 2012 database. I now have a live connection allowing us to exchange data between tables. However since FileMaker does not specify support for SQL 2012 should we be concerned with utilizing this connection? Please advise!
    • By JH Howland
      I have created an "opener" file called "OpenMP" that is located on the Windows Desktop.  Also, a global variable for the directory where the FMP14 files are located called "$$marinaDir" = "MarinaPro v17".
      When activated the launcher opens but does not open the target file using the following file path, "filewin:/C:/$$marinaDir/Marina.fmp12."  However if I substitute with the following, "filewin:/C:/MarinaPro v17/Marina.fmp12"; all is good.
      The script elements follow:
      #Create variable...
      Set Variable [$$marinaDir; Value: "MarinaPro v17"]
      #Start MarinaPro...
      Open File ["Marina"] (Marina File Path: filewin:/C:/$$marinaDir/Marina.fmp12)
      What am I missing?
    • By sbbutkcin
      Has anyone had any luck with connecting the filemaker 13 databases with databases on FileMaker 11 using fmnet in external data sources? I tried to edit the existing references by adding .fp7 to the end of the filename and tried to create a new data source. However, when adding the remote server, it does not display any databases (as they are not compatible) and I unfortunately cannot convert them at this time. 
    • By Jeff777
      I have a 45 file solution currently running on FM Server 11 Advanced that was originally built in FMPro 5-6 (by someone else). All of the External Data Source paths are set to use relative (file:filename) paths only, but the Source File listed in the TO's is using the "fmnet:/IPAddress/filename" path - in the case of one table its even "fmnet:/*/filename".

      Logically it seems this would be a performance problem if the db files, which are all in a single folder on the server, are having to resolve the fmnet path rather than just using the relative path. I know the * in the path is a major no-no.

      If I go to External Data Sources and add a source by navigating to the file through the Add File... > Remote selection, the file is added to Data Sources with the relative path, but the TO still has the fmnet path, so it's not just the pre-existing TO's - even the file with the * in the path comes over that way every time even though in the Open Remote dialog where I select it to add it displays the full IPAddress. So I can't just redo all the data sources.

      Never seen this before and can't find anything online. I manage/develop several other solutions and the TO's all use the relative path, so this concerns me. We're currently rebuilding to take advantage of more modern features and to address performance issues we're experiencing as we grow - so I want to get this right.

      If anyone knows what's going on - especially if there's a way to correct this, I'd appreciate any insight.

      Other details
      Files are named with an extension other than fp7
      DB files are on separate HD than FM Server (still on the same machine)

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.