teppo

And, for us here, upgrading to 7.0v2 fixed our ODBC 2306 tcp/ip connection refused error. Hallelujah!

>>Could IT have done anything to the software on the boxes when they were moved? << That's part of the whole strangeness of it all. I was the guy who did the unplugging and plugging back in. It was purely a physical move. And, yeah, FMS is in the foreground. The machines are dedicated to running the server software. I'll see about getting a sniffer in the chain and watch for something odd. Thanks. -mark

IT would swear that it isn't a hardware problem. The machines all respond to pings when FM server stops functioning. The applications continue to function and users who are logged in are still able to move about in records and make changes to the Databases. If it was a hardware problem or a cabling problem, I would expect to see more symptoms across the board of loss of network connectivity or machine functionality. The network cables are new (and fresh out of plastic), the network patch panels are new. The switch which these machines collapse back to is new. And, of the fifty other devices which were moved into that same room, none of them are experiencing any network dropouts. And, these machines worked fine for a week after the move. So, I'm not so inclined to think that it is hardware, but I'll give that some more consideration. -m

Okay, so here's where I'm trying to go: We're trying out some ODBC connectivity overnight to some DBs that needs to run on a machine that has a forced restart in the middle of the night. The simple trick is to get the appropriate database open with ODBC connectivity on (which doesn't appear to default or remember once you close the database) without human interaction. I've banged my head a while with Applescript and now I'm looking for some help. Here's the questions: 1) Is there anyway to simply get the RADC to default to being "on" for a single database when it opens? 2) If not, the obvious choice (well, to me) would be to script turning it on. The trick there is how to write the Applescript that would accomplish this. Again, the obvious route would be the turn record on and do the steps, but that doesn't seem to work. Am I missing some step that would make FileMaker recordable? 3) I can get the step to actually open the Sharing dialog box, but I've got no idea how to tell Applescript to check the silly box. Prefab Player (as much as I scanned its documentation) seems to indicate that I just need to use "click checkbox" syntax, but I'm not getting that right. Anyone got any ideas? Running FM 5.0v.3, OS 8.6 on an iMac, everything else is pretty vanilla. Suggestions, URL, pointers would be much appreciated. -mark