Connect to an oracle database

Help
1

Hi,

I am trying to connect to an Oracle database that isn’t on the machine that I am developing the robot.
I have a user and password, but I can’t connect.

I am using the below connection string:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));
User Id=myUsername;Password=myPassword;

Any idea what I can do to connect?

Thank you,
Catalin

2

Is this helpful?

A list of Data Providers can be found at:
_Microsoft Learn: Build skills that open doors in your career

Do you have the Oracle ODBC adapter installed?

1 Like
3

Did you every get this solved? I"m trying to do the same thing and having difficulty…