>Hi All:
> Is there a way I can write a code that would create a ODBC connection in my program. I do not want to go to each user and create DSN using ODBC drive, I want my program to chedk if the DSN name is there and if not create one. This will prevent me from createing DSN name on individual pcs.
>Thanks

You can also use DSN-less connections. In this case you don't have to install anyting on individual PC's.