Hi, it looks like instantclient_12_2 may have different names for each entry, such as serverName instead of Host. If that's the case, I'd suggest to setup the connection using the Windows ODBC GUI and then just calling that new DSN from your code.
Yes, i have my machine set up this way, and everything works fine, but that really isn't the problem/question.
i want to connect using the syntax above, for reasons i won't trouble you with (mostly related to not having permissions to my machine) so i want to understand what i need to change in the dbConnect function to make this work.
Oh ok, my guess would be to find out what the driver uses as the parameter names for the connection. My suspicion is that it uses alternative names for Host, SVC, uid, pwd, etc. I'd recommend a search of generic connections, as in outside of R, using the instantclient driver, and see if anyone has posted their connection string that tells you what each parameter is called