Storing ODBC Settings

[TechRangerBrad]

Hey,

Is it possible to store ODBC settingss in FM? I am creating a custom app in which I would like to run a script for record import, but I want users to only have to run the setup once for ODBC. Then have the script step reference the ODBC settings table. Am I as clear as mud?

B

[Leb i Sol]

Not really. But you can advise them to use use the same DNS name and u/p. Then you can store this in your script and run it without dialog.

So make it mandatory to use pre-determined DNS/ODBC name.

================================

If your users are really not capable of making/defining ODBC connection then:

1) If on windows you can make "your_own.exe" and embed it into the container field. "Your_own.exe" would be a file that simultes keystrokes and would essentially create a DNS/ODBC connetion for the user. Look into utility called Auto-It.

2) if on Mac then not sure look for simmilar utility

[philou54]

There is no way to store ODBC setting, but I guess with an applescript from Filemaker you can launch the ODBC administrator on Mac. It's the prettiest way to allow users to change ODBC settings I think.