I've created a database in FM Pro 9 Advanced to pull new information daily from a Tivoli backup server's database. This information is then used for quick reference and reports. There are multiple FM scripts setup to send different select statements via ODBC to the Tivoli database, and the information is stored in various FM tables. As a note the Tivoli database accepts simple select statements but is not fully SQL compliant, and thus TSM tables cannot be set up to act as local FM tables.

My problem lies in the fact that I must deliver this database and any updates to two other Tivoli administrators. Each time I do this I have to go through every script and allow the user to change the ODBC user ID and password. Very frustrating

Can a script be written that allows the multiple-embedded ODBC logins to be set once at start up by the user? Does FileMaker Server solve this problem?

Well, no need to wait for a reply here. After a lot of study it seems pretty clear that putting the database on Filemaker Server will allow me to just create and use a system account for the ODBC logins and then the other users can use a web login authenticated through Exchange.