Quote Originally Posted by nadia
I need to create a db connection to an oracle db using vba[6.3], but I need to have it dsn-less [-what I currently have is a pain b/c I have to set up the odbc connection on other machines].
Why don't you just create the ODBC DSN connection programatically? The link shows how to create a ODBC DSN connection for SQL Server but I am sure that you can adjust it to create on for Oracle.