[RESOLVED] dsn-less connection string

[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].
I got the following from connectionstrings.com. How do I make it dsn-less?

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

This is what I currently use:

    'Create DB connection
        Dim myDb As New ADODB.Connection
    'Create a new recordset
        Dim rsTemp As New ADODB.Recordset
    'Open the DB using the clmSystem argument as a string
        myDb.Open "DSN=claimsDB;SERVER=QACLMS01.DB;PWD=" & clmSystem & "_user;UID=" & clmSystem & "_user;"

Thanks for your help.