AnsweredAssumed Answered

Sage Line 50 ODBC to Filemaker on Windows 64 bit

Question asked by Stu412 on Mar 8, 2016
Latest reply on Mar 8, 2016 by Stu412

Hi all


I suspect this has been asked 100 times before but I cannot get this to work.  This is very new to me.


I'm looking to connect Filemaker to Sage Line 50, version 21 on Windows 64 bit.  I want to use FM as the system to download data from the tables in Sage. 


I've created a DSN using the ODBC32.exe in Windows/SysWOW64 which is what I've managed to find from other forums.  It's only by using this method that the Sage DSN becomes visible in Filemaker File>>>Import>>>ODBC.  (If I create a DSN from the Windows control panel, I cannot see it from the File>>>Import menu in FM).


So now I can see the DSN, but I cannot connect as FM is asking for a username and password which I've not specified.


If I specify a Sage company.000 file in the DSN path set up, I'd expect to be able to enter the same password that I use to enter this in Sage (in this case, 'Manager' as a username with no password), but this does not work from the FM side.


So given all this I'm completely stuck and would love any help on this!


Thanks in advance