To set the default to NEVER PROMPT for any future attempt to create a connection, use 0 as the ConnectionHandle:

? SQLSetProp(0, 'DispLogin', 3)

>Thanks guys,
>
>This will do the trick. One more thing how do i disable the ODBC Login Dialog.
>If ORACLE SERVICE or TNS Listener are not running then before i display user with my messagebox, ODBC login prompt comes up. I know i can disable this but only if connection is established.
>expl. SQLSETPROP(cConnectionHandle, 'DispLogin', 3)
>Any ideas how to avoid this?
>
>Thanks
>
>Dejan