I am using a program called UFT One which I beleive uses VB Script for it functions

I have a function which connects to an Oracle Database using ODBC in Windows (which works) however since they just changed the password and put a semi colon in it, I can not get the password to work properly wrapping it around any sort of quotes as advised when I searched for the issue

When I do that, I am getting the error:
“[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified”

here is my original connection string:

getConnectionString = "DRIVER={Oracle in OraClient19Home1_32bit};DBQ=<IP_ADDRESS>:<PORT>/<SID>;Trusted_Connection=Yes;UID=<USERNAME>;Password=<PASSWORD>;Connection Timeout=600"

So when they changed the password that has a semicolon: ie XXxxxXXXX;XXX I got a username/password incorrect error as the password was truncated at the ; in the password

I have tried the following suggestions:

Password=""XXxxxXXXX;XXX";Connection Timeout=600"

Password='XXxxxXXXX;XXX';Connection Timeout=600"

Password={XXxxxXXXX;XXX];Connection Timeout=600"

Password=XXxxxXXXX%x3BXXX";Connection Timeout=600"

the last one just gets incorrect password as it’s passing through %x#B instead of ; but all the others gets me the Data source error so it seems it doesnt like the double quoting, single quoting, {} and doing this stuffs up the rest of the connection string

When I debug the code I see for the double quotes it does pass the connection string through as just one pair of double quotes ie

getConnectionString = "DRIVER={Oracle in OraClient19Home1_32bit};DBQ=<IP_ADDRESS>:<PORT>/<SID>;Trusted_Connection=Yes;UID=<USERNAME>;Password="XXxxxXXXX;XXX";Connection Timeout=600"

Tried all wrapping passwords in “”, ‘, `, {}