If these would be found in the registry as values, then yes you can pass them as parameters. First set up a DSN thru the Control Panel then look in the Registry to see all the parameters that were created for that DSN. Any pairs in there can be passed in the configuration string -- e.g., ('...;uid=myuserid;pwd=mypassword;server=sid;someparm=someval')

>Hi Mark,
>
>Hey will this allow me to specify the indexes for each table as you can do in the control panel? Thanks. -Rick
>
>>>Is there an API that will allow me to set up an ODBC DSN?
>>
>>Download my ODBC DSN Class from the Files Section, Win32/API category. Read the comments at the beginning of the ODBC.PRG. The free Registry class from West-Wind is also required to use this class.