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:
Set Variable [$$marinaDir; Value: "MarinaPro v17"]
Open File ["Marina"] (Marina File Path: filewin:/C:/$$marinaDir/Marina.fmp12)
What am I missing?
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.
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.
Files are named with an extension other than fp7
DB files are on separate HD than FM Server (still on the same machine)
Who Viewed the Topic47 members have viewed this topic:Richard Carlton Jw1954 Ron Cates Simplidata Ve Old vwdubb Golden Mean lucroels Jonathan Ackerman Aussie John wendykdt Jeep Watson doughemi KaneM stan111 Ocean West ADM mr_vodka Fitch Josh Ormond Daemon trevix cat traveller Junior360Works Cenk Yüksel IdealData Lee Smith Goldrush Nippon Maru jl2017 AlanTrewartha gwjo normanicus Barabba Will Loving the Otter prosoft a7madmotaw3 BruceR Rick Whitelaw KelseyMcHenry -dp- Joost Miltenburg MikeKD Wim Decorte ltwimberly JerrySalem