I know I could accomplish what I need by changing Privilege Sets and/or by making people sign in with different usernames. I have attempted the above trying various Get functions, but do not have anything reliable figured out. Or: How would I have a script do one thing if they were on-line, and something else if they were off-line? Or: How would I send a user to a particular layout when they are using the off-line version? What command would I type into the "Hide Object When " option so the button would only show on the off line version? I do not want this to show on the live database, but do want it to show on the off-line version. There is certain functionality I want for off-line users, but I am not sure how to detect when they are off-line/using the off-line version.Įxample: The "Sync" button. The mirrorsync will be used on iPhones, iPads and Laptop computers. I will have users accessing our database through both direct on-line connection to it while in the office, and then using mirrorsync when leaving the office. I hope someone can help me with an elegant solution on how to make my database MirrorSync aware. Is there a workaround to solve my Is it possible to use an variable for defining the length of the pause/resume? Is it true, there is no build in way to do a find / replace inside a filemaker script? Well, the pasted MirrorSync script has more than 10,000 lines and I'm not sure if I cought all occurances of the above expression. If I replace the value with 0,1 the value is accepted and displayed as ,1.Īfter replacing all occurances of "/*0.1*/" with "0,1" the script worked for me!Īs my server (where I also generated the MirrorSync script steps) is located in germany, it seems to me the that I have an numberformat issue. If I try to uncomment the value 0.1, the value is not accepted. If you use the Specify Calculation dialog box to determine the duration, the calculation result must be a number or your script will not pause." it seems to me as the script paused indefinitely. Though the documentation of Pause/Resume says: ".The For duration value must evaluate as a number, which is the duration of the pause in seconds. The clients debugger shows me that the script paused at one of the many occurances of the following lines: The Sync doesn't work, the program hangs. When I setup MirrorSync 2.5 in April I had no problems to get things working.Īfter a longer break I tried a very similar setup with MirrorSync 2.6, Build 8823 a few days ago and ran into problems. How do we know what JDBC driver Mirrorsync is using? Only true or false can be used." as if we didn't write "true" in the first place. Without, we get error message that "The authentication Scheme JavaKerberos: is not valid" or without the javaKerberos clause, that "The property integratedSecurity does not contain a valid boolean value. Server is configured for Windows authentication only." Reason: An attempt to login using SQL authentication failed. Name and password should not be necessary for integrated security, and if we provide them, SQL Server logs error as "Login failed for user. JDBC URL: jdbc:sqlserver://:1433 integratedSecurity=true authenticationScheme=JavaKerberos JDBC Driver Class Name: .CustomJDBCProperties We have tried using the entry for JDBC Database, like this: The article shows syntax of connection URLs even for Windows integrated authentication - but to no use, as this field is not open for editing in the MirrorSync configuration dialogue for SQL Server. Update: We may seem to succeed with Oracle now. What documentation or other advice is available? SQL Server is set up to use Windows authentication (that is, accepting a login based on AD entities). We are trying what we believe is the correct connect string(s) towards Oracle. What conditions have to be met by Oracle and by SQL Server for MirrorSync to be able to connect? We are beginners in JDBC, and we sorely miss documentation for the topic: Trouble is, MirrorSync will not connect by JDBC to either Oracle or SQL Server. We are trying to use MirrorSync 1) for two way synchronization of FileMaker tables with tables in Oracle server, 2) for one way synchronization from a view in SQL Server to a table in FileMaker.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |