Connect VBA scribt with Oracle DB

Connect VBA scribt with Oracle DB

I have the following code to open the connection between VBA scribt and
Oracle DB. But when I try to run it I faced following issue "provider is
not installed". So what I can do with a provider and form where I have to
install?
Also could you please verify the source? Is this is the right way to do it?
dbMyDBConnection.ConnectionString ="Provider=OraOLEDB.Oracle;Data
Source=AAAA@//111.11.111.1:1521/TTTT;User ID=" & strUsername &
";Password=" & strPassword & ";"