I am attempting to write an interface to insert records into FM Server from another data source when they are inserted in SQL. I have the ODBC installed and I can see the datasource using credentials when testing the ODBC source to the FM 12 server, however the scripting capabilities I am given on the source side cannot specify a username/password during runtime and therefore the script fails when running in an automated means. Is there anyway to disable the username/password for the FM ODBC or a way to store the credentials...even if there is a registry hack... I would be willing to do that.. This is driving me crazy!
Thanks in advance!
I assume that you are running Windows, in which case you can store the username and pwd when you create the ODBC data source (DSN).