Connect to an oracle database

database

#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:
http://msdn.microsoft.com/en-us/library/a6cd7c08(v=vs.100).aspx

Do you have the Oracle ODBC adapter installed?


Database Activity Query, How to do this
#3

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