Search here or MSDN for "DSNLESS connection".
Here is an example that does not requere preliminary settings on the user pc.

create database myaccess
create connection myaccess ;
connstring;
'Driver={Microsoft Access Driver (*.mdb)};'+;
'DBQ=f:\appls\rpm_vfp\db1.MDB;'+;
'DefaultDir=f:\appls\rpm_vfp'

CREATE VIEW dbview CONNECTION myaccess AS ;
SELECT * FROM RPMEXCELInput

use dbview


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