Discussion created by taylorsharpe on Nov 20, 2012

Has anyone else linked FileMaker with a SAGE MAS 90 accounting database? This is the older accounting versions that I think is based on OpenBase SQL. I have the ODBC 4.0 driver installed and working and I can run manual imports using the FileMaker client. But what I want to do is automate imports with a schedue script on the server. What I can't seem to do is get past the requirement of the ODBC driver that prompts you manually for a User ID and password, which a server side script can't do. I have put the User ID and password in the ODBC DSN, but that did not solve the problem and it works the same as when you don't put the User ID and password in. Any suggestions?