Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection to AWS Oracle RDS

user9177351Jan 27 2021

Hi, I have an application in VB.NET that needs to connect to an AWS oracle database. My connection string downloaded from AWS is this:
(DESCRIPTION_LIST= (LOAD_BALANCE=OFF) (FAILOVER=ON) (DESCRIPTION= (SOURCE_ROUTE=yes) (ADDRESS= (PROTOCOL=tcp)(HOST=eu1.ocm.og.vpc.XX.com)(PORT=80))(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXX.YYYYYYY.eu-west-1.rds.amazonaws.com) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME = XXXXX))) (DESCRIPTION= (SOURCE_ROUTE=yes) (ADDRESS=(PROTOCOL=tcp)(HOST=eu2.ocm.og.vpc.XX.com)(PORT=80)) (ADDRESS=(PROTOCOL=tcp)(HOST=XXXXX.YYYYYYYY.eu-west-1.rds.amazonaws.com)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME = XXXXX))))
Using SQL Developer I can connect without problems, but from my project in VB.NET I have this error: "ORA-12541: TNS: No listener". I tried to simplify the connection string, but still i can't connect from my project in VB.
what could be the problem?

Comments
Post Details
Added on Jan 27 2021
3 comments
1,347 views