it seems to me that PSoS should be immune from client version. Can you make a simpler on-server script work? Say, setting a field to "Hello World"?
Their disdain for real world ODBC is very frustrating because on really technical issues they are the only ones who know exactly what is going on on the FM side calling the action.
Filemaker server is immune from the FM client version itself but ODBC requires a DNS set up and FMS cant open a 32 bit DNS and FMA 32 bit cant put a 64 bit DNS in the Import Records script step. To add insult to injury, The FMS Script Engine is 32 bit even though Server is 64 bit. Go figure.
that is frustrating.
2 of 2 people found this helpful
FMS15 has 64bit script engine. Get ( ApplicationArchitecture ) returned "x86_64" on PSOS.
1 of 1 people found this helpful
I would be embarrassed but no one else thought of it so here goes - My DSN setup was configured in the USER window which means only I can use it. When FMS goes to use it, it fails, I set up the DSN in the SYSTEM tab which allows anyone on that computer to use it and IT WORKED! and best of all, it worked with the free drivers!
also, it appears the DEVART 64/32 bit combo ODBC driver wants people to buy the server license to set up a System DSN.