xDBC is turned on in the FMS admin console? And it stays toggled on?
Is this Windows or Mac?
Mac 10.10.3 all is toggled on, the dot next to ODBC/JDBC is on, on all solutions in question.
The dot next to the file name just means that there is an fmxdbc extended priv bit toggled on, it does not mean that the server itself is configured to allow xDBC connections. In the admin console, under General Settings, on the ODBC/JDBC tab, is it toggled on? And does it stay on when you navigate away and then come back?
Yes, it is toggled on, left checkmark is green, right slider blue with I. which means on.
Already did restart the machine, tried fmsadmin restart xdbc. Mind you I'm running OSX Server as well but with websites disabled. Only AD. CWP and WD are running ok.
Hmm, DSN is a bit picky. It looks like it's working when I run the test. Still no databases show up in the list.
I guess you have to follow through till the end.
You didn't mention the plug-in so I figured it should be working...
So what is it about the xDBC plugin and the permissions?
Should the driver be defined as system or user or does it not matter?
As soon as I set up a system DSN the driver switched to system...
Thanks for your input!
Plug-in is used FM12 and prior. Where do you referring from? HELP file of FM13 don't have the sentence.
ESS need system DSN, user interaction by now logged in to the OS user can use user DSN.
This document is for FM9..14, but "Last Updated: Nov 13, 2014 12:58 PM PST" really on the date FM14 was there?
It is mixture of version independent (port number) and specific (connections) things.
FMI seems a bit lazy or shortage of workers for documentation...
That's what I thought. I think there used to be a separate plug-in. It seems to be merged into the app now. Still a bit confusing when coming across that and it is bundled together with help for all versions.
Sent from my iPhone
Yes, FM...12 has xDBC.fmx as plug-in, FM13...14 have fmxdbc_listener.exe as stand alone executable program.
Is port 2399 open?
Are you using the correct 32 or 64 bit driver?
It is working, at least when I test the connection in the ODBC manager. What was misleading was that the databases don't show in a list with the option "connect to get a list of databases"
Now on to using it with PHP with odbc_connect which is not working.