>I am trying to access an AS-400 database using ODBC. So I created a DSN named "Test" and used the following as connection string

>Is there any way to acheive the above without creating the DSN?

Check out the SQLStringConnect() function. DSN-less connections are definitely the way to go when possible, since you don't have to create a DSN at each workstation.

Doug