Sorry didn't read you're reply properly. What is DSN-Less connection and how can I proceed with it? Any pros and cons?

>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.