See ODBC DSN Class File #9749 or you can use DSN-less connection.

>Dear All
>
>Is it possible to setup ODBC connection programatically? I am using Report Manager and on the production machine I have setup the ODBC to look in a particular directory for the DBC.
>
>Now on the clients machine I can do so manually and alls well. But I would like to automate this process, so as to remove the chances of errors. I can do this at the application startup, this can assure me that I know the path from where the application is starting and thus I know relatively where the data is lying.
>
>Could anybody share with me a way to do this programatically.