I have setup a system DSN (have the server IP address, DB Name etc) and used in the ADO connection

ADO.Open "DSN=xxx",

If the user do not have this DSN installed, then it cannot be run.

My question is :

How should I change the statement, so that I can hard code the IP address, DB name etc in the ADO.Open statement

Thanks for any hint