Filemaker Server ODBC Connection to 32-bit SQL Database
I am trying to make an ESS connection between Filemaker Server and another program Called Sage ERP MAS 200 (they use 32 bit SQL).
I am able to connect and read the table using Filemaker Pro 12.(I had to setup the 32bit ODBC manager and not the 64bit)
Now that I want to use the database in Filemaker Server; it doesnt work. At first I got this error
[ODBC Driver Manager]The specified DSN contains an architecture mismatch between the Driver and Application
Then simply got an error saying that my username and password cannot be used to access that Database
Also Filemaker server only sees the 64 bit ODBC DSN, thus I had to create a DSN with the 64bit ODBC manager just like I did with the 32bit ODBC manager. I have the same exact setting setup and connection is successful in the test connection window.
Can someone try to help me figure out what I am doing wrong. The connection is fine with Filemaker Pro but gives me credential issues using Filemaker server.