Yes I have tried Windows download for Filemaker Server 15.0.2 64-bit drivers (Filemaker ODBC Driver (64b-bit) 126.96.36.199).
My server is 188.8.131.52.
If I try to connect to the host : "There was a problem connecting to the host".
Test Connection says:
Attempting to connect to database on host x.x.x.x
Filemaker Failed to connect to listener (3)
I have had cases where the Test Connection does not work, but when I put a ESS table in my relationship graph and start using that in a new layout it works just great. Have you tried that?
With Filemaker ODBC Driver (64b-bit) 184.108.40.206 installed I can't define sql server database information. So I must leave System DNS name without database information and just close ODBC data source Administrator.
In Filemaker Pro Relationship graph “Add Table” “Add ODBC datasource” shows that ODBC DSN Data source but because both database and login information is missing in Filemaker server Filemaker Pro now asks login information. If I supply login information I get error "ODBC Comminication/link error. Please check your network connection and/or database server”.
Result: ODBC System DSN name is available in Filemaker Pro but no connection to database.
You shouldn't be using the FileMaker ODBC driver. You should be using the MS SQL Server ODBC driver. The following is a screenshot from our Dev server. you can see that we're using SQL Server drivers as that's the back end database we're trying to connect to. Once you've configured the DSN then you can add it as a data source in FileMaker.
The FileMaker ODBC driver is only used in circumstances where you want to use FileMaker as an ODBC data source. Not for ESS.
Vesa, non-supported SQL drivers *may* work for using these script steps:
Your Mileage (Kilometers) may vary, of course
While not the ESS, it's useful when you can connect.
Now I changed to Microsoft SQL Server ODBC Driver Version 06.03.9600 (64 bit).
Filemaker server: I can authenticate by username and password and the connection test is ok.
Filemaker 14 Pro: I can add ODBC data source and try to connect to ODBC data source. ODBC connection asks again user name and password.. I hope not with all new users...
And the connection works!
Thank you for your help!